Work Invoice is Not Purged After Marking For Purge and Running "Schedule Purge" Action
Last updated on AUGUST 13, 2015
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.
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 hundreds of Community platforms