Activate Subledger Journal Entry Rule Set Assignments Ends In Error XLA-870803 (Doc ID 1525094.1)

Last updated on NOVEMBER 01, 2024

Applies to:

Symptoms

On : 11.1.4.0.0 version, Manage Accounting Rules

Activate Subledger Journal Entry Rule Set Assignments ends in error

FAH-->Manage Accounting Rules-->Activate Subledger Journal Entry Rule Set Assignments
On Submitting the program for Custom Accounting Method and Custom Application, we get error message.
 

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

The following is the extract from the log file of the Activate Subledger Journal Entry Rule Set Assignments:

The activation process has encountered an internal error.  Details: Enable the FND: Log Enabled profile option, reactivate the journal entry rule set assignments, and review the log for more information.
22-01-2013 22:18:38 - ORA-01086: savepoint 'SP_VALIDATE_AAD' never established in this session or is invalid
ORA-06512: at "FUSION.XLA_COMPILER_PVT", line 2046
ORA-20001: XLA-870803: The activation process has encountered an internal error.  Details: Enable the FND: Log Enabled profile option, reactivate the journal entry rule set assignments, and review the log for more information.
22-01-2013 22:18:38 - Failure                    =
An internal error occurred.
Cause: An internal error has occurred in the program xla_compiler_pvt.activate_slam, ORA-01086: savepoint 'SP_VALIDATE_AAD' never established in this session or is invalid
ORA-06512: at "FUSION.XLA_COMPILER_PVT", line 2046
ORA-20001: XLA-870803: The activation process has encountered an internal error.  Details: Enable the FND: Log Enabled profile option, reactivate the journal entry rule set assignments, and review the log for more information..
Action: Inform your system administrator or support representative.
An application error has occurred. Your help desk can use the following information to obtain a more detailed description of this incident: Incident ID: 68_fusiondb, Instance: fusiondb, Product: fusiondb.
22-01-2013 22:18:38 - Failure                    =
An internal error occurred.
Cause: An internal error has occurred in the program xla_xlaabacr_xmlp_pkg.beforereport, ORA-20001: XLA-870557: An internal error occurred.
Cause: An internal error has occurred in the program xla_compiler_pvt.activate_slam, ORA-01086: savepoint 'SP_VALIDATE_AAD' never established in this session or is invalid
ORA-06512: at "FUSION.XLA_COMPILER_PVT", line 2046
ORA-20001: XLA-870803: The activation process has encountered an internal error.  Details: Enable the FND: Log Enabled profile option, reactivate the journal entry rule set assignments, and review the log for more information..
Action: .
Action: Inform your system administrator or support representative.
An application error has occurred. Your help desk can use the following information to obtain a more detailed description of this incident: Incident ID: 69_fusiondb, Instance: fusiondb, Product: fusiondb.

The following is the extract from the Debug log generated for this process: (By using the AFLOG profiles)

Listed below is only those lines in the debug log which have the [TRACE:1] meaning they were generated by errors.

[APPS_USER_NAME: weblogic_fa] [APPS_TERRITORY: US] [APPS_ENCODED: N] [APPS_DB_INSTANCE: 1] [APPS_SESSION_ID: D3CC1769AFAC1070E0432C09E70A8049] [APPS_SOURCE: xla.plsql.xla_journal_entry_rule_set_pvt.chk_jlt_rounding_class_exists] [APPS_JOB_REQUEST_ID: 1689] [APPS_JOB_DEFINITION_NAME: XLAABACR] [APPS_JOB_PACKAGE_NAME: /oracle/apps/ess/financials/subledgerAccounting/shared]


[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] Begin
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_application_id = 300000005227682
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_amb_context_code = DEFAULT
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_product_rule_type_code = S
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_product_rule_code = AAD1
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_entity_code = BENEFIT_IMPORTS
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_event_class_code = BENEFIT_IMPORTS
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_message_name = XLA_AB_PK_EVENT_ID_NOT_DEFINED
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] End
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] Begin
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_application_id = 300000005227682
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_amb_context_code = DEFAULT
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_product_rule_type_code = S
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_product_rule_code = AAD1
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_entity_code = BENEFIT_IMPORTS
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_event_class_code = BENEFIT_IMPORTS
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_message_name = XLA_AB_PK_EVENT_ID_NOT_DEFINED
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] End
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] Begin
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_application_id = 300000005227682
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_amb_context_code = DEFAULT
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_product_rule_type_code = S
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_product_rule_code = AAD1
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_entity_code = BENEFIT_IMPORTS
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_event_class_code = BENEFIT_IMPORTS
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] p_message_name = XLA_AB_PK_LINE_NUM_NOT_DEFINED
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] End
[TRACE:1] [xla.plsql.xla_extract_integrity_pkg]  [APPS_JOB_DEFINITION_APPLICATION: XLA] End
[TRACE:1] [xla.plsql.xla_extract_integrity_pkg]  [APPS_JOB_DEFINITION_APPLICATION: XLA] End
[TRACE:1] [fnd.plsql.FND_FILE.PUT_LINE]  [APPS_JOB_DEFINITION_APPLICATION: XLA] 23-01-2013 04:56:43 - Extract validation Unsuccessful for : BENEFIT_IMPORTS
[TRACE:1] [fnd.plsql.FND_FILE.PUT_LINE]  [APPS_JOB_DEFINITION_APPLICATION: XLA] 23-01-2013 04:56:43 - Extract source validation Unsuccessful
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] Begin
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] Count of Error Messages in the stack =  3
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] Begin
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] End
[TRACE:1] [xla.plsql.xla_amb_setup_err_pkg] [APPS_JOB_DEFINITION_APPLICATION: XLA] End
[TRACE:1] [fnd.plsql.FND_FILE.PUT_LINE] [APPS_JOB_DEFINITION_APPLICATION: XLA] 23-01-2013 04:56:43 - Failure                    =
[TRACE:1] [fnd.plsql.FND_FILE.PUT_LINE] [APPS_JOB_DEFINITION_APPLICATION: XLA] 23-01-2013 04:56:43 - ORA-01086: savepoint 'SP_VALIDATE_AAD' never established in this session or is invalid
[TRACE:1] [fnd.plsql.FND_FILE.PUT_LINE] [APPS_JOB_DEFINITION_APPLICATION: XLA] 23-01-2013 04:56:43 - Failure                    =
[TRACE:1] [fnd.plsql.FND_FILE.PUT_LINE] [APPS_JOB_DEFINITION_APPLICATION: XLA] 23-01-2013 04:56:43 - Failure                    =

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. FAH-->Manage Accounting Rules-->Activate Subledger Journal Entry Rule Set Assignments

Cause

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