Redwood: Extract Application Data from a Read-Optimized Data Store Using a Redwood Page

Extract data more efficiently for reporting or integration by using a high-performance, read-optimized replica of the application database, ensuring faster and more reliable data retrieval.

This feature enables customers to now extract their application data from a Read-Optimized Data Store. Data extraction is no longer performed on the transactional instance but is instead done on a read-optimized Autonomous Data Warehouse instance, synchronized with transactional data in near real-time. By leveraging Oracle's new architecture, which abstracts business objects from the physical Fusion Application data model, the application reduces strain on the transactional instance.

Steps to Enable and Configure

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials Management

If you want to use the Extract Application Data from a Read-Optimized Data Store Using a Redwood Page feature, then you must opt in to its parent feature: Manufacturing and Supply Chain Materials Management. If you’ve already opted in to this parent feature, then you don’t have to opt in again.

Once the feature has been enabled, the application can be found under the Tools menu of the Oracle home page.

Access Requirements

Users can only access this feature after updating their job roles to incorporate new and existing privileges:

  • Manage Extracts Definitions (RCS_MANAGE_EXTRACT_DEF_PRIV)
  • Manage Extract Schedules (RCS_MANAGE_EXTRACT_SCHED_PRIV)
  • Manage Object Catalog (RCS_MANAGE_EXTRACT_CATALOG_PRIV)
  • Export Business Object Data by Date Range (SAASDATA_EXECUTE_TIMEDEXTRACTADHOC_BATCHJOB_PRIV)
  • Export Business Object Data by Frequency (SAASDATA_EXECUTE_TIMEDEXTRACTSERIES_BATCHJOB_PRIV)
  • Invoke ESS job (FND_MANAGE_SCHEDULED_PROCESSES_PRIV)
  • RCS Common ESS Job (RCS_MANAGE_EXTRACT_SCHED_PRIV)

Additional details are available in the integration guide of the application to explain the new privilege set up.