My Oracle Support Banner

Create Accounting Is Failing With Error: xla_fsn_accounts_gt ORA-01722: invalid number (Doc ID 2469260.1)

Last updated on APRIL 04, 2019

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Fusion, 11.13.18.02.0 version, On receivables transactions. Trying to run create account is getting an error:


ERROR:
----------------
XLA_AP_FATAL_SQL_ERROR! Module: xlapcc_process_ccids, Statement: Update xla_fsn_accounts_gt (ccid to seg), Oracle error: ORA-01722: invalid number


EXPECTED BEHAVIOR
-----------------------
Expecting to be able to account this transaction to close period



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Navigator
2. Go to Tools > Scheduling Processes
3. Run Create Accounting process for Receivables
4. Reviewed the logs generated and ended with the error described



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


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