IBMIS 8.5 - ETL JOB J_STAGE_PS_STDNT_ENRL_CS9_EPM91 DTTM DELETE ISSUE (Doc ID 2221947.1)

Last updated on JANUARY 10, 2017

Applies to:

PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


On: PeopleSoft Enterprise EPM 9.1 CSW,; DataStage ETL Jobs

ACTUAL BEHAVIOR
=============
ETL job DTTM delete strategy timing issue

Orphaned data in 'J_Stage_PS_STDNT_ENRL_CS9_EPM91' caused by DTTM delete strategy.
 
EXPECTED BEHAVIOR
===============
J_Stage_PS_STDNT_ENRL_CS9_EPM91 should process a student adding then dropping a class.

STEPS
=====
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.

Cause

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