My Oracle Support Banner

REIM_PURGE Job Is Not Deleting Invoices In Status Delete (Doc ID 3066651.1)

Last updated on JANUARY 15, 2025

Applies to:

Oracle Retail Invoice Matching Cloud Service - Version 24.0 and later
Information in this document applies to any platform.

Goal

Create an invoice and after that delete it on the UI.
Check the im_system_options for the column DOC_HIST_DAYS in our client the configuration is setup as 548 days.
Run the REIM_PURGE JOB in POM and the invoice is not deleted from Invoice Matching.

Update the column creation_date on the im_doc_head for the invoice that was created for the date where creation_date = creation_date - DOC_HIST_DAYS IM_SYSTEM_OPTIONS.
Run again the REIM_PURGE JOB in POM and the invoice is deleted from Invoice Matching.

Looking to describe of the system option, this only should be accounted for the invoices that are in status matched and posted, not for deleted invoices.

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!

In this Document
Goal
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.