Working With Views

Oracle Enterprise Performance Management Cloud products provide you with great flexibility in the ways in which you can view information in columns and rows. The views in Account Reconciliation are:

  • List View - provides a default display of information in columns and rows for objects such as Reconciliations, Transactions, or Profiles.
  • Group View - allows you to create summaries of numeric attribute data by attribute value.
  • Compact - is a toggle that can be turned on or off and displays more rows of information when you are in List or Group View.

Use the View selector to move between views.
example of the View selector showing List view selected
Here's an example of the view selector when you are in Group View.
example of the Group View selector

The List and Group Views provide default columns and rows of information displayed. However, you can easily customize your display to your needs by selecting the columns to display.

To Customize the List View

The List View displays with default columns selected but you can easily change the default columns.
screenshot of Reconciliation List view

For example, if you wanted to see more information such as who the preparers are for reconciliations as well as the ones that are late with a preparer, or if you wanted to see the Source System reporting balances, do the following:

  1. In the Actions drop-down, select Select Columns . The Attribute Selection dialog allows you to add various columns with information about (attributes of) your reconciliations.
  2. Scroll down the list and select Preparer and Late (Preparer) and use the arrow keys to move to the right hand side, then click OK.
    screenshot of adding reconciliations that are Late with Preparer
  3. Now select the Balances tab and select the field called Source System Balance (Reporting).


    screenshot of Source System Balance (Reporting) field selected on Attribute Selection dialog

To Customize the Group View

The Group View allows you to create summaries of numeric attribute data by attribute value. The possible attributes using Group view are: List, Yes/No, True/False, and User.
screenshot of Reconciliations List group view

To customize this group view, for example, to look for patterns in high rejection counts by Format and/or Preparer, do the following:

  1. Select Format in the Group1 drop down list and then select Preparer in the drop down list for Group2.
  2. In the Actions drop-down, select Select Columns. The Attribute Selection dialog allows you to add various columns.
  3. Select Rejection Count and use the arrow keys to move to the right hand side, then click OK
    example of adding Rejections (Count) as a column to Group View

This is an example of the Group View results:
screenshot of Group view with example of Rejection Counts by Format and/or Preparer

Note:

When defining numeric attributes, you can enter a value in the Total (Grouping Method) field:
  • None

  • Average

  • Count

  • Sum

To Choose Compact Display of Rows

Compact works as a toggle switch and displays more rows of information. Compact is available from the following:

  • Reconciliations List
  • Transactions List
  • Profiles List
  • Group View

If you save a list, your choice of Compact will also be saved.

Viewing Definitions for Reconciliation List Column Selections

See Appendix A: Reconciliation List Select Column Definitions to view the list column definitions for the following dataset types that are referenced across the lists in the application: Profile, Reconciliation, Balance, Transaction.