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 AUGUST 05, 2024

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

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
Symptoms
Cause
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.