Fusion Global HR : In Extracts PER_EXT_ORGANIZATION_TREE_UE and PER_ORGANIZATION_TREE_UE Do Not Return Any Data

(Doc ID 1944869.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Global Human Resources - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

When using the UEs PER_EXT_ORGANIZATION_TREE_UE and PER_ORGANIZATION_TREE_UE for extracting Organization Hierarchies, no data is returned.
1. Both the UEs are based on the table per_org_tree_node_rf
2. Neither UEs returns any rows.
3. However, the table per_org_tree_node shows the rows.

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