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 03, 2019
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