My Oracle Support Banner

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

Last updated on JULY 12, 2019

Applies to:

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

Symptoms

When running Create Accounting for receivables, Accounting Program ends with following error:


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.


Steps to Reproduce:

Responsibility: Receivables Manager
Navigation
: Control > Requests > Run

  1. Run Create Accounting


FND Debug Log shows the following:

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 <-- [This is IMPORTANT to notice]

Changes

 

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
Changes
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.