Cleaning up AWE entries for Absence Management and Time and Labor

This post is a response to a query that was raised in ITToolbox today. The query concerned a need to delete entries created by the Absence Management AWE (Approval Workflow Engine) process definitions. We have seen this requirements being raised at a number of customer sites, where it is needed to cleanup 'orphaned' AWE entries. Orphaned AWE entries are those transactions that are present in the AWE specific workflow tables, but not having the actual transactional data in core absence management tables.
So, here is the list of tables that need to be cleaned up, if ever this requirement arises:

1. GP_ABS_SS_DAT
2. GP_ABS_SS_STA
3. GP_ABSSS_V_XREF
4. EOAW_USERINST
5. EOAW_STEPINST

If the above requirement arises for Time and Labor, the following list of impacted tables need to be cleaned up:

Reported Time Approval:

1. TL_APP_HDR
2. TL_APP_RPT_LINE
3. TL_APP_RPTD_XRF
4. EOAW_USERINST
5. EOAW_STEPINST

Payable Time Approval;

1. TL_APP_PAY_HDR
2. TL_APP_PAY_LINE
3. TL_APP_PAY_XRF
4. EOAW_USERINST
5. EOAW_STEPINST

Note that this post only lists the tables involved in the AWE processes of PeopleSoft Absence Management and Time and Labor. Ensure that correct SQL scripts are written and tested, prior to executing the actual cleanup. If necessary, consult support.oracle.com where there is good amount of documentation on this subject, as well as sample delete scripts.