AskHareesh.com

How to Publish Supply Chain Plan Data and Retrieve Files from UCM

This article explains how to publish Supply Chain Planning table data using Oracle REST APIs and download the generated output file from Oracle Universal Content Management (UCM).

1. Retrieve Supply Plans

Send a GET request to fetch the available supply plans and identify your target Plan ID:

Method: GET
Endpoint URL: https://test.oraclecloud.com/fscmRestApi/resources/11.13.18.05/supplyPlans

2. Fetch Planning Tables for the Plan

Using the Plan ID from the previous step (e.g., 300000038721808), retrieve the list of planning tables to get the table name you want to export:

Method: GET
Endpoint URL: https://test.oraclecloud.com/fscmRestApi/resources/11.13.18.05/supplyChainPlans/300000038721808/child/PlanningTables?limit=1000

3. Publish the Planning Table Data

Submit a POST request to trigger the data publication job for the selected table:

Method: POST
Endpoint URL: https://test.oraclecloud.com/fscmRestApi/resources/11.13.18.05/supplyChainPlans/300000038721787/child/PublishData
Request Body: { "TableName":"HP Avg Test" }

4. Monitor the ESS Job

Note the ESS Job ID returned in the response payload. Navigate to Scheduled Processes in Fusion, view processes in Hierarchy Mode, and monitor the job until it reaches a Succeeded status.

5. Retrieve the UCM Document ID

Open the log file of the child ESS process and locate the generated UCM Document ID (e.g., 11547852).

6. Access the Document in UCM

Construct the UCM document URL using your Document ID and open it in your browser:

https://test.oraclecloud.com/cs/idcplg?IdcService=DOC_INFO&dID=11547852

7. Download the Data File

Click on the Native File link to download the .zip archive, extract it, and access the CSV file containing your published planning data.

How to Add JavaScript Code in Oracle AI Agent Studio

This article explains how to add javascript code in AI Agent workflow in Oracle AI Agent Studio.

1. Add a Code Node

Navigate to Agent Team and drag or add a Code node into your agent workflow.

2. Configure the Code Node

Enter the Name, Code Identifier, and Return Type.
Add your JavaScript Source Code.
In this example, the code node extracts an array from the previous Agent node's JSON response and counts the number of orders.
The Output Schema is generated automatically based on your selected return type.

3. Use the Result in Downstream Logic

You can reference the output of the Code node in subsequent workflow steps. For instance, to continue processing only when orders exist, add an IF Condition node.

4. Define the Condition Rules

Provide a name and set the specific rule criteria (e.g., allow the flow to proceed only when orderCount == 1).

Extract Fusion data using BQL in Oracle RODS

This article explains how to extract Oracle Fusion data using Business Query Language (BQL) queries through Oracle RODS REST APIs..

1. Prepare the BQL Query

You can construct a BQL query directly using Oracle Business Views and their attributes, or use an Oracle AI Agent to convert standard SQL into BQL.

(Refer to this article on how to Transform SQL Queries to BQL Using Oracle AI Agent Studio for step-by-step instructions.)

2. REST API structure

HTTP Method: POST
Endpoint URL: https://fa-test1.fa.ocs.oraclecloud.com/api/boss/extraction/extract
Request Body:

{

"parameters": {

"pHeaderId": "300005169788183"

"viewQueries": {

"SalesOrderBO": {

"module": "oraScmCoreOrderMgmtOrders",

"businessObject": "SalesOrder",

"view": "salesOrdersExtract",

"fieldAliases": {

"headerId": "headerIdValue",

"orderNumber": "orderNumberValue"

}

"namedSelects": [

{

"name": "dooHeadersAllNamedSelect",

"select": "SELECT salesOrderBO.headerIdValue, salesOrderBO.orderNumberValue FROM SalesOrderBO salesOrderBO WHERE salesOrderBO.headerIdValue = :pHeaderId"

}

"select": "SELECT dooHeadersAllNamedSelect.headerIdValue, dooHeadersAllNamedSelect.orderNumberValue FROM dooHeadersAllNamedSelect",

"return": [

{

"name": "headerIdValue",

"type": "int64"

{

"name": "orderNumberValue",

"type": "string"

}

]

}

3. Send the Request & Review Response

A successful request returns the extracted field data in JSON format:

Response:

[

{

"headerIdValue": 300005169788183,

"orderNumberValue": "24022004658"

}

]

Transform SQL Queries to BQL using Oracle AI Agent

This article explains how to use the built-in, template-driven workflow in Oracle Fusion AI Agent Studio to convert standard SQL queries into Business Query Language (BQL) for data extraction with Oracle RODS APIs.

1. Navigate to AI Agent Studio

In Oracle Fusion Cloud, go to Tools -> AI Agent Studio.

2. Search for the Pre-Built Agent Template

On the home page, search for the Data Extraction Query Transformer Workflow agent.

3. Create the Agent Team from Template

Click Use Template.
Enter an Agent Name and Agent Code (a simple approach is to add a custom prefix or suffix to the standard name).

4. Review the Created AI Agent

Once created, your AI Agent workflow is ready for testing.

5. Test the Query Transformation

Provide an Oracle SQL query prompt to the agent. For example

SELECT header_id, order_number FROM doo_headers_all WHERE header_id = 123456;

The Agent validates the input query and requests human approval before proceeding.

Once approved, the Agent converts the SQL query into the equivalent BQL query.

6. Test the BQL using Oracle RODS REST APIs.

Refer this article How to Extract Fusion data using BQL in Oracle RODS

How to Create a Project in OIC (Oracle Integration Cloud)

This article explains how to create a new project in OIC.

1. Navigate to Projects

From the main left-hand navigation menu in OIC, go to Projects and click the Add button.

2. Start Project Creation

Choose the option to create a new project from scratch.

3. Configure Project Details & Permissions

Enter a descriptive Name and unique Identifier for your project.
Add an optional Description to summarize the project's purpose.
Select the checkbox to manage team access, allowing other users to edit, view, or monitor the project as needed.

4. Access the Project Workspace

Click on your newly created project from the list to open its workspace and begin adding integrations, connections, and lookups.

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.

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.