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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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