ETL9.2: Real Time Rules (RTR) Very Slow

(Doc ID 1930498.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version encountering extremely poor performance when testing the Real Time Time Administraion Rules (RTTA) feature.

TL Dev/Support will be working with PeopleTools and customer DBA for consideration of the following:
1. The call to the RTTA AE consume most of the service request time when it was called.
2. Most of the time was NOT taken running the RTTA AE program, rather it seems to be consumed preparing to run the program.
a.) The temp tables are deleted by process instance at the beginning and the end of the process. Each consume 5-10 seconds.
b.) Much of the time seems to be consumed loading PeopleTools Object, e.g. PSSQLTEXTDEFN, PSSQLDESCR, PSRECDEFN that appear to be items that should be cached.
c.) there are repeated queries to PSRECDEFNLANG for a single RECNAME.

With the current performance they cannot go live with Real Time Time Admin. and

The issue can be reproduced at will with the following steps:
1. Turn on real time rule feature
2. report time for employee that will invoke several rules
3. Hit Apply Rules on timesheet after time entry

Due to this issue, they have postponed implementing the real time rule feature until they can see reasonable performance improvements.

Cause

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