ETL9.x: Enhancement To Provide Archive Utility For TL-AWE AND EOAW TABLES (Doc ID 1354943.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Symptoms


An enhancement is being requested to deliver archive utility to archive the EOAW and TL-AWE tables. 
These tables have reached millions of rows in small duration of time and this is causing numerous performance issues, DB space issues etc. We need a mechanism to archive the data in the AWE tables for both AWE Reported Time and AWE Payable Time Approval.

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