Unable to Update FCT_MGMT_REPORTING 'ORA-12839: cannot modify an object in parallel after modifying it'

(Doc ID 2349943.1)

Last updated on JANUARY 19, 2018

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.4 and later
Oracle Financial Services Profitability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Enterprise Financial Performance Analytics (EFPA) 8.0.4, when you run a batch with FN_MGMT_REP_MGMT_LEDGER_TRM (MGMT_REPORTING_MGMT_LEDGER_TRM) for more than one reporting month, you get the following ORA-12839 error in FSI_MESSAGE_LOG randomly:

Starting FCT_MGMT_REPORTING load
Re-Run Selected
#728640records deleted from FCT_MGMT_REPORTING
Creating Temporary table IOT_FCT_MGMT_REPORTING
#728640 records inserted into FCT_MGMT_REPORTING for income statement
#0 records inserted into FCT_MGMT_REPORTING for balance sheet
Unable to update FCT_MGMT_REPORTINGORA-12839: cannot modify an object in parallel after modifying it

The error causes the load into FCT_MGMT_REPORTING to fail.

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