SCRTY_SJTDLY Slow Performance After Upgrade to Oracle 11g, Version 22.214.171.124
Last updated on FEBRUARY 15, 2018
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
***Checked for relevance on 23-Sep-2013***
***Ownership of the document transferred to ROXANA MARTINELLI on May 9-2016***
SCRTY_SJTDLY has slow performance when processing SJT_PERSON. Run times can exceed 10 hours. When the Nightly SJT Refresh Process is run, the call SCRTY_SJTUPD.25DelTyp.Step01 is being executed thousands of times. It sometimes chooses a full table scan against the PS_SJT_PERSON table to do its delete. This is taking up to 15 seconds per execution causing the job to run for up to 9 hours.
Navigation: Set Up HRMS, Security, Core Row Level Security, Nightly SJT Refresh Process
The Application Engine SCRTY_SJTDLY is running very slowly, sometimes not completing in a single day. The issue is SQL object SEC_PPLJOB_FUTWHERE. The statement is used with Security Access Type 001 Job Department Tree.
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