My Oracle Support Banner

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

Last updated on MARCH 27, 2019

Applies to:

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


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?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.