My Oracle Support Banner

DLYPRG - Purge Entities And Retention (Doc ID 2962387.1)

Last updated on JULY 19, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Goal

On : 19.3 version, Operations & Maintenance

DLYPRG - purge entities and retention


1. How can we selectively disable some of the tables from the dlyprg job?
2. How can we set the data retention that historical data can be keep in system (for example, for tables TRAN_DATA_HISTORY, PRICE_HIST, etc.) for a longer period. The issue here is that the job that actually deletes the items from the DB is the same that purges the required tables. At the same time, for example for PRICE_HIST table, the max parameter you can set for data retention is 999 days, which is not enough.


 

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.