(PUM 22) HCM 9.2 Inefficient Sql In HRS_JPST_LIB
Last updated on FEBRUARY 14, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms