My Oracle Support Banner

R12: AP/IBY: Supplier Bank Account Name Field Length Violates ISO 20022 CGI PAIN.001.001.03 Format Xsd (Doc ID 2050438.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Payments - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

In Oracle eBusiness Suite (EBS), when using the PAIN.001.001.03 messaging format, it's discovered the bank payments are failing for supplier bank accounts that are longer than 70 characters.

Analysis
In the Oracle table IBY_EXT_BANK_ACCOUNTS, the BANK_ACCOUNT_NAME columns' data type is VARCHAR2(80).

However, the </CdtrAcct> field in the ISO 20022 PAIN Format XSD is defined as below:

Business impact

Concerns regarding the count of potential data violations in the Oracle-seeded formats supposedly compliant with the PAIN.001.001.03 messaging format.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.