1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Using Data Management
  3. Using Data Management with Multiple Oracle Fusion Cloud EPM Deployments
  4. Customers Using Financial Consolidation and Close
  5. Data Loads

Data Loads

Data Management supports a variety of ways for importing data from a range of financial data sources, and then transforming and validating the data.

Data and exchange rates can be loaded to users who have data available from their source in a text file.

Any file, whether it is a fixed width file or a delimited file, can be easily imported into the Financial Consolidation and Close application. For example, you can take consolidation features, which include out-of-the box translations, consolidation, eliminations and adjustments from their source system, and map it into Data Management by way of the import format feature. You can instruct the system where the dimensions and data values reside in the file, as well as which rows to skip during the data import. This feature allows a business user to easily import data from any source by way of a file format, and requires limited technical help, if any, when loading into an Financial Consolidation and Close application.

Other Considerations

  1. Data may be loaded to Financial Consolidation and Close by way of Data Management when the movement member is set to one of the following:

    1. Level 0 descendants of FCCS_Mvmts_Subtotal

      or

    2. FCCS_OpeningBalanceAdjustment

      or

    3. Any level 0 members of customer specific hierarchies that are siblings of FCCS_Movements. The hierarchies are siblings of FCCS_Movements (not the level zero members).

  2. Data loaded to Financial Consolidation and Close can be only at the base level.

  3. Drill through from an Financial Consolidation and Close web form or Smart View on Financial Consolidation and Close is supported.

  4. Data loaded from Data Management to Financial Consolidation and Close is summarized based on the dimensionality in Data Management, and this summarized data is loaded to Financial Consolidation and Close. Any computations or consolidation logic can only be performed within Financial Consolidation and Close.

  5. Import formats support the addition of both "file" and Planning source types.

  6. Data Management indicates if the data loaded to Financial Consolidation and Close is "PTD" or "YTD." If data is specified as YTD, Financial Consolidation and Close performs any necessary computations as if that data needs to be translated to PTD.