ETL9.x: Fix for BUG 17861049 (Performance Issue TL_PUB_TM1.PUBLISH.STEP010 & STEP030) Does Not Work if Not Using Dilution (Doc ID 1998264.1)

Last updated on FEBRUARY 08, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After applying the fix for Bug 17861049 (PERFORMANCE ISSUE TL_PUB_TM1.PUBLISH.STEP010 & STEP030 SLOW), the performance was still bad. This occurs when the Labor Dilution setting is not checked in the pay system settings.

This fix for Bug 17861049 only works if the “Labor Dilution Used” box is checked in the below setup. Otherwise, App Engine TL_PUB_TM1 takes a different path, executing the same SQL but in a different section - TL_PUB_TM1.DISTRIB.Step010.S.

Set Up HRMS > Product Related > Time and Labor > Time Reporting > Pay System

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