My Oracle Support Banner

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

Last updated on APRIL 09, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.