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 JANUARY 23, 2024
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.5 to 8.0.7 [Release 8]Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
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: [4] - oexec(),
oexn() SQL Function: [189] - 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:
In FSI_PARALLEL_PARAMETERS:
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.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |