My Oracle Support Banner

Work Invoice is Not Purged After Marking For Purge and Running "Schedule Purge" Action (Doc ID 2036382.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.3.4 to 6.4.1 [Release 6.3 to 6.4]
Information in this document applies to any platform.


When performing a Mark Invoice for Purge, and then running a "Schedule Purge" as DBA.ADMIN, it is observed when checking the database for work_invoice the marked invoices are not purged.

Work invoices would be purged when work_invoice.marked_for_purge field =Y

The issue can be reproduced at will with the following steps:

1. Mark Invoice for Purge, run "schedule purge" as DBA.ADMIN , then check database for work_invoice.
2. If work_invoice.marked_for_purge field =Y the record should be gone from the database after the purge has run.
3. Observe the record is not deleted from the database.


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

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