Fusion Global HR: Grade Code Effective Start Date/Department Effective Start Date

(Doc ID 1982980.1)

Last updated on FEBRUARY 23, 2015

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

Need DBIs for:
The Grade Code Effective Start Date: The earliest effective date for the Assignment Grade Code.
The Department Effective Start Date: The earliest (Minimum) effective date of the Dept id in the Assignment. This is nothing but the DEPTID START Date

This interface is used to populate Oracle EBS - our accounting system - so it is really important we provide the accurate information. Below, you will find the usage which is done in the upload leg of the interface:

Those dates are used to record accurately the date from which an assignment is active when the interface file is uploaded on EBS side (as this could be in the future, we don't rely on using the day that the interface is processed).

Two dates that are considered for that
=> the SAL_ADMINP_START_DATE (= "Salary Admin Plan Effective Start Date" - the salary admin plan being a substring of the "Assignment Grade Code" in FUSION) and
=> the DEPTID_START_DATE (="Cost Center of the employee effective start date" - the cost center being stored in the "Assignment Department Name" in FUSION)

For the assignment update (in EBS), effective date will be greater of SAL_ADMINP_START_DATE and DEPTID_START_DATE data file column. If both of them are NULL then effective date will be sysdate.
Based on the above two dates in data file, future assignment will be created (in EBS).
 
Also, request to add the grade code to UE PER_PERSON_HISTORY_ASSIGNMENTS_U
 

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