Process SCRTY_SJTDLY Abends at 100_Find.Step10 after Applying HCM 9.2 PUM Image 15 (Doc ID 2091760.1)

Last updated on DECEMBER 22, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The Nightly SJT Refresh process fails with the following error after upgrading to HCM 9.2 PUM Image 15:

1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_RUN_CNTL_SCRTY4"."HRMH_MATRIX_ID")
Failed SQL stmt: INSERT INTO PS_RUN_CNTL_SCRTY4 (OPRID , RUN_CNTL_ID , UPDATE_SJT_SET , EMPLID , EMPL_RCD , POI_TYPE , PER_ORG , SCRTY_TYPE_CD , GB_GROUP_ID , BUSINESS_UNIT , SETID , DEPTID , COMPANY , SQL_ID , SQL_ID1 , SELECTED , SCRTY_SET_CD , COMPLETED) SELECT DISTINCT OPRID , RUN_CNTL_ID , UPDATE_SJT_SET , EMPLID , EMPL_RCD , POI_TYPE , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , SQL_ID , SQL_ID1 , 'Y' , SCRTY_SET_CD ,'N' FROM PS_RUN_CNTL_S6_TMP

Process 404337 ABENDED at Step SCRTY_SJTDLY.100_Find.Step10 (SQL) -- RC = 1400 (108,524)


The issue can be reproduced at will with the following steps:
1. Insert a new row on PS_JOB for emplid PN012 dated 1/1/2016.
2. Run the following SQL to set the LASTUPDDTTM back one day:
update ps_job
set lastupddttm = lastupddttm - 1
where emplid = 'PN012'
and effdt = to_date('01/01/2016','MM/DD/YYYY')
3. Go to Main Menu > Set Up HCM > Security > Core Row Level Security > Nightly SJT Refresh Process and run with the following parameters:
Transaction Sec Join Table: SJT_PERSON
Include yesterday's changes?: checked
As Of Date: blank
4. Go to Process Monitor and note process ran to No Success

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