My Oracle Support Banner

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:
Responsibility: Receivables
Navigation:  Receipts > Receipt
Select receipt method: 'Bank Draft' from LOV options which is for xxx org (default operating unit)
Error occurs


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

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