ETL9.X:Load Time & Labor To Payroll And Table PS_TL_XREF_TBL (Doc ID 2289000.1)

Last updated on AUGUST 09, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Goal

On : 9.2 version, TL Integrations,Load Time & Labor to Payroll and table PS_TL_XREF_TBL

We've been fighting some performance issues with loading time and labor to payroll and running pay calculation. We came across an old bug (Doc ID 616124.1) that references the table PS_TL_XREF_TBL. Our XREF table currently has over 33 million rows in it. Is it necessary to keep all of that history? Is there still any detrimental impact on load & calc (with load in preliminary calc selected)?
 

Solution

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