Payroll for NA / Time and Labor - PSFT (MOSC)

MOSC Banner

PAY_OTH_EARNS and TL_XREF_TBL performance issue

edited Mar 30, 2022 1:39PM in Payroll for NA / Time and Labor - PSFT (MOSC) 1 commentAnswered

Hi All,

I am using the below sql to get the location details from TL_PAYABLE_TIME. But the time DDP003 process taking is longer time than expected. Actual run time is 15 minutes. Currently taking 180 minutes after changes.


SELECT OE.ERNCD, OE.COMP_RATECD, OE.COMPRATE_USED, OE.OTH_HRS, OE.OTH_EARNS, OE.OTH_PAY, OE.HRS_DIST_SW,

OE.RATE_USED, SUM(L.TL_QUANTITY), L.location

FROM PS_PAY_OTH_EARNS OE , PS_TL_XREF_TBL B, PS_TL_PAYABLE_TIME L

 where OE.COMPANY  = 'XXX'

 AND OE.PAYGROUP  = 'XXX'

 and OE.PAY_END_DT = '21-NOV-20'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center