Archival of ESS_REQUEST_HISTORY needed before purge — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Archival of ESS_REQUEST_HISTORY needed before purge

Submitted
127
Views
1
Comments
neha rastogi
neha rastogi Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Description

Our client Titan International has a requirement to archive the records of ESS request history before purging them. Titan has more than 150 custom and seeded jobs and want to retain the request history (irrespective of status) to some alternate table. Critical programs such as program to send out EDI ASN is scheduled to run every 30 mins and the client want to retain the historical data of the runs. Currently we have a purge policy to purge ESS jobs  history which are more than 60 days old.

Could you please confirm if we can archive the records before purging them

 

Use Case and Business Need

Critical programs such as program to send out EDI ASN is scheduled to run every 30 mins and the client want to retain the historical data of the runs. They want to retain the history of all runs atleast for 2 year but the current purge policy deletes the records which are more than 60 days old. They want to archive the records  for future reference. 

Original Idea Number: ebc690a0c5

2
Up
2 votes

Submitted · Last Updated

Comments

  • Matthew Petco
    Matthew Petco Rank 1 - Community Starter

    Hello, can anyone update status of this request from last year? The ask is just to export existing data to an archive table instead of purging completely.