My Oracle Support Banner

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 11.5.10.2 to 12.2.8 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

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 ?

Solution

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
Goal
Solution
References


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