R12:JL: Imported Collection Documents With Error Code 02 - Invalid Arreas Code (Doc ID 1957750.1)

Last updated on JANUARY 25, 2017

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Brazil AP Globalization

When attempting to import Collection Documents from bank using DDA Statement Layout,
the following error occurs.

Error code 02 - Invalid Arreas Code

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Brazilian localization
2. Path: Other -> Requests -> Run
3. Run the Import Bank Collections Program (JLBRPICR.rdf 120.0.12010000.3 - latest version)
The following error occurs:

Error code 02 - Invalid Arreas Code

Document Number - Database Length is 10 whereas the mapping was for 15
Collection Document Instruction 1 – Database length is 30 whereas mapping was 44
Collection Document Instruction 2 – Database length is 30 whereas mapping was 44

4. Differences between length of columns on JL_BR_AP_INT_COLLECT_EXT_ALL table
and the Statement Layout definition :

DESC JL.JL_BR_AP_INT_COLLECT_EXT_ALL

Nome Nulo Tipo
----------------------------- -------- -------------
DOCUMENT_NUMBER VARCHAR2(10)
INSTRUCTION_1 VARCHAR2(30)
INSTRUCTION_2 VARCHAR2(30)

Citibank - DDA Statement Layout has different length about that fields

Nº do Documento de Cobrança (15)
Mensagem 1 (40)
Mensagem 2 (40)

4. After applying patch for BugDB:17282783, the following error appears:

REP-0004: Warning: Unable to open user preference file.
REP-1203: Field 'F_document_number1' references invalid column.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1203: Field 'F_document_number1' references invalid column.


The issue has the following business impact:
Due to this issue, the company is not able to import collection documents and complete the payments for suppliers.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms