My Oracle Support Banner

R12:JL: JLBRPECD Cannot Save A Collection Document Due To Error ORA-01403 (Doc ID 1559472.1)

Last updated on AUGUST 19, 2020

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 = XXXXXXX
Bank Number = ZZZZZ
Branch Name = XXXXXXXXX
Branch Number = ******
Supplier = AXXXXXXXXXXXXXA
Supplier Number = ********
Site = *******
Document Number = 1111
Amount = XXXXX

There is no workaround.


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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.