Before you Begin

This 30-minute hands-on tutorial shows you how to review and update supplemental data.

Background

Supplemental Data Manager helps you organize, update, edit, and manage supplemental data, typically financial transactions. It provides a robust ad hoc data collection process useful for footnotes, disclosures, and supporting details. It extends data collection to include transactional details for the consolidated balances within your business process.

What Do You Need?

An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.

  • Have Service Administrator access to EPM Enterprise Cloud Service. The instance should not have a business process created.
  • Have created users in Oracle Identity Management named user1, user2, and user3. You should create the users before loading snapshots. (Artifacts for Supplemental Data Management in the sample application include these user names, so these users need to be present.)
  • Upload and import this snapshot into your instance.

    Note:

    For more information on uploading and importing migration snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.
  • Upload and import this additional snapshot with sample data for Supplemental Data Manager.

Assigning security roles

    In this section, you assign access to user1, user2, and user3. The User, Power User, and Service Administrator roles can access Supplemental Data artifacts. For the purposes of this tutorial, you assign all the users to the Service Administrator group as a convenience, so that you do not need to assign access to individual data forms, entities, or accounts.

  1. On the Home page. click Tools, then Access Control.
    Acces Control Card
  2. On the Manage Groups tabs, for the Service Administrator security group, click the Actions icon and select Edit.
    Edit Option
  3. Click Search icon (Search) to display the users. Move user1, user2, and user3 from the Available Users list to the Assigned User list.
    Edit Group dialog box
  4. Click Save to return to the Manage Groups tab.
  5. Click Home icone (Home) to return to the Home page.
  6. Sign out of Financial Consolidation and Close.

Viewing tasks

  1. Sign in to Financial Consolidation and Close as user2 with the password you assigned in Oracle Identity Management.
  2. In the Task Panel on the Home page, set Year to 2020 and Period to Apr.
    Task Panel
  3. Note that there are Open tasks that need to be addressed. Click Open in the Task Panel. This launches the Worklist filtered to 2020, Apr, and Open. Because you are logged in as a Service Administrator, the list shows you tasks for all users by default. Task for Supplemental Data are indicated by a green icon SDM icon.
    worklist
  4. To filter the list to show only tasks for which you are responsible, click My Tasks icon (My Tasks).
    My Tasks page

Entering and posting form data

    In the section, you enter line-item detail data in the Debt form, and then post summarized data to accounts in Financial Consolidation and Close.

  1. Click on Debt Form for entity LE-0011-EUR in the Worklist to open the form.
    Debt Form

    2. On the top of the Form, you can see the Point Of View for the data. The line-items in the Detail section are summarized by Debt Type in the Summary section. The totals displayed in the Summary section are posted to accounts in Financial Consolidation and Close.

    Debt Form dialog box
  2. In the Summary section, hover the cursor over the cell for Treasury Bills > Debt Amount until the Point of View pop-up box displays. The target POV to which the data will be posted in Financial Consolidation and Close is displayed.
    Cell Point of View
  3. Click the Properties tab on the right to expand the Properties drawer and review the task properties. Click on the selected tab to collapse the task drawer.
    Properties drawer
  4. Click on the Instructions tab instructionsto view the form instructions.
  5. Click on the Workflow tab to view the workflow path. User2 is assigned as both the Preparer and the Integrator. The Preparer enters form data, and the Integrator posts the data to Financial Consolidation and Close.
    Workflow drawer
  6. Optional: Click on the remaining drawer tabs to review the additional task information.
  7. In the Detail section, edit the data by double-clicking the Debt Amount cell for row 3 in the table. Replace the existing value with 500000.
    Line-Item
  8. Note the current value for Long Term Bonds in the Summary section, then, in the upper right, click the Save icon. The line-item is saved and the total for Long Term Bonds in the Summary section is updated.
    Line-Item
  9. Click Submit to advance the workflow.
  10. Click the Workflow tab. The Preparer task is marked as complete and the Integrator task is active. Notice that the Submit button has change to a Post button.
    Workflow drawer
  11. Click Post.
    Post button
  12. At the Information prompt, click Close.
  13. Click the X in the upper right corner of the form to close the form.
  14. Click Data.
    Data card
  15. In the form list, click Debt Entry.
    Form list
  16. The form displays the data you posted from the Debt Form in Supplemental Data for April for Legal Entity 0011 (EUR).
    Debt Entry Form
  17. Right-click a cell in the Apr column to display the pop-up menu and select Supplemental Data.

    A view-only version of the Debt Form for April in Supplemental Data is displayed with the line-item detail.

    Debt Form dirll through

  18. Click X to close the Supplemental Data form, and then click X on the tab for the Debt Entry form to close the form.
  19. Click Home icon (Home) to return to the Home page.

Filtering the Supplemental Data Tasks list

The Supplemental Data Tasks list on the Tasks page provides powerful filtering capabilities. In this section, you apply filters to the Supplemental Data Tasks list.

  1. Click Tasks.
    Tasks card
  2. In the vertical tabs, click Supplemental Data Tasks.
    Supplemental Data Tasks list
  3. In the filters area, click Collection Interval, then click Default.
    Collection Interval filter
  4. Click Period, select Mar and Apr, then press Enter.
    Periods filter
  5. Click Add Filter, then select Entity. Scroll the list of entities and select LE-0011-EUR, then press Enter.
    Entity list
  6. The list is filtered by your selections.
    Supplemental Data Tasks list with filters

Viewing Supplemental Data dashboards

In this section, you review your data collection process using predefined task and data analysis dashboards.

  1. Click Home icone (Home) to return to the Home page.
  2. Click Dashboards, and then Task Overview.
    Task Overview card
  3. In the POV. select 2020, Mar.
    Task Overview dashboard
  4. In the Supplemental Data bar, click the Incomplete box.
  5. A list of incomplete tasks is displayed. The status of Regional Sales Channel is Open (with approver). Click Regional Sales Channel to open the form.
    Incomplete Tasks list
  6. In the Regional Sales Channel form, click the Workflow tab. Notice that user2 is the Approver. Click Approve, then click Close to close the form.
    Approve button
  7. Notice that Regional Sales Channel has been removed from the incomplete tasks list. Click Close to close the Tasks dialog box.
  8. On the Task Overview page, click Refresh. The number of tasks in the Incomplete box of the Supplemental Data bar is updated.
  9. In the vertical tabs, click Supplemental Data Overview. Set the POV to Default, 2020, Mar, Forecast, All. The number of open tasks for each entity is displayed.
    Supplemental Data Overview dashboard
  10. In the View By list, select Form. The number of complete and incomplete form instances for each form template is displayed.
  11. Click Compliance Overview, and then the Supplemental Data Compliance vertical tab. Set the POV to Default. 2020, Mar, Forecast, All. The Compliance dashboard provides statistics about on-time performance for preparation, review, and posting of supplemental data.
    Compliance dashboard
  12. Click Home icone (Home) to return to the Home page.

Viewing data collections

In this section, you use the Supplemental Data Analysis page to analyze the Debt Detail DS data collection. You create a list of debts greater than 1 million, sorted by debt amount from low to high..

  1. On the Home page, click Data.
    Data cstf
  2. Click the Supplemental Data Analysis vertical tab. For Collection, select Debt Details DS, and make these additional POV selections: 2020, Mar, Forecast.
    Supplemental Data Analysis page
  3. Click Add Filter, then click Debt Amount..
    Add Filter dialog box
  4. In the list of operators, select Greater Than, and in the Value box enter 1000000.
    Debt Amount filter
  5. The list is filtered to include records that have a debt amout of greater than 1,000,000. To sort by the debt amount, click the heading in the Debt Amount ccolumn. The list is sorted by the Debt Amount column. You can use the Actions menu to export the list to an Excel file or CSV file for additional analysis, or to save your filter for future use.
    Data Collection List filtered by entity

Learn More