Data Replication Jobs Fail with Error: Inactive Data Store. Data store is not supported for extraction. (Doc ID 2682137.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Symptoms

Data Replication jobs were created in Oracle Analytics Cloud (OAC) to replicate Oracle Fusion Applications V20A data to an Oracle Autonomous Data Warehouse (ADW) database for subsequent visualization and analysis.

When creating two of the Data Replications in OAC, the desired Fusion Applications view object (VO) was not in the Available listing for selecting, so the "Add a custom view object" option was used to enter the path and name of the specific view object. For example:

-- CrmAnalyticsAM.TerritoryServiceAM.TerritoryPublic
-- CrmAnalyticsAM.ProductGroupAnalyticsAM.ProductPVO

When these Data Replications were run in OAC, the jobs failed and the following error was observed in the Jobs / History / Details page:

Error: CLOUD_REP_00020:Extractor error
# - TMP$_# - extractData - currJobId=# - extractStatus=FAILURE, extractErrorMsg=Inactive Data Store. Data store is not supported for extraction.

Cause

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