Fusion Workforce Configuration Workbench: How to Get Work Term Assignment Effective Start and End Date for a Given HR_TERM_ID / EFFECTIVE_DATE Context (Doc ID 2125319.1)

Last updated on APRIL 22, 2016

Applies to:

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

Goal

User Entity PER_TRM_WORKTERM_DETAILS_UE does not retrieve Work Term Assignment Effective Dates

User Entity: PER_ASG_ASSIGNMENT_DETAILS_UE allows to retrieve information at the assignment level (Employment Level).
Assignment Effective Start Date and Effective End Date DBIs are available.

However, the closely related User Entity: PER_TRM_WORKTERM_DETAILS_UE, which allows to retrieve information at the work term level (Employment Terms Level) does NOT retrieve Work Term Assignment Effective Start Date and Effective End Date DBIs.

How to get Work Term Assignment Effective Start and End Date for a given HR_TERM_ID / EFFECTIVE_DATE context ?
 

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