My Oracle Support Banner

Fill Employee Heirarchy Fails with POFEH-130: ORA-01436: CONNECT BY loop in user data (Doc ID 342496.1)

Last updated on AUGUST 11, 2022

Applies to:

Oracle Human Resources - Version 11.5.7 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.

Symptoms

When attempting to run the Fill Employee Hierarchy Program the following error occurs.

Fill employee hierarchy request ora-01436

Action: Assigned a position to the employee.
APP-PO-14222: Position 21559 under superior 21543 not assigned
Cause: An employee is not assigned to one or more of the positions listed in the message.
Action: Assigned a position to the employee.
Concurrent program POFEH returned error
Cause: POFEH encountered an internal error. Parameters: POCFH,
Action: Note both this error number and the actions you are trying to
perform. Contact your system administrator for a
POFEH-130: ORA-01436: CONNECT BY loop in user data

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.