Scripts To Delete Completed Rows From The WIP_JOB_SCHEDULE_INTERFACE, WIP_INTERFACE_ERRORS And WIP_JOB_DTLS_INTERFACE Tables
(Doc ID 2486674.1)
Last updated on MAY 28, 2021
Applies to:Oracle Work in Process - Version 220.127.116.11 to 12.2.8 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Sometimes completed records still exist/are stuck in the tables even after the successful creation/update of job WIP Mass Load program.
How to delete Completed rows from the WIP_JOB_SCHEDULE_INTERFACE and WIP_JOB_DTLS_INTERFACE Tables ?
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