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.
Version 12: Brazil Consulting Localizations
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
The Integrated Receiving approval should be completed without errors.
1. Responsibility: Integrated Receiving
2. Navigation: Receipts > Entry > Find: Fiscal Document
3. Click Approval button
Notice that the following error message will be retrieved:
Error: ORA-01422: exact fetch returns more than requested number of rows
Error: ORA-06512: at "APPS.CLL_F189_CHECK_HOLDS_PKG", line 10559
Due to this issue, Integrated Receiving Fiscal Documents cannot be completed.
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