Automatic purge can be disabled fusion.mkt_imp_leads_t (Doc ID 2240604.1)

Last updated on MARCH 05, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

They have a requirement to export the data from the results of the lead generation process via Sales Predictor.
The results are stored from Marketing TEMP(FUSION.mkt_imp_leads_t) table. Note that this has as dynamic bind param (JOB ID ) for every generated job.
(attached actual query from a sample lead generation job).

The temporary tables are automatically purged after some time.
We need to check whether there is a way to disable the automatic delete/purge of those tables via customer Instance?
 

Solution

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