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.