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 MARCH 23, 2023
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
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 Name | NULL | Type |
|---|---|---|
| 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:
This note aims to assist in the resolution of those errors.
Solution
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
| Goal |
| Solution |
| References |