ORA-12801:error signaled in parallel query server PPA7,ORA-06512, ORA-01031: insufficient privileges — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-12801:error signaled in parallel query server PPA7,ORA-06512, ORA-01031: insufficient privileges

edited Jun 25, 2025 10:31PM in Supply Chain Planning and Collaboration 3 comments

Summary:

Collection Job Set Errored Out when loading CUSTOM_HIERARCHY_DETAIL.

  • ORA-12801: error signaled in parallel query server PPA7, instance epxa3a016-1tqk32:usplgrbq2 (2)
  • ORA-12801: error signaled in parallel query server PPA7, instance epxa3a016-1tqk32:usplgrbq2 (2)
    ORA-06512: at "FUSION.MSC_COLL_HIERARCHIES_UTIL", line 4568
    ORA-01031: insufficient privileges
    ORA-06512: at "FUSION.MSC_COLL_HIERARCHIES_UTIL", line 3193
    ORA-06512: at line 1

What causes these errors? Insufficient Memory?

Content (please ensure you mask any confidential information):

***RECENT UPDATES

Oracle SR 4-0000810208 Oracle tech provide us with the following feedback.

As per development confirmation "This is a known DB issue but is intermittent." Upon rerunning the ESS, will resolve the error.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!