My Oracle Support Banner

ETL9.2: TIME ADMIN LEAVES AWE ORPHANS AFTER COMPLETION (Doc ID 2416978.1)

Last updated on OCTOBER 12, 2023

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

On : 9.2 version, Time Administration,TIME ADMIN LEAVES AWE ORPHANS AFTER COMPLETION , similar to issue reported in ETL9.2:PUM25-TIME ADMIN LEAVES AWE ORPHANS AFTER COMPLETION (Doc ID 2395583.1 - what do we do while waiting for bug 27833559 to be resolved in image 27?

When below sql is run 12 rows are returned and currently those rows cannot be approved by anyone.

select * from ps_tl_payable_time where seq_nbr in (select seq_nbr from ps_tl_app_pay_xrfwhere eoawthread_status ='P'and eoawthread_id in (selecT eoawthread_id from PS_EOAW_STEP_VW --where eoawthread_id = :thread_idwhere eoawstep_status = 'A'))

 

How to  get rid of the orphans?
 

Solution

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
Goal
Solution
References


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