My Oracle Support Banner

Accounting Failed ORA-06502: PL/SQL: Numeric Or Value Error Occurred In AP_Acctg_Pay_Dist_Pkg (Doc ID 1999656.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Accounting Issues in AP

When attempting to run Create Accounting, accounting program ends in below error:

ERROR
-----------------------
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
ORA-06502: PL/SQL: numeric or value error occurred in
AP_Acctg_Pay_Dist_Pkg.Update_Gain_Loss_Ind with parameters (&PARAMETERS)
while performing the following operation:
&DEBUG_INFO.

FND Debug log shows:


 Procedure Pay_Dist_Reverse executed
 Calling procedure Update_Gain_Loss_Ind for payments
 Begin of procedure Update_Gain_Loss_Ind

 "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.Manual_Pay_Adj_Events<-AP_Accounting_Pay_Pkg.Do_Pay_Acco
 unting<- AP_SLA_PROCESSING_PKG.EXTRACT
 with parameters (&PARAMETERS)
 while performing the following operation:
 &DEBUG_INFO"

 

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.