My Oracle Support Banner

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 FEBRUARY 19, 2019

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

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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