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

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.

Symptoms

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.

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

STEPS
-----------------------
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.



Cause

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