R12:JL: JLBRPECD Cannot Save A Collection Document Due To Error ORA-01403 (Doc ID 1559472.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 create a collection document,
the following error occurs.

ORA-01403 no data found
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04062


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

1. Responsibility: Oracle Payables - 12.1.3
PRE PROD

2. Path: Brazilian localization -> Collection Documents -> Define (JLBRPECD 12.0.18)
3. Create a collection document and save.
The following error appears:

ORA-01403 no data found
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04062

For example:

Bank_Name = ITAU BBA
Bank Number = 341
Branch Name = FARIA LIMA
Branch Number = 7130
Supplier = ALGAR TELECOMINUCACOES LTDA
Supplier Number = 54572
Site = ALGAR
Document Number = 0546
Amount = 1000

There is no workaround.


The issue has the following business impact:
Due to this issue, users cannot create a collection document

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