Procurement - EBS (MOSC)

MOSC Banner

Fill Employee Hierarchy concurrent program fails with error: +-------------------------------------

edited Feb 6, 2019 4:18PM in Procurement - EBS (MOSC) 11 commentsAnswered

We are getting this issue very frequent:

Fill Employee Hierarchy concurrent program fails with error: 

+---------------------------------------------------------------------------+

Error occured in  : po.plsql.POFEH.115ORA-30926: unable to get a stable set of rows in the source tables : -30926

+---------------------------------------------------------------------------+

As per solution provided:

1. Check if there are duplications for the employee records returned from the sqls below:

   a.
   SQL> select BUSINESS_GROUP_ID, POSITION_STRUCTURE_ID, SUPERIOR_ID, EMPLOYEE_ID,
          count(*) from po_employee_hierarchies_all
   group by BUSINESS_GROUP_ID, POSITION_STRUCTURE_ID, SUPERIOR_ID, EMPLOYEE_ID
   having count(1) > 1;

   b. 
   Replace the variables with above statement output,
   SQL> select * from po_employee_hierarchies_all

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center