My Oracle Support Banner

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:

Oracle Analytics Cloud - Version 105.5.0 and later
Information in this document applies to any platform.


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.


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.