My Oracle Support Banner

Brazilian Integrated Receiving: Error "ORA-01422" and "ORA-06512: at APPS.CLL_F189_CHECK_HOLDS_PKG", line 10559 on approval process (Doc ID 2686702.1)

Last updated on APRIL 20, 2021

Applies to:

LAD Add-on Localizations - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Version 12: Brazil Consulting Localizations

Actual Behavior

While trying to approve a "Fiscal Document" on Integrated Receiving module, user receives the following error messages:

"Error: ORA-01422: exact fetch returns more than requested number of rows"
"Error: ORA-06512: at "APPS.CLL_F189_CHECK_HOLDS_PKG", line 10559

Expected Behavior

The Integrated Receiving approval should be completed without errors.

Steps

1. Responsibility: Integrated Receiving

2. Navigation: Receipts > Entry > Find: Fiscal Document

3. Click Approval button

Notice that the following error message will be retrieved:

Note

   Error: ORA-01422: exact fetch returns more than requested number of rows
   Error: ORA-06512: at "APPS.CLL_F189_CHECK_HOLDS_PKG", line 10559

Business Impact

Due to this issue, Integrated Receiving Fiscal Documents cannot be completed.

 

Changes

 N/A

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
Changes
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.