ETL9.1: Clean Up Scripts to Delete Orphans in TL Payable Time AWE Tables

(Doc ID 1297340.1)

Last updated on JULY 24, 2017

Applies to:

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


A request has been made to provide a clean-up scripts for the orphan AWE Reported Time rows left behind by Time Admin processing.

When re-processing time for a period of time, Time Admin will  delete existing "NA - needs approval" payable time rows insert a new set.  However Time Admin does not delete the AWE rows associated with the deleted "NA" rows.  AWE Payable Time


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