HCM Extract in Changes Only run is displaying blank rows

Content

Hello All,

 

We are using historical UE's in our extract design to get all the employee history records (history, latest and future) information.

 

Used UE;s: PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE - Root DG

                   PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE - Child DG

 

Key Attribute: Assignment_id, Effective_start_date, Effective_end_date and Effective_sequence

 

Please consider the below test cases.

1. Full Mode - Extract is giving all the records data for each assignment transaction.

For Ex: Person (1001) is having 5 assignment records.

   

ACTION_CODE	EFFECTIVE_START_DATE	EFFECTIVE_END_DATE
HIRE	1/1/15	12/31/15
ASG_CHANGE	1/1/16	6/30/16
POSITION_CHANGE	7/1/16	12/31/16
ASG_CHANGE