Integrating Metadata

Data Management supports the loading of metadata from a flat file in the order provided in the file. This feature allows customers to build a metadata load file in any format, from any source, and load the metadata to an Oracle Enterprise Performance Management Cloud environment. Using this approach, users can set property defaults during the load or mapping process.

For example, Oracle Hyperion Workforce Planning customers can load employees, jobs, organizations and other work structure and compensation related items from Oracle Human Capital Management Cloud to the Planning.

Regular (such as Account and Entity), custom (such as Product), and Smart List dimensions are only supported, and for the following services only:

  • Planning Modules
  • Planning
  • Financial Consolidation and Close
  • Tax Reporting

Note:

Loading metadata is only available for applications that are application type: Planning. If the application type is Essbase, then use the Planning Outline Load Utility to load metadata.

Note:

Profitability and Cost Management does not support the loading of metadata by way of a file using Data Management.