(PUM 22) HCM 9.2 Inefficient Sql In HRS_JPST_LIB (Doc ID 2248599.1)

Last updated on MARCH 27, 2017

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

HCM 9.2 inefficient sql in HRS_JPST_LIB Section 1 - in PPLT_JPS.Step02 : There are two problems with the SQL -

1. The select statement is very inefficient in DB2. 

2, DB2 does not resolve views within views well.

The SQL Statement Typically runs Several minutes each time the App Engine runs which can be Multiple Times a Day.  The Inserting from the Select Statement causes Lock Escalations because the Select takes too Long to Run.

The SQL needs design need to be Reviewed to be more Efficient in DB2.

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