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.

Symptoms

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

Cause

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