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 SEPTEMBER 09, 2016

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:

<xs:element maxOccurs="1" minOccurs="0" name="CdtrAcct" type="CashAccount16"/>

This maps to the XML elements as below: 

<xs:complexType name="CashAccount16">
       <xs:sequence>
           <xs:element name="Id" type="AccountIdentification4Choice"/>
           <xs:element maxOccurs="1" minOccurs="0" name="Tp" type="CashAccountType2"/>
           <xs:element maxOccurs="1" minOccurs="0" name="Ccy" type="ActiveOrHistoricCurrencyCode"/>
           <xs:element maxOccurs="1" minOccurs="0" name="Nm" type="Max70Text"/>
       </xs:sequence>
   </xs:complexType>  

That is, the field only permits a maximum of 70 characters.

This means if a supplier bank account name exceeds 70 characters, the Customer Payment Status Report message will show the following:

File does not conform to the ISO20022 standards and is not a valid PAIN.001.001.03 file. (Error: Line No: &line_number. Position: &position. The 'urn:iso:std:iso:20022:tech:xsd:pain.001.001.03:Nm' element is invalid - The value &bank_account_name is invalid according to its datatype 'urn:iso:std:iso:20022:tech:xsd:pain.001.001.03:Max70Text' - The actual length is greater than the MaxLength value. )  

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.