Full Load Graph for ONT Module Fails with Error "java.sql.SQLException: ORA-12838: cannot read/modify an object after modifying it in parallel"
(Doc ID 2041501.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform.
Symptoms
EBS Extensions for Endeca 12.1 V5 is installed using MOS Note 1683053.1 -- Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5
As part of the post installation activity , Full load graphs for all modules is submitted.
Find the Full Load graph for ONT Module is failing and the log file shows the following error
ERROR
java.sql.SQLException: ORA-12838: cannot read/modify an object after modifying it in parallel ORA-06512: at "APPS.OE_ENDECA_UTILS"
STEPS
The issue can be reproduced at will with the following steps:
Install Endeca
Run Order Management/Endeca Extensions Full Load Data graph
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!
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.