Enforce in Oracle to disallow any special characters in the payee name
Summary:
Bank rejected PPR due to a special character (in this case an apostrophe) in the vendor remit name. We was required to void each payment in the file and submit a new PPR.
To avoid this, is there any feasibility
- Enforce in Oracle to disallow any special characters in the payee name or other field that would cause the PPR to be rejected (Or)
- Have Oracle perform a validation check on the PPR prior to submission to the bank to determine if a special character is included in the PPR.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Tagged:
0