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

(Doc ID 2416978.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.

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

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