R12:AP: AP Transaction is Failing With Error Message "Intercompany balancing was unable to generate the intercompany account." While the FND Log Shows "Value XXX for the flexfield segment Intercompany does not exist in the value set AAA_BBB_CCC" (Doc ID 2925754.1)

Last updated on JULY 29, 2024

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle Subledger Accounting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to create accounting for a specific AP payment, the following error occurs:

ERROR
-----------------------

Intercompany balancing was unable to generate the intercompany account. Please check the intercompany balancing rules setup.

The FND log while running online create accounting from Payment Workbench for that specific AP payment is showing these relevant error messages:

xla.plsql.xla_events_pkg.get_entity_id BEGIN of procedure get_entity_id
xla.plsql.xla_events_pkg.get_entity_id source_application_id =
xla.plsql.xla_events_pkg.get_entity_id application_id = 200
xla.plsql.xla_events_pkg.get_entity_id legal_entity_id = &legal_entity_id
xla.plsql.xla_events_pkg.get_entity_id ledger_id = &ledger_id
xla.plsql.xla_events_pkg.get_entity_id entity_type_code = AP_PAYMENTS
xla.plsql.xla_events_pkg.get_entity_id transaction_number = &transaction_number
xla.plsql.xla_events_pkg.get_entity_id source_id_int_1 = &source_id_int_1
fun.plsql.fun_bal_pkg.get_ccid Begin
fun.plsql.fun_bal_pkg.get_ccid l_ccid_key : 1377165~50299~XXX~M~1~5~01-02-2023
fun.plsql.fun_bal_pkg.get_ccid Begin
fun.plsql.fun_bal_pkg.get_ccid l_ccid_key : 1377186~50299~M~XXX~1~5~01-02-2023
fun.plsql.fun_bal_pkg.get_ccid l_flag = FALSE
fun.plsql.fun_bal_pkg.get_ccid l_cat_segs = M.0000.2804600.000000.J00.0.0
fun.plsql.fun_bal_pkg.get_ccid.validate_segs Value XXX for the flexfield segment Intercompany does not exist in the value set AAA_BBB_CCC.
fun.plsql.fun_bal_pkg.get_ccid.validate_segs l_ccid_key : 1377186~50299~M~XXX~1~5~01-02-2023
fun.plsql.fun_bal_pkg.get_ccid returning -ccid

xla.plsql.xla_je_validation_pkg.balance_by_intercompany l_bal_retcode = E
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 = 216372614
xla.plsql.xla_je_validation_pkg.create_intercompany_errors ae_header_id = &ae_header_id
xla.plsql.xla_je_validation_pkg.create_intercompany_errors error_code = FUN_INTRA_CC_NOT_CREATED
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_INTRA_CC_NOT_CREATED
xla.plsql.xla_accounting_err_pkg.build_message p_entity_id = &entity_id
xla.plsql.xla_accounting_err_pkg.build_message p_event_id = &event_id
xla.plsql.xla_accounting_err_pkg.build_message p_ledger_id = &ledger_id
xla.plsql.xla_accounting_err_pkg.build_message p_ae_header_id = &ae_header_id
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_INTRA_CC_NOT_CREATED
xla.plsql.xla_accounting_err_pkg.stack_error p_entity_id = &entity_id
xla.plsql.xla_accounting_err_pkg.stack_error p_event_id = &event_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ledger_id = &ledger_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.stack_error p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.stack_error p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error l_msg_number = 0
xla.plsql.xla_accounting_err_pkg.stack_error END of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.build_message END of procedure BUILD_MESSAGE
xla.plsql.xla_je_validation_pkg.create_intercompany_errors END LOOP - fun_bal_errors_gt
xla.plsql.xla_je_validation_pkg.create_intercompany_errors End of procedure create_intercompany_errors

Steps to reproduce the issue:

1. Run the concurrent program Create Accounting

2. Check the output of the concurrent program Create Accounting - Subledger Accounting Program Report

3. Get the FND log while running online create accounting from Payment Workbench for that specific AP payment

Changes

Intercompany value 'XXX' is missing in the intercompany value set 'AAA_BBB_CCC'.

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

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

R12:AP: AP Transaction is Failing With Error Message "Intercompany balancing was unable to generate the intercompany account." While the FND Log Shows "Value XXX for the flexfield segment Intercompany does not exist in the value set AAA_BBB_CCC" (Doc ID 2925754.1)

Applies to:

Symptoms

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!