Managing Data Load Parameters for Oracle Service Cloud Source System

Configure the source used for purging or archiving records by setting applicable value for the Source Archive Purge Source data load parameter.

When you physically delete incidents from your Oracle Service Cloud instance, they are marked for Soft Delete in the Oracle BI Applications data warehouse. Soft-deleted rows in the data warehouse are available for reporting or analysis. If you periodically purge/archive incidents rather than physically delete them from your Oracle Service Cloud instance, they are still physically deleted from the Incidents table in your Oracle Service Cloud instance. Hence, the Oracle BI Applications ETL also marks these incidents for Soft Delete which means they too are not available for reporting or analysis.

If you want purged/archived incidents to be available for reporting and analysis, then use this parameter to enter the list of incident sources that you use in your Oracle Service Cloud instance to denote purged/archived incidents. When editing this parameter using the Manage Data Load Parameters dialog in Configuration Manager, the application displays all available incident sources in the left pane. Choose and move to the right pane the list of incident sources that indicate purged/archived incidents.  This prevents the Oracle BI Applications ETL from marking these incidents for Soft Delete and therefore they are available for reporting and analysis.