ETL9.2: TIME ADMIN LEAVES AWE ORPHANS AFTER COMPLETION (Doc ID 2395583.1
Last updated on JULY 03, 2018
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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?
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