ETL9.1: Clean Up Scripts to Delete Orphans in TL Payable Time AWE Tables
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