My Oracle Support Banner

R12:AP: Invoice Validation Fails REP-0069, REP-57054, REP-1419, APP-SQL-AP-10000, ORA-20001 and ORA-1422 for Inclusive Tax (Doc ID 473363.1)

Last updated on MAY 20, 2021

Applies to:

Oracle Payables - Version 12.0.0 to 12.0.7 [Release 12.0]
Oracle Payables - Version 12.0.2 to 12.0.5 [Release 12.0]
Information in this document applies to any platform.
APPRVL - Invoice Validation


Symptoms

Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP

Unable to validate and invoice with multiple lines/multiple distributions due to the following error:

REP-69: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
ORA-1422: exact fetch returns more than requested number of rows occurred in
with parameters ( P_Invoice_Id = X P_Error_Code = P_Calling_Sequence
=  AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-)
while performing the following operation:
Step 7: Update Invoice Includes Prepay Flag
ORA-20001: APP-SQLAP-10000: ORA-1422: exact fetch returns more than
requested number of rows
occurred in
with parameters ( P_Invoice_Id = 12660 P_Error_Code = P_Calling_Sequence
= AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-)
while performing the following operation:
Step 7: Update Invoice Includes Prepay Flag



The problem occurs for inclusive tax.

On line validation shows the same error. 


Debug tax log file also contains the following:

Step 6: Update generate_dists on the invoice line
ORA-1422: exact fetch returns more than requested number of rows
"APP-SQLAP-10000: ORA-1422: exact fetch returns more than requested
number of rows occurred in
with parameters ( P_Invoice_Id = X P_Error_Code = P_Calling_Sequence
= AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-)
while performing the following operation:
Step 7: Update Invoice Includes Prepay Flag"
"ORA-1422: exact fetch returns more than requested number of rows
occurred in

Changes

 

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!


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