Supplemental Data Process Overview

Supplemental Data Manager helps you organize, update, edit, and manage supplemental data, typically financial transactions. It is a robust ad hoc data collection process useful for footnotes, disclosures, and supporting details.

  1. The Administrator creates an application enabling the Supplemental Data feature, and refreshes the database, which sets up the system settings information.

  2. The Power User performs these procedures:

    • Creates additional Dimensions which may be required within their data collection.

    • Creates the collection interval to define the frequency of the data collection process, and the workflow dimensions on which their forms will be based.

    • Creates collections and subcollections to store the data as part of the data collection process.

    • Creates attributes, and calculation and validation rules for the attributes.

    • Creates Data Form Templates to ensure a consistent and repeatable data collection process.

    • Assigns workflow and access for each data form template.

    • Deploys the form template to a specific data collection period to be ready for the collection process.

      • If the period is not open, then the form instances are in Pending status.

      • If the period is open, then the form instance is active and available for data entry.

  3. The Administrator opens the Period after dimensions, collections, and forms are created in the system, and opens a Period to start the data collection process.

  4. The User then performs these tasks:

    • Loads data manually once the Period is open or uses a CSV file to import form data. Users can also act on any actions to be done, for example, entering comments and answering questions.

    • Performs validation and ensures correctness of data.

    • Submits data for approval.

  5. The User assigned as the approver reviews and approves or rejects the data (may have multiple levels of approval).

  6. The User views summarized data after the data is approved (depends on the workflow option), and posts data.

  7. The Administrator or Power User sends email alerts to assigned users for their related data forms.

  8. The Administrator closes and locks the Period for the data collection:

    • Closes the Period for Data Collection (prevents additional form instances to start)

    • Locks the Period for Data Collection (allows no additional changes)

You can also manage the data collection process and work with supplemental data forms using the Supplemental Data option in Oracle Smart View for Office. You must first install the Smart View Extension for Supplemental Data. To install the extension, see "Downloading and Installing Clients " in the Getting Started with Oracle Enterprise Performance Management Cloud for Administrators guide.