Multiple Jobs Put Data In The Same Hashfile Without Using Src_sys_id Cause Some Data Not Updated.
Last updated on JUNE 09, 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.
Issue / Errors
EPM 9.1: Multiple jobs put data in the same hashfile without using src_sys_id cause some data not updated.
J_Stage_PS_S_NAMES_CS_CS9_EPM91 EPM91 - Bundle9
J_Stage_PS_S_NAMES_HCM91_EPM91 EPM91 - Bundle9
these 2 jobs both put the data in the hashfile HASH_DTTM_PS_S_NAMES without using the src_sys_id.
The test case is HR put emplid 001 in the PS_S_NAMES table with src_sys_id = 'HCM', it success and update the hashfile without the src_sys_id.
when CS try to put emplid 001 in, it will look at the hashfile and it is already there, so it will not get put in the PS_S_NAMES
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms