Create Accounting Job Failing With Error: ORA-01426: Numeric Overflow (Doc ID 2059573.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Subledger Accounting Uptake for Receivables

When attempting to run Create Accounting Receiving - Accounting Program it ends with error


ERROR
--------

Error in Log File:
An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla_je_validation_pkg.balance_by_intercompany. ORA-01426: numeric overflow.

Debug Log Says

xla.plsql.xla_je_validation_pkg.balance_by_intercompany,l_bal_retcode = E
xla.plsql.xla_je_validation_pkg.balance_by_intercompany,l_bal_msg_count = 0
xla.plsql.xla_je_validation_pkg.balance_by_intercompany,l_bal_msg_data =
xla.plsql.xla_je_validation_pkg.balance_by_intercompany,Error returning from fun_bal_pkg.journal_balancing: E
xla.plsql.xla_je_validation_pkg.create_intercompany_errors,BEGIN of procedure create_intercompany_errors
xla.plsql.xla_je_validation_pkg.create_intercompany_errors,BEGIN LOOP - fun_bal_errors_gt
xla.plsql.xla_je_validation_pkg.create_intercompany_errors,LOOP - fun_bal_errors_gt: ae_header_id = 2876785082
xla.plsql.xla_je_validation_pkg.create_intercompany_errors,error_code = FUN_INTER_BSV_NOT_ASSIGNED
xla.plsql.xla_je_validation_pkg.create_intercompany_errors,ae_header_id = 2876785082
xla.plsql.xla_accounting_err_pkg.build_message,BEGIN of procedure BUILD_MESSAGE
xla.plsql.xla_accounting_err_pkg.build_message,p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.build_message,p_msg_name = XLA_INTER_BSV_NOT_ASSIGNED
xla.plsql.xla_accounting_err_pkg.build_message,p_token_1 = LEDGER_NAME
xla.plsql.xla_accounting_err_pkg.build_message,p_value_1 = IE_CORP_USD_ED
xla.plsql.xla_accounting_err_pkg.build_message,p_entity_id = 882549202
xla.plsql.xla_accounting_err_pkg.stack_error,p_ae_header_id = 2876785082
xla.plsql.xla_accounting_err_pkg.build_message,p_event_id = 2079087217
xla.plsql.xla_accounting_err_pkg.build_message,p_ledger_id = 28
xla.plsql.xla_accounting_err_pkg.build_message,p_ae_header_id = 2876785082
xla.plsql.xla_accounting_err_pkg.build_message,p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.build_message,p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error,BEGIN of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.stack_error,p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.stack_error,p_msg_name = XLA_INTER_BSV_NOT_ASSIGNED <-- [To Note This]


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receivables manager > Run Create accounting

2. Verify details

Note: Important observation for such cases is --> 'XLA_INTER_BSV_NOT_ASSIGNED' (From debug Log)

Changes

 This issue might occur for one particular Operating Unit.

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