Slow Performance with Refresh SJT_CLASS_ALL Process (SCRTY_CLSUPD)

(Doc ID 2279465.1)

Last updated on JUNE 26, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 and later
Information in this document applies to any platform.


On PeopleSoft HCM 9.1 : System Performance

When running AE program SCRTY_CLSUPD the process takes about 3 hours to complete, after upgrading to PeopleTools 8.53 and Oracle DB 12C.

The process should take about the same amount of time to complete as when on PeopleTools 8.50 and Oracle DB 11.01

The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu > Set Up HRMS > Security > Core Row Level Security > Refresh SJT_CLASS_ALL
2. Select to Refresh Row Level Security by a 'Specific Tree' and then Select DEPT_SECURITY tree
3. Run the SCRTY_CLSUPD process and note it takes almost 3 hours to complete.





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