Creating a Manual Adjustment Completes in Error - ORA-01422: Exact Fetch Returns More Than Requested Number of Rows ORA-6512: JL_BR_AR_OCC_DOCS_WRT_N_ABTMTZ ORA-4088 JL_BR_AR_OCC_DOCS_WRT_N_ABTMTZ (Doc ID 1366495.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions


Symptoms

Attempting to create a manual adjustment and receive the following error:

ORA-01422 exact fetch returns more than requested number of rows
ORA-6512 JL_BR_AR_OCC_DOCS_WRT_N_ABTMTZ
ORA-4088 error during execution of trigger
APPS.JL_BR_AR_OCC_DOCS_WRT_N_ABTMTZ
ORA-06512 APPS.ARPS_INSERT_ADJ_COVER


Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Transactions > Transactions > Query invoice.
Go To:  Actions > Adjust
Enter adjustment information and Save
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