Process SCRTY_OPRCLS Fails after Applying HCM 9.2 PUM Image 15 (Doc ID 2088212.1)

Last updated on DECEMBER 23, 2022

Applies to:

Symptoms

Process SCRTY_OPRCLS fails with below error after upgrading to HCM 9.2 PUM Image 15:

File: E:\pt85413c-retail\peopletools\src\psappeng\aebuf.cppSQL error. Stmt #: 583 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_HR_SEC_AET"."HRMH_MATRIX_ID")
Failed SQL stmt: INSERT INTO PS_HR_SEC_AET (PROCESS_INSTANCE,SCRTY_SET_CD,SCRTY_TYPE_CD,EMPLID,EMPL_RCD,RECNAME_S_TRANS,KEY1_PROMPT_REC,KEY1_PROMPT_FLD,KEY2_PROMPT_REC,KEY2_PROMPT_FLD,KEY3_PROMPT_REC,KEY3_PROMPT_FLD,IF_FLAG,ROWSECCLASS,CLASSID,SETID,DEPTID,UPDATE_ROW_LVL_SEC,UPDATE_SJT_SET,UPDATE_ROW_LVL_SET,UPDATE_ROW_SET,FILL_FAST_1,FILL_FAST_2,FILL_FAST_3,TREE_NAME,TREE_NODE,TREE_NODE_NUM,TREE_NODE_NUM_END,RECNAME_SJT,RECNAME_SJT_NM,RECNAME_SJT_TMP,RECNAME_SJT_TMP_NM,FUTURE_FLG,FUTURE_FLG_CHK,SEC_SQL_FLDNM,SEC_SQL_KEYVAL,SEC_SQL_FLDVAL,SEC_SQL_FROM,SEC_SQL_WHERE,SEC_SQL_FUT_WHERE,SCRTY_KEY1,SCRTY_KEY2,SCRTY_KEY3,ENABLED,HCR_HOME_HOST_TYPE,HCR_JPN_SEC_FLG,HCR_ASGN_TYPE,UPDATE_SEC_ALL,SCRTY_UPDATE_ALL,SQL_ID,SQL_ID1,SQL_ID2,POI_TYPE,PER_ORG,BUSINESS_UNIT,GB_GROUP_ID,COMPANY,TREE_NAME_OLD,TREE,OPRID2,OPRID3,ROLENAME,DESCR50,DELETED,ROWS_INSERTED,AE_APPLID,AE_SECTION) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67)


The issue can be reproduced at will with the following steps:
1. Navigation: Main Menu > Set Up HCM > Security > Core Row Level Security > Refresh SJT_OPR_CLS
2. Run process to Refresh the SJT_OPR_CLS Security Join Table
3. Go to Process Monitor, note process SCRTY_OPRCLS ran to No Success
4. Select Details, select View Log/Trace, and click link for *.stdout file to see Error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.