My Oracle Support Banner

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 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.