Ledger Allocation with Parallel Enabled Fails with 'ORA-12838: cannot read/ modify an object after modifying it in parallel'
(Doc ID 2437990.1)
Last updated on MARCH 13, 2020
Applies to:Oracle Financial Services Profitability Management - Version 8.0.5 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Profitability Management (PFT) 8.0.5 or 8.0.6, when attempting to run a Management Ledger to Management Ledger Dynamic Driver Allocation with parallel processing enabled, the Allocation fails with the following ORA-12838 error in the ofspa.xxxxxxx.log in $FIC_DB_HOME/log/FusionApps:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  - SQL function not found! Oracle
Error: ORA- 12838: cannot read/ modify an object after modifying
it in parallel Driver Function: drv_oci::Execute()
The following parallel settings exist in the environment:
PARALLEL_QUERY = 'ENABLE'
PARALLEL_DML = 'ENABLE'
For the FSI_D_MANAGEMENT_LEDGER table, PARALLEL is set to 8.
If you turn off parallel processing in FSI_PARALLEL_PARAMETERS, the Allocation runs successfully.
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