Fill employee hierarchy is running from 100 hours even if there is no change in the position hierarchy
We truncated the po_employee_hierarchies_all table and ran fill employee hierarchy program and it completes in 10 minutes.
Second time when we ran the program it continuously running from 100 hrs.
What version is this
Try this note on MOS: OCFH: The Fill Employee Hierarchy Report has Slow Performance Taking Several Hours to Complete (Doc ID 1945749.1)
Find out what version you have of this package: $PO_TOP/patch/115/sql/poxpofeh.sql
If you are 12.1.3 it needs to be at this version or higher: 120.1.12010000.6