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

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.