My Oracle Support Banner

HCM 9.2 Inefficient Sql In HRS_JPST_LIB (Doc ID 2248599.1)

Last updated on FEBRUARY 06, 2019

Applies to:

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


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.


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.