Publish Plan Data

You can publish data for a plan in the Demand Management, Demand and Supply Planning, Planning Central, Replenishment Planning, Sales and Operations Planning, or Supply Planning work area to a compressed file.

You can then use the file for data integration between your Supply Chain Planning application and other Oracle or external applications.

By submitting a scheduled process from your Supply Chain Planning work area or the Scheduled Processes work area, you can publish the data in a pivot table within your plan to a file on the content server of Oracle WebCenter Content.

Using APIs of Oracle's ERP integration service for automating the data integration between your Supply Chain Planning Application and an external application, you can submit the scheduled process, check its status, and get the details of the published document.

The file name is in the <plan name>_<pivot table name>.zip format.

Publish Plan Data from a Supply Chain Planning Work Area

Here's how you can publish data for your plan from your Supply Chain Planning work area:

1. Do one of the following to open the Publish Data dialog box:

   • On the Manage Plans page, select the plan and click Actions > Publish Data.

     The Publish Data dialog box opens.

   • Open your plan and click Actions > Publish Data.

     The Publish Data dialog box opens.

2. Optionally, enter submission notes for your scheduled process.

3. On the Parameters tab, optionally, select the Append request number to output file name check box.

   Selecting this check box results in the request number being appended to the file name, which enables easy identification of the file on the content server. The resulting file name (<plan name>_<pivot table name>_<request number>) is also used as the document title.

   If you don't select this check box, the document title is PUBLISHPLANDATA.

4. In Table Name, select the pivot table of your plan for which you want to publish data.

   The available tables are enabled for the work area of the plan, and you have the required access to these tables.

5. In Source System, select the source system that's specified on the Scope tab of the Plan Options page for the plan.

6. On the Schedule tab, specify whether you want to run the process as soon as possible or according to a schedule.

   If you publish the file according to a schedule, you can specify the frequency and start and end dates for the process.

7. Click Submit.

   The Status dialog box opens and displays the request number. Make a note of this number and then click OK.

   You can use this number to search for the result of your request in the Scheduled Processes work area.

   If you appended this number to the compressed file's name, you can use this number to search for the file in the File Import and Export work area. You can then download and check the file.

Publish Plan Data from the Scheduled Processes Work Area

Here's how you can publish data for your plan from the Scheduled Processes work area:

1. On the Overview page, click the Schedule New Process button.

   The Schedule New Process dialog box opens.

2. In Name, select the Publish Plan job, and click OK.

   The Process Details dialog box opens.

3. To be notified when the process ends regardless of the result, select the Notify me when this process ends check box.

4. Optionally, enter submission notes for your scheduled process.

5. On the Parameters tab, in Plan Name, select your plan.

6. Optionally, select the Append request number to output file name check box.

   Selecting this check box results in the request number being appended to the file name, which enables easy identification of the file on the content server. The resulting file name (<plan name>_<pivot table name>_<request number>) is also used as the document title.

   If you don't select this check box, the document title is PUBLISHPLANDATA.

7. In Table Name, select the pivot table of your plan for which you want to publish data.

   The available tables are enabled for the work area of the plan, and you have the required access to these tables.

8. In Source System, select the source system that's specified on the Scope tab of the Plan Options page for the plan.

9. To set a schedule for your request and notify other users about the result, click the Advanced button.

   The Schedule and Notification tabs are displayed.

   • On the Schedule tab, specify whether you want to run the process as soon as possible or according to a schedule.

     If you publish the file according to a schedule, you can specify the frequency and start and end dates for the process.

   • On the Notification tab, specify the recipients to whom result notifications should be sent and the conditions under which the notifications are sent.

10. Click Submit.

    The Confirmation dialog box opens and displays the process number. Make a note of this number, and click OK.

    You can use this number to search for the result of your request in the Scheduled Processes work area.

    If you appended this number to the compressed file's name, you can use this number to search for the file in the File Import and Export work area. You can then download and check the file.