How to download Flexfiled Archives in Oracle Fusion

 This article explains how to download Extensible Flexfield archives in Oracle Fusion.

1. Navigate to Setup and Maintenance

Click on your Profile Icon in the top-right corner, then select Setup and Maintenance --> Search.

2. Search for Flexfield Task

In the search bar, search for and select Manage Extensible Flexfields.

3. Locate the Target Flexfield

Search for the specific flexfield you need (e.g., DOO_HEADERS_ADD_INFO).

4. Download the Flexfield Archive

Select the flexfield row, click on the Actions menu, and select Download Flexfield Archive.

5. Save the Downloaded File

The flexfield archive will automatically download as a .zip file to your local computer.

Read More »

Data Extract for Item Extensible Flexfields - Oracle RODS

This article explains how to extract Item Extensible Flexfields (EFF) data from Oracle Fusion using Oracle RODS.

1. Navigate to Flexfield Management

Go to Setup and Maintenance -->  Search, and search for Manage Extensible Flexfields.

2. Deploy the Item Flexfield

Search for the Item Flexfield code EGO_ITEM_EFF.

Select it and click Deploy Flexfield to publish its attributes to RODS business views.

3. Open Data Extraction

In Oracle Fusion, navigate to Tools --> Data Extraction.

4. Create a New Data Extract

Click to create a new data extract definition.

5. Configure Extract Details & Select Attributes

• Enter a Name and Description for the extract.
• Specify an Initial Extract Date if required. 
• Under the Product Lifecycle Management category, select Item extended attribute views.
• Choose the specific attributes you want to include in the extract.

6. Schedule the Extract

Set up the schedule options for running the data extract job.

7. Verify & Download Extracted Data

Monitor the scheduled job to confirm successful completion, then download the generated data files.

Read More »

How to delete Extract Schedules in Oracle RODS using REST APIs

This article explains how to delete the extract schedules in Oracle RODS using REST APIs.

Deleting simple or immediate extract schedules manually—one by one—in the Oracle RODS UI can be tedious and time-consuming. Instead, you can automate this process by retrieving the extract schedule IDs and deleting them via REST APIs.

1. Retrieve the Extract Schedule ID

Fetch the list of extract schedules to find the specific schedule ID you want to delete.

(Refer to article on how to fetch extract schedules using REST APIs for full details.)

2. Locate the $id Field

From the JSON response payload of the extract schedule, locate and copy the $id attribute value (for example: 300005596387893).

3. Send the REST DELETE Request

Perform a DELETE HTTP request, passing the schedule's $id at the end of the API endpoint URL and use OAUTH2.0 with BOSS scope.

• HTTP Method: DELETE
• Endpoint URL: https://<your-instance>.oraclecloud.com/api/boss/data/objects/ora/scmCore/dataExtract/v1/extractSchedules/300005596387893

Verification

A successful request will return an HTTP 204 No Content status code, confirming that the extract schedule has been permanently removed.

Before delete:

After delete:

Read More »

Dynamically update REST Adapater Invoke connections in OIC

This article explains how to dynamically select and switch REST Adapter connections at runtime in Oracle Integration Cloud (OIC).

1. Create REST Connections

Create two separate REST connections in your OIC instance, each configured with a different Fusion instance URL.

Use this article to create connections.

2. Configure the Trigger Interface

Create a new integration and add an input query parameter to the trigger endpoint so the caller can specify which target environment to use.

3. Define a Connection Identifier Variable

Create an integration variable to store the target connection identifier dynamically.

4. Assign Connection Identifier via Switch Case

Use a Switch activity to evaluate the input query parameter and assign the appropriate connection identifier to your variable (e.g., HP_REST_TEST_1 or HP_REST_TEST_2).

5. Configure the REST Adapter Endpoint

Add the REST Adapter Invoke connection and configure it to fetch sales orders using the following relative resource path:

/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub

 6. Enable Dynamic Connection

In the REST endpoint configuration, check the Enable Dynamic Connection option and map your connection identifier variable to it.

7. Define Query Parameters

Configure endpoint query parameters such as limit and onlyData.

8. Map Parameters

In the mapper, map limit to 10 and onlyData to true.

Testing the Integration

Test the integration by passing different instance values as the input query parameter:

Test Case 1: Pass the parameter for TEST1. Observe that OIC dynamically routes the call using the HP_REST_TEST_1 REST connection.

Test Case 2: Pass the parameter for TEST2. Observe that OIC dynamically routes the call using the HP_REST_TEST_2 REST connection.

Read More »

How to create REST Adapter connection in OIC

This article explains how to create a REST connection in Oracle Integration Cloud (OIC) step-by-step.

1. Navigate to Connections:

Go to Design --> Connections from the left navigation menu.

2. Select the REST Adapter

Search for and select the REST adapter from the list.

3. Configure Connection Details

• Name & Identifier: Enter a clear name and a unique identifier for your connection.
• Role: Set the role to Trigger and Invoke.

4. Set Up Connection Properties & Credentials

• Select REST API Base URL as the connection type.
• Enter your Oracle Fusion SaaS URL.
• Provide your basic authentication credentials (username and password).

5. Test the Connection

Click the Test button to verify that the connection works properly.

Read More »

How to enable Offering in Oracle Fusion Apps

This article details the steps involved in enabling the offering: Data Extraction tool with in Oracle Fusion Apps.

1. Navigate to Setup and Maintenance

Open the Profile Menu (Settings and Actions) in the top right corner and select Setup and Maintenance.

2. Select the Setup category

From the Setup dropdown menu, choose the relevant offering category (for example, Manufacturing and

Supply Chain Materials Management).

3. Open “Opt In” options

Click the Change Feature Opt In link located near the top of the Functional Areas pane

4. Access Area Features 

On the Opt-In page, locate the appropriate Functional Area row and click the Edit Features icon (pencil icon) under the Features column.

5. Enable RODS – Read Only Data Store feature 

Find the feature named "Redwood: Extract Application Data from a Read-Optimized Data Store using a Redwood Page" and check the Enable box. Click Done.

6. Verify Tool Availability

Open the main navigation menu and expand Tools. The Data Extraction tool will now be visible and accessible.

Read More »

How to Fetch Data Extract Schedules in Oracle RODS Using REST APIs

While you can easily view extract schedules using the RODS Data Extraction UI, you may sometimes need to fetch them programmatically via REST APIs. This is useful for automating tasks, such as cleaning up completed or old schedules.

Data Extraction Schedules UI:

RODS REST API Endpoint:

GET https://fa-test.fa.ocs.oraclecloud.com/api/boss/data/objects/ora/scmCore/dataExtract/v1/extractSchedules?$filter=frequency%20=%20%27Immediate%27&$limit=25&$offset=0&$sortBy=scheduleId%3AAsc&$fields=extractType,name,scheduleId,status,frequency,extractDefinition.name,extractDefinition.overrideProperties

Query parameters:

$filter : Filters results based on criteria like schedule name or frequency (e.g., frequency = 'Immediate')

$limit : Sets the maximum number of records returned in a single response (e.g., 25)

$offset : Defines the starting index for pagination.

$sortBy : Sorts the output by a specific field (e.g., scheduleId:Asc).

$fields : Specifies which attributes to include in the response payload.

Response:

{

    "items": [

        {

            "extractType": "Incremental",

            "name": "TEST_HP_JOB_11052026_01",

            "scheduleId": "9976262",

            "status": null,

            "frequency": "Immediate",

            "$id": "300005596387893",

            "$context": {

                "links": {

                    "$self": {

                        "href": "https://fatest-test.fa.ocs.oraclecloud.com/api/boss/data/objects/ora/scmCore/dataExtract/v1/extractSchedules/300005596387893"

                    }

                }

            },

            "extractDefinition": {

                "name": "TEST_EXTRACT_SAMPLE_SO_HDRS",

                "overrideProperties": "{\"outputDataFormat\":\"CSV\",\"historyStartDate\":\"2026-04-01T00:00:00+00:00\",\"type\":\"BV\",\"csvDelimiter\":\",\"}",

                "$id": "300005596387887",

                "$context": {

                    "links": {

                        "$self": {

                            "href": "https://fatest-test.fa.ocs.oraclecloud.com/api/boss/data/objects/ora/commonBoss/dataExport/v1/exportGroupDefinitions/300005596387887"

                        }

                    }

                }

            }

        }

    ],

    "hasMore": true

}

The API response includes a boolean field called hasMore: 

• If hasMore is true, there are additional records to fetch. 
• You can write a loop that increments the $offset parameter by the $limit value (e.g., offset 0, then 25, then 50) to fetch all available schedule records sequentially.

Read More »