Bank Account Number Allowing Special Characters
We are on Oracle 12.2.11.
The issue is that Oracle allows us to enter a bank account number with special characters which will result in the bank rejecting the payment file. Is there a way to prevent it?
I found a profile option 'PAY: Enable Personal Bank Account Validation' which when enabled asks the user to enter the bank account number twice (Re-enter Account Number field shows up). Though this does not eliminate special characters, I found enabling this will prevent any special characters from being entered mistakenly.
I am also looking for a way to allow only numbers in the account number field. Let me know if anyone was able to achieve this either by writing any validations on PL/SQL or OAF customization.