My Oracle Support Banner

R12:AP: Consolidated Note for Create Accounting Error: ORA-01403, XLA_AP_ACCT_HOOKS_PKG.MAIN (Doc ID 1311364.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Payables - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

When trying to submit the Create Accounting Process, one of the following errors show on the Accounting Program log file,
the specific problem package of each error message is displayed in bold as follows :


An internal error has occurred in the program xla_ap_acct_hooks_pkg.main. Technical problem :
Error encountered in product API for extract
ORA-01403: no data found occurred in
AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT
with parameters (&PARAMETERS)

 


ORA-01403: no data found occurred in
AP_ACCTG_PAY_ROUND_PKG.Total_Pay<- AP_Acctg_Pay_Round_Pkg.Do_Rounding<-
AP_Acctg_Pay_Dist_Pkg.Pay_Dist_Cascade_Adj_Events<-
AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT

 


ORA-01403: no data found occurred in
AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events<- AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT

 

ORA-01403: no data found occurred in
AP_Acctg_Pay_Dist_Pkg.Pay_Dist_Cascade_Adj_Events<- AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT

 

ORA-01403: no data found occurred in
AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events<- AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT with parameters (&PARAMETERS)



ORA-01403: no data found
ORA-06510: PL/SQL: unhandled user-defined exception.

 

APP-SQLAP-10000: SQLERRM occurred in Maintain_DBI_Summary
AP_SLA_PROCESSING_PKG.POSTPROCESSING_PROC with parameters (Table_Name =
AP_INVOICE_DISTRIBUTIONS, Operation = U, Key_Value1 = ) while performing the
following operation: looping through elements

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.