My Oracle Support Banner

W_HR_ASSIGN_ADDL_D doesn't populate correct CURRENT_FLAG or EFFECTIVE_TO_DATE (Doc ID 2411392.1)

Last updated on JUNE 26, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Goal

BI Apps Version - 11.1.1.10.2
BI Apps Module: Human Resource Analytics
Source system - Fusion R 13 (HCM)
ODI Mapping folder SILOS - SIL_HRAssignmentHistoryDimension

W_HR_ASSIGN_ADDL_D doesn't populate correct CURRENT_FLAG or EFFECTIVE_TO_DATE

EFFECTIVE_TO_DT column is not populated correctly in W_HR_ASSIGN_ADDL_D table.
and current_flag is set to 'Y" if the assignment is not Current.
 

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.