My Oracle Support Banner

Receivables Accounting Program Failed with Error ORA-06502: PL/SQL: Numeric or Value Error (Doc ID 1929286.1)

Last updated on AUGUST 22, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
XLAACCUP module: Accounting Program
XLAACCPB module: Create Accounting

Symptoms

On : 12.1.3 version, Subledger Accounting Uptake for Receivables

Accounting Program fails with the following error:

ERROR
-----------------------
An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program XLA_00222_AAD_C_011227_PKG.EventClass_166. ORA-06502: PL/SQL: numeric or value error: charac
 

Steps to Reproduce:
1. Run Create Accounting program, it will spawn Accounting Program
The accounting program will fail 

 Customer is using Custom Application Accounting Definition (AAD) and they have created their own Journal Description 

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.