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

Last updated on MARCH 27, 2017

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

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