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 DECEMBER 06, 2018

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

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
Symptoms
Cause
Solution

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