Position Hierarchy Data Removed After Running Fill Employee Hierarchy Report Resulting in Incorrect Approval Routing

(Doc ID 1999510.1)

Last updated on APRIL 20, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


Find that PO_EMPLOYEE_HIERARCHIES_ALL data for one Operating Unit gets deleted when the Fill Employee Hierarchy report is run for another Operating Unit (OU).

The issue can be reproduced at will with the following steps:
1. Run Fill Employee Hierarchy report for one OU (example is GEAC_OU1)
2. Data in PO_EMPLOYEE_HIERARCHIES_ALL is correct for OU = GEAC_OU1
3. However data is deleted from that table for the other OU GEUP OU

You can use the followings sql statement replacing the &org_id with the affected org_id to check the data:

The Purchasing responsibility used is associated to the HR Security Profile that only gives authority to one OU.


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