Unable To Create a Receipt for the Default Operating Unit in the Multiple Organization Access Control (MOAC) Enabled Responsibility
(Doc ID 1935245.1)
Last updated on NOVEMBER 20, 2020
Applies to:Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.
You are attempting to create a Receipt for the Default Operating Unit in a Multiple Organization Access Control (MOAC) enabled responsibility and receive the following error:
ORA-1403: no data found
FRM-40735: KEY-LISTVAL trigger raised unhandled exception ORA-01422
If you attempt to proceed further, entering details and save, the following exception error appears:
ORA-01422: exact fetch returns more than requested number of rows
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01422
Responsibility: AR Company Name - Superuser AR Super User
MO: Security Profile = Organizations EMEA
MO: Default Operating Unit = xxx
MO: Operating Unit = yyy
Responsibility: Application Developer
Navigation: Flexfield > Descriptive > Register
Query for Title = Receipt Information
Click on Columns button
Check that Only the Column Names = ATTRIBUTE1 to ATTRIBUTE 15 have Enabled checked - All others should not be checked.
Steps to Reproduce:
Navigation: Receipts > Receipt
Select receipt method: 'Bank Draft' from LOV options which is for xxx org (default operating unit)
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