R12: XLAACCUP: PA-Accounting Program: An internal error has occurred in the program XLA_00275_AAD_C_011140_PKG.AcctLineType_27. ORA-01722: invalid number. (Doc ID 2293698.1)

Last updated on AUGUST 17, 2017

Applies to:

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

Symptoms

Submit PRC: Create Accounting process with Process Category 'Revenue'. This process kicks off the Accounting Program.
Accounting Program log shows error below:

ERROR
-----------------------
"An internal error has occurred in the program XLA_00275_AAD_C_011140_PKG.AcctLineType_27. ORA-01722: invalid number. "

-The issue only occurs when running the PRC: Create Accounting process with Process Category 'Revenue'.
-There is only one operating unit impacted.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit PRC: Create Accounting with Process Category = Revenue.
2. This kicks off Accounting Program which errors out with the error indicated above.


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