Prerequisites
Review the feature availability and required setup for using the Data Extraction tool and its REST APIs.
Feature Availability
Enable the applicable opt-in features in Functional Setup Manager before you use the Data Extraction tool.
The Data Extraction tool is available under the following offerings:
- Fusion Accounting Hub
- Order Management
- Workforce Deployment
- Workforce Development
- Manufacturing and Supply Chain Materials Management
- Procurement
- Supply Chain Planning
- Financials
- Product Management
Enable the following feature to use the Data Extraction tool:
- Redwood: Extract Application Data from a Read-Optimized Data Store using a Redwood Page
Enable the following feature to use the Storage tab:
- Redwood: Schedule Data Extracts to Customer Storage Using a Redwood Page
Enable the following feature to create and use user-defined queries:
- Redwood: Use complex and user-defined data extracts using a Redwood page
Prerequisites for Using REST APIs
To use REST APIs for data extraction, you must configure OAuth authentication.
For setup instructions, see Configure OAuth. Refer to the Configure OAuth Using Client Credentials Grant Type (2-legged OAuth) section.
Ensure the OAuth client application has the required permissions and is configured
correctly:
- Add the following permissions to the OAuth client application:
- Oracle SaaS Batch Cloud Service
- Oracle Boss Cloud
- Configure the Client ID as a user in the Fusion application using the Security Console and assign the necessary custom job role. Ensure that the custom job role is created and assigned as described in Create and Assign a Custom Job Role.