Multiple Jobs Put Data In The Same Hashfile Without Using Src_sys_id Cause Some Data Not Updated. (Doc ID 1992485.1)

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.

Symptoms

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

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