Unable to Update FCT_MGMT_REPORTING 'ORA-12839: cannot modify an object in parallel after modifying it'
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)
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
#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.
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