Accounting Program error: ORA-06502: PL/SQL: numeric or value error occurred in AP_Acctg_Pay_Dist_Pkg.Update_Gain_Loss_Ind

(Doc ID 1250735.1)

Last updated on DECEMBER 08, 2014

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
appaydib.pls 120.28.12010000.60


Symptoms


The Accounting Program is completing with error and logfile contains:


XLAACCUP module: Accounting Program


An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_ap_acct_hooks_pkg.main. Technical problem : Error encountered in product API for extract
An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_ap_acct_hooks_pkg.main. Technical problem : Error encountered in product API for extract
+---------------------------------------------------------------------------+


The fnd debug log shows:

APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error occurred in
AP_Acctg_Pay_Dist_Pkg.Update_Gain_Loss_Ind<- AP_ACCTG_PAY_DIST_PKG.Cancel_Primary_Pay_Events<-AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT
with parameters (&PARAMETERS)
while performing the following operation:
&DEBUG_INFO fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log

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