ETL9.x: Fix for BUG 17861049 (Performance Issue TL_PUB_TM1.PUBLISH.STEP010 & STEP030) Does Not Work if Not Using Dilution
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.
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
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