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 FEBRUARY 15, 2019

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


On : 12.1.3 version, Subledger Accounting Uptake for Receivables

Accounting Program fails with the following 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 




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.