AutoAdjustment Program (ARXAAP) Completes with Error - ORA-01422: Exact Fetch Returns More Than Requested Number of Rows - JL_BR_AR_OCC_DOCS_WRT_N_ABTMT2 (Doc ID 1904987.1)

Last updated on JULY 16, 2014

Applies to:

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

Symptoms

On : 11.5.10.2 version, Transactions Related

Attempting to run the AutoAdjustment program (ARXAAP) and receive the following error:

ERROR
-----------------------
going into FETCH of loop_ar_adj_cursor for all customers
A hora atual do sistema é 02-JUN-2014 09:58:57
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
going into make_ar_adjustment from lock_ps
****** AR-ARXAAP Diagnostic details
****** AR-ARXAAP-ERROR: Adjustment Type
****** AR-ARXAAP-ERROR: Customer Trx Id
****** AR-ARXAAP-ERROR: Receivable Activity Id
AR-ARXAAP: TAXACT ERROR- NO_DATA_FOUND Exception in Tax accounting routine
ORA-0: ORA-01422: exact fetch returns more than requested number of rows
ORA-Terminating program

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