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 JUNE 07, 2016

Applies to:

Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

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

Setup:
Responsibility: AR CPF_EMEA - Superuser AR Super User
MO: Security Profile = Organizations EMEA
MO: Default Operating Unit  = xxF
MO: Operating Unit = AROU

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 xxF org (default operating unit)
Error occurs

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms