My Oracle Support Banner

SCRTY_SJTDLY Slow Performance After Upgrade to Oracle 11g, Version (Doc ID 1288131.1)

Last updated on FEBRUARY 11, 2019

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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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