SCRTY_OPRCLS Process Fails When It Runs At The Same Time With TL_TIMEADMIN In HCM (Doc ID 2315870.1)

Last updated on DECEMBER 02, 2024

Applies to:

Goal

SCRTY_OPRCLS process fails when it runs at the same time with TL_TIMEADMIN in HCM. All users in the system lose access to the data. This happens approximately once a month. Processes were scheduled to run at the same time.

The process fails on the final step with the following error:

"File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_SJT_OPR_CLS) violated
Failed SQL stmt: INSERT INTO PS_SJT_OPR_CLS (OPRID , CLASSID , SEC_RSC_FLG) SELECT OPRID , CLASSID , SEC_RSC_FLG FROM PS_SJT_OPR_CLS_TMP

Process 368997 ABENDED at Step SCRTY_OPRCLS.UpdAll.Step06 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 09.00.31 2017-09-29"

When the process is rerun manually, it runs to success.

Is there any way the process could be set up to roll back its changes in case it runs into another issue like this in the future?
 

Solution

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