Aid To Resolving Fill Employee Hierarchy "POFEH-060: ORA-00001: Unique Constraint (PO.PO_EMPLOYEE_HIERARCHIES_U1) Violated" Messages
(Doc ID 1330485.1)
Last updated on JANUARY 16, 2020
Applies to:Oracle Purchasing - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Executable:POCFH - Fill Employee Hierarchy
***Checked for relevance on 22-Apr-2013***
Oracle Purchasing uses Approval Hierarchies for the approval of Purchasing Documents.
There are two types of Approval Hierarchies:
When a Positional Hierarchy is used the Approval Workflow reads data from the View PO_EMPLOYEE_HIERARCHIES.
This View is based on the table PO_EMPLOYEE_HIERARCHIES_ALL
This table is populated by running the report 'Fill Employee Hierarchy Report' (FEH)
The table contains a link to employees that are assigned positions within a hierarchy.
The table has the Unique Index PO_EMPLOYEE_HIERARCHIES_U1 and is constructed on the following table columns:
As the combination of the values in these columns must be unique if an attempt is made to duplicate the combination then the following error occurs:
This note aims to assist in the resolution of those errors.
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