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

Last updated on AUGUST 30, 2016

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 occurred in
AP_ACCTG_PAY_ROUND_PKG.Total_Pay<- AP_Acctg_Pay_Round_Pkg.Do_Rounding
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
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

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