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 MARCH 08, 2017

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:

  1. Install Endeca
  2. Run Order Management/Endeca Extensions Full Load Data graph




Cause

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