Process "Transfer Time From OTL To BEE" Is Taking More Longer Time To Complete
(Doc ID 2632516.1)
Last updated on JUNE 28, 2023
Applies to:
Oracle Time and Labor - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Performance
ACTUAL BEHAVIOR
---------------
Process "Transfer Time from OTL to BEE" is taking more longer time to complete
EXPECTED BEHAVIOR
-----------------------
"Transfer Time from OTL to BEE" program should not have performance issue..
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run "Transfer Time from OTL to BEE"
2. Taking more longer time to complete
Expensive Queries
-------------------
a) BEGIN PAY_HR_OTC_RETRIEVAL_INTERFACE.transfer_to_hr_payroll(:errbuf,:rc,:A0,
:A1,:A2,:A3,:A4,:A5,:A6,:A7,:A8,:A9,:A10,:A11,:A12,:A13,:A14,:A15,:A16,:A17,
:A18,:A19); END;
b) SELECT HS.STANDARD_START , HS.STANDARD_STOP
FROM
HXT_PER_AEI_DDF_V AEIV ,HXT_ROTATION_SCHEDULES RTS ,HXT_WORK_SHIFTS HWS ,
HXT_SHIFTS HS WHERE AEIV.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN
AEIV.EFFECTIVE_START_DATE AND AEIV.EFFECTIVE_END_DATE AND RTS.RTP_ID =
AEIV.HXT_ROTATION_PLAN AND RTS.START_DATE = (SELECT MAX(START_DATE) FROM
HXT_ROTATION_SCHEDULES WHERE RTP_ID = RTS.RTP_ID AND START_DATE <= :B1 )
AND HWS.TWS_ID = RTS.TWS_ID AND HWS.WEEK_DAY = HXT_UTIL.GET_WEEK_DAY(:B1 )
AND HWS.SHT_ID = HS.ID
Cause
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
Symptoms |
Cause |
Solution |
References |