Exporting Dimensions

Review the following steps to export dimensions or run incremental exports to a file or an application connection.

Exporting Dimensions to a File

• Export a Dimension by Name. If running this from Oracle Integration Cloud, pass integrationHistoryId.
• Loop Get Job Status until job completes.
• Get Job Result
• Download a File from the Staging Area

Exporting Dimensions to an Application Connection

• Export a Dimension by Name. If running this from Oracle Integration Cloud, pass integrationHistoryId.
• Loop Get Job Status until job completes.
• Get Job Result

Running Incremental Exports to a File

Note: Incremental exports for flat dimensions in Oracle Financials Cloud General Ledger and Universal applications are based on transaction history. They include only nodes that have been added or edited. They don't include nodes whose values changed only through derived properties or inherited values, or nodes changed by imports or loads that use Replace or Reset modes. Use an Incremental Extract to compare two versions and identify all changes, including changes from bulk processes.

• Incremental export for a dimension. If running this from Oracle Integration Cloud, pass integrationHistoryId.
• Loop Get Job Status until job completes.
• Get Job Results
• Download a File from the Staging Area

Running Incremental Exports to an Application Connection

Note: Incremental exports for flat dimensions in Oracle Financials Cloud General Ledger and Universal applications are based on transaction history. They include only nodes that have been added or edited. They don't include nodes whose values changed only through derived properties or inherited values, or nodes changed by imports or loads that use Replace or Reset modes. Use an Incremental Extract to compare two versions and identify all changes, including changes from bulk processes.

• Incremental export for a dimension. If running this from Oracle Integration Cloud, pass integrationHistoryId.
• Loop Get Job Status until job completes.
• Get Job Results

The following use cases are also supported for backward compatibility.

Exporting Dimensions by ID to a File

• Get Applications
• For each dimension to export:
  • Export Dimension to File. If running this from Oracle Integration Cloud, pass integrationHistoryId.
  • Loop Get Job Status until job completes.
  • Download File

Exporting Dimensions by ID to an Application Connection

• Get Applications
• For each dimension to export:
  • Export Dimension to Connection. If running this from Oracle Integration Cloud, pass integrationHistoryId.
  • Loop Get Job Status until job completes.