My Oracle Support Banner

Error In Brazilian Payables Import Bank Collection Documents Program, ORA-01422: (Doc ID 1373899.1)

Last updated on AUGUST 16, 2019

Applies to:

Oracle Financials for the Americas - Version 11.5.10.2 and later
Information in this document applies to any platform.
Oracle Application 11i
LatinaAmerica Localization for Brazil
JLBRPICD.sql


Symptoms


On : 11.5.10.2 version, Brazil AP Globalization

When attempting to run the Brazilian Payables Import Bank Collection Documents Program,
the following error occurs.

ERROR
-----------------------
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 249

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

1. Responsibility: Oracle Payables
2. Path: Other -> Requests -> Run
3. Execute the Brazilian Payables Import Bank Collection Documents Program
The following errors appear in the output file:

ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 249

NOTE: There is nothing wrong with the data. The two records are in different countries (on BR and one null).  Therefore the duplicate numbers are acceptable.

4. The following select statement is in error since system has duplicate Bank Number
and Bank Branch Number combination.
This exception has not been handled in the Brazilian Payables Import Bank Collection Documents Program.

@Please check the duplciated information with the following:

5. There is a duplicate record for the combination.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the Brazilian Payables Import Bank Collection Documents Program

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!


In this Document
Symptoms
Cause
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.