My Oracle Support Banner

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 SEPTEMBER 27, 2022

Applies to:

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


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


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.