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 DECEMBER 03, 2020
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and laterOracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.9.2.0. The note has been reviewed and is current for release 11.13.20.04.0.
Goal
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)
PER_EXT_PAY_EMPLOYEE_UE
PER_EXT_ASG_ALL_ACTION_DETAILS_UE
PAYROLL_ASSIGNED_EMPLOYEE_UE entities.
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
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 |