Bank Account Validation (Forms Personalization): Increase Data Accuracy
Overview:
Our customer required bank account numbers to be validated at data entry according to local bank account number algorithm.
I.e. In New Zealand bank account numbers are of the form AA-BBBB-CCCCCCC-SSS where:
AA = Bank Number
BBBB = Branch Number
CCCCCCC = Account Number
SSS = Account Suffix
A given bank account number needs to have a valid combination of Bank, Branch and Account number.
Screenshot
Key Benefits:
- Accuracy/validity of Bank Account entry is enhanced.
- Logic can be switched on/off as required due to use of forms personalization
- Logic can be controlled on a site/responsibility level
- PL/SQL backend function and forms personalization setup can be extended to cater for multiple operating locations/countries
Key Decisions:
- Forms personalization used as opposed to forms or CUSTOM.pll customization/modification
- PL/SQL backend function to hide algorithm complexity
Ballpark Effort (Hours):
4
Developed on Version:
11.5.10.2