IBMIS 8.5 - ETL JOB J_STAGE_PS_STDNT_ENRL_CS9_EPM91 DTTM DELETE ISSUE
Last updated on JUNE 26, 2018
Applies to:PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
On: PeopleSoft Enterprise EPM 9.1 CSW,; DataStage ETL Jobs
ETL job DTTM delete strategy timing issue
Orphaned data in 'J_Stage_PS_STDNT_ENRL_CS9_EPM91' caused by DTTM delete strategy.
J_Stage_PS_STDNT_ENRL_CS9_EPM91 should process a student adding then dropping a class.
The issue can be reproduced at will with the following steps:
1: Student adds, then drops the class as per CS Source.
2: The HASH file now reflects a row of data with DELFLAG = 'DEL'
3: Before 'J_Stage_PS_STDNT_ENRL_CS9_EPM91' is run, the Student adds this class back in as per CS Source.
4: 'J_Stage_PS_STDNT_ENRL_DEL_CS9_EPM91' is running and is adding this re-added class in the table, however, it will not touch the HASH file
5: This re-added class in the PS_STDNT_ENRL table reflects a row of data with DELFLAG = 'DEL'
6: When the job is running and before it calls 'J_Stage_PS_STDNT_ENRL_DEL_CS9_EPM91', this class is dropped again.
7: When J_Stage_PS_STDNT_ENRL_DEL_CS9_EPM91 runs, it will only delete rows with DELFLAG = '#P_CURR_DEL_FLG#' and not DELFLAG = 'DEL'.
8: End result ... mismatch data.
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