Fill Employee Hierarchy Fails With po.plsql.POFEH.115ORA-30926: unable to get a stable set of rows in the source (Doc ID 2055631.1)

Last updated on FEBRUARY 17, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:POCFH - Fill Employee Hierarchy
***Checked for relevance on 17-Feb-2017***

Symptoms

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
+---------------------------------------------------------------------------+

Steps to reproduce:

  1. Existing Hierarchy Working correctly (POs are properly forwarded to Next Approver/Reviewer in Hierarchy)
  2. Add new Position to the Hierarchy
  3. Run Fill Employee Hierarchy
  4. Error POFEH.115ORA-30926 occurs
  5. New Position added in Hierarchy is not reflected and approval routing does not consider it

FND debug shows:
=============

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms