Create Accounting Fail with 'An internal error has occurred in the program xla_ae_code_combination_pkg.map_ccid. User-Defined Exception.' (Doc ID 1268526.1)

Last updated on AUGUST 10, 2017

Applies to:

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

Symptoms

Create Accounting is failing with error when there is primary and secondary SOB:

XLAACCUP module: Accounting Program

An internal error occurred. Please inform your system administrator or
support representative that:

An internal error has occurred in the program xla_ae_code_combination_pkg.map_ccid. User-Defined Exception.

ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 108-607295-94A59D8874A11946E040140AC6074504
09-NOV-2010 12:33:31 - extract hook executed successfully

insert statement for rollup rules is:

INSERT INTO GL_ACCTS_MAP_SEG3_GT (SELECT DISTINCT GL_FV.flex_value
source_flex_value, GL_CSM.single_value target_flex_value, 'N' summary_flag
FROM fnd_flex_values GL_FV, gl_cons_flex_hierarchies CFH,
gl_cons_segment_map GL_CSM WHERE GL_CSM.coa_mapping_id = 1013 AND
GL_CSM.to_application_column_name = 'SEGMENT3' AND GL_CSM.segment_map_id =
CFH.segment_map_id AND GL_CSM.single_value = CFH.parent_flex_value AND
GL_CSM.segment_map_type = 'R' AND GL_FV.flex_value_set_id =
GL_CSM.from_value_set_id AND GL_FV.summary_flag = 'N' AND GL_FV.flex_value
BETWEEN CFH.child_flex_value_low AND CFH.child_flex_value_high)

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