Fusion OTBI-E - analysis against warehouse shows that Department Tree / hierarchy data is not in the warehouse

(Doc ID 2037914.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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


Fusion HCM Cloud Extract OTBI-Enterprise  to OBIA (Oracle Managed Cloud service/OnPrem) - no data loaded for department tree
From POD (Prod)   to OMCS environment

After the data loading to the warehouse, the user found via running analysis, that the department tree is empty .

The data was loaded from Cloud POD to OMCS warehouse environment.


Other information:
There have been 2 attempts at an Extract, 20th July was the initial full extract run by Cloud Ops -no Dept Tree data
                                                              22nd July was run by customer - same issue no Dept Tree data

W_INT_ORG_DH is empty.
Troubleshooting done: The EXTRACT result files for “department tree” on the UCM server are also noted to be empty.

    Screenshot shows the files corresponding to the 2 extracts to prove they were done and successfull:
      - Full extract generated by Cloud Ops team on July 20th
      - Extract generated by Client on July 22nd.

In VO terms, PERDEPTTREESTRUCTUREBICVO does not contain any records

No Error message: Extract tasks run to successfull

Cloud Extractor - extract

What works
Department data has been loaded, just not the tree/hierarchy tables
All worked in test environment which is a mirror setup.


 department hierarchies loaded into Fusion Applications from external source


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