Publish Data

Use the Publish Data action to export measure data from a planning table.

Use the exported file to integrate data from Oracle Fusion Cloud Supply Chain Planning application to other Oracle or external applications.

There are three ways to perform the Publish Data action:

  • Select a plan on the Manage Plans page, then select the Publish Data action from the Actions drop-down list for the plan you selected.
  • Open a plan to view it. Select the Publish Data action from the Actions drop-down list for the open plan.
  • Run the Publish Plan scheduled process from the Scheduled Processes work area. For more information, see Publish Plan.

Key Features

  • Exports measure data from a plan based on a selected table.
  • The source system you select determines the value of the product code that's included in the export file.
  • Generates a comma-separated values (CSV) file that you can access from the File Import and Export tool.

Best Practices

  • Use Publish Data action or the Publish Plan scheduled process when you want to export data in a CSV file format using a table configuration as a reference. Convert all filter levels, row levels, column levels, and measures into columns. Be sure to include the product code from the source system in the output file.
  • Create a profile option named MSC_PUBLISH_USES_TABLE_LAYOUT. To ensure that the layout of the output file matches the layout of the selected table, set the value to Yes. These are the layout details, in the order that they'll display in the file:
    • Levels in the filter bar: Display in the same order that they do in the filter bar.
    • Levels in the row edge: Display in the same order that they do in the table.
    • Levels on the column edge: Display in the same order that they do in the table.
    • Measures: Display in the same order that they appear in the table. It doesn't matter if the measures are in the column or row edge in the table.

Constraints

None.