Fusion HCM Extract: How to Extract the Assignment Details in an HCM Extract (Full File) Using Database Items (DBIs) to Get the Assignment Supervisor Information
(Doc ID 2013683.1)
Last updated on SEPTEMBER 02, 2020
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Global Human Resources - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
This note was created for Release 220.127.116.11.0. The note has been reviewed and is current for release 11.13.20.04.0.
What are the Database Items (DBIs) to get the Assignment Supervisor Information?
User wants to extract the Assignment Details in the HCM Extract (Full File). The following User Entities (UEs) retrieved the information:
PER_EXT_SEC_ASSIGNMENT_UE (Parent Block)
But unable to find DBIs for below listed fields.
Table Name - Column Name
PER_ASSIGNMENT_SUPERVISORS_F - EFFECTIVE_START_DATE
PER_ASSIGNMENT_SUPERVISORS_F - EFFECTIVE_END_DATE
PER_ASSIGNMENT_SUPERVISORS_F - WORKING_PERCENTAGE
CMP_SALARY - MULTIPLE_COMPONENTS
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