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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.