My Oracle Support Banner

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)

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


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