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 FEBRUARY 16, 2017

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


Goal

Oracle Purchasing uses Approval Hierarchies for the approval of Purchasing Documents.
There are two types of Approval Hierarchies:

- Job
- Positions

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:

Column NameNULLType
EMPLOYEE_ID NOT NULL NUMBER
SUPERIOR_ID NOT NULL NUMBER
POSITION_STRUCTURE_ID NOT NULL NUMBER
BUSINESS_GROUP_ID   NUMBER
ORG_ID   NUMBER


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:

POFEH-060: ORA-00001: unique constraint (PO.PO_EMPLOYEE_HIERARCHIES_U1) violated


This note aims to assist in the resolution of those errors.

Solution

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