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.