My Oracle Support Banner

How To Programmatically Delete WEC Batches? (Doc ID 2358536.1)

Last updated on APRIL 18, 2024

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Goal

There is a requirement to be able to programmatically delete WebCenter Enterprise Capture (WEC) batches on a nightly basis. Although it is possible to unlock batches via WLST, or through Enterprise Manager, there does not seem to be any ways to delete batches in bulk from a program.

It is possible to create a PL*SQL script that accesses the database and deletes the the batches directly?  If so, what tables/fields need to be processed to fully delete batch data?  

Is there a WLST deleteBatch(id) method would be a very useful enhancement request.
 

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!

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