Bank Account Number Allowing Special Characters — oracle-mosc

Human Capital Management - EBS (MOSC)

MOSC Banner

Bank Account Number Allowing Special Characters

edited Aug 24, 2023 4:56PM in Human Capital Management - EBS (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center