Fill Employee Hierarchy concurrent program fails with error: +-------------------------------------
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