My Oracle Support Banner

ETL9.1: Clean Up Scripts to Delete Orphans in TL Payable Time AWE Tables (Doc ID 1297340.1)

Last updated on NOVEMBER 26, 2021

Applies to:

PeopleSoft Enterprise HCM 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


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

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