Use the Supporting References Report

In this procedure, you create and view the supporting references report in OTBI (Oracle Transactional Business Intelligence).

Create a Supporting References Report

Before you create a supporting reference report, you must ensure that supporting references are assigned to journal lines in the journal entry rule set and then the accounting created .

  1. From the Home page, click Navigator > Reports and Analytics.

  2. Open the Create drop down.

  3. Select Analysis.

  4. Select Subject Area: Subledger Accounting - Supporting Reference Real Time.

    1. In the Create Analysis region of the Select Columns page, expand the Subject Area.

    2. Expand the folders and select the desired columns.

      • Click the Add icon to move columns to the Selected Columns region.

      • To rename columns, select the column row and click the Edit icon.

      • Resequence columns by using the arrows.

      This table contains column names used in the supporting references report.

      Folder

      Column

      Journal Source

      Journal User Source Name

      Ledger

      Ledger Name

      Supporting Reference Balance Details

      Select the appropriate supporting references

      Rename as wanted.

      GL Account

      Concatenated Segments

      Ledger

      Ledger Currency

      Time

      Accounting Period Name

      Supporting Reference Balances

      Period Balance Dr

      Period Balance Cr

    3. Click Next button.

  5. On the Select Views page:

    1. Enter the report Title.

    2. Select Table option.

    3. Click Next .

    4. Click theNext button again to skip the Edit Table page.

  6. On the Sort and Filter page:

    1. Click Add Filter.

    2. Select Ledger Name.

    3. Select Operator 'is equal to'.

    4. Enter wanted ledger name.

    5. To add another filter. Click Add Filter.

    6. Select Journal User Source Name.

    7. Select Operator 'is equal to'.

    8. Enter wanted journal user source name.

    9. Click Submit.

  7. On the Create Analysis page:

    1. Enter Analysis Name.

    2. In the Save In region, select My Folders.

    3. Click Submit.

    4. Click OK.

View the Supporting References Report

View the supporting reference report from the navigation pane.

  1. Expand the navigation pane.

  2. Expand My Folders.

  3. Click your report name.

  4. Click View action.

  5. The supporting reference balances report is displayed.

Note:

If you don't see any data, the balances may not yet be updated. In that case, you must run the Update Subledger Accounting Balances process and then view again.