8Oracle Fusion Subledger Accounting Reports

This chapter contains the following:

Oracle Fusion Subledger Accounting Predefined Reports

Oracle Subledger Accounting provides accounting reports for fiscal and internal control purposes.

The reports are comprehensive from a financial standpoint and include the best source of information for each type of journal entry. These reports can be used in lieu of the General Ledger-based journals and account analysis reports to see detailed subledger journal entries as well as supporting transaction information.

Scheduled Processes work area

Reports can be scheduled and run from the Scheduled Processes work area found in Tools on the Navigator.

Reports and Analytics work area

In some cases, reports are also:

  • These reports are available from the Reports and Analytics work area, found in Tools on the Navigator, or from other work areas.

  • Opened using links that deploy the business intelligence (BI) catalog.

The following table contains the primary predefined reports by type:

Account Analysis Reports

This table contains a listing of Subledger Accounting account analysis reports.

Display Name Description

Account Analysis Report

Provides drill down information about the movement on a particular account for a period or range of periods. It only includes journal entries posted to general ledger.

Account Analysis by Legal Entity Report

Prints account balances by account combination and selected segments with subledger journal details, including third-party information and sequences. Flexible grouping and sorting options are provided at submission.

Journal Reports

This table contains a listing of Subledger Accounting journal reports.

Display Name Description

Daily Journals Report

Lists subledger journal activity for a given period or date range, journal source, entered currency, and journal batch. Report prints detailed subledger journal lines prior to general ledger summarization. Third party and transaction details are also listed for the journal lines.

Journal Entries Report

Displays detailed information for subledger and general ledger journal entries. Groups report by ledger, journal source, journal category, and event class at submission.

Journal Ledger Report

Lists the accounting entries with subledger details like transaction number, transaction date, and line description, using flexible sorting options that are provided at report submission. This report provides a real audit trail between general ledger and subledgers to satisfy legal and business requirements.

Journals and Third Party Report

Prints all journals posted in Oracle Fusion General Ledger for the accounting period. The report provides accounting and reporting sequence details, detailed subledger accounting entry lines reporting level regardless of the ledger journals summarization. Assists in verifying that all journals are accurately recorded in chronological order with no gaps. It uses legal sequencing rules for both accounting entries and source documents.

Subledger Detail Journal Report

Displays information about the posted general ledger journal batches that originate from Oracle Fusion Receivables and Oracle Fusion Payables subledgers. The report prints subledger details like transaction number, transaction date, transaction amount in entered and ledger currency.

Third Party Reports

This table contains a listing of Subledger Accounting third party reports.

Display Name Description

Third-Party Balances Report

Displays subledger balance and account activity information for suppliers and customers.

Third-Party Account Balance Report

Prints account and original third-party transactions impacting the account during a particular period of time. The report is run to ensure that subledger and general ledger balances reconcile, and to identify possible reasons for any discrepancies.

Third-Party Balances Summary Report

Displays information for each account of the third party and third-party site, and account identification. This report can be used as a tool for auditing third-party accounts.

Third-Party Detail and Balances Report

Provides third party account balances and accounting activity details for the requested accounting period range. You can review the accounting process details by third party and audit third-party accounts in detail.

Other Subledger Accounting Reports

This table contains a listing of other Subledger Accounting reports.

Display Name Description

Accounting Event Diagnostic Report

Shows the transaction data used in accounting. The data is collected when the profile option SLA: Enable Diagnostics is set and the Create Accounting process is run.

Subledger Accounting Method Setups Report

Displays the accounting setups for a subledger application and accounting method.

Subledger Period Close Exceptions Report

Lists all accounting events and journal entries that fail period close validation. Groups report by ledger, period, journal source, journal category, and event class at submission.

To run predefined reports, navigate to the Scheduled Processes work area and follow these steps:

  1. Click the Schedule New Process button

  2. Search on the process name.

  3. Enter your parameters.

  4. Enter your process options and schedule.

  5. Click Submit.

SLA Account Analysis Report

This topic includes details about how you can use the Account Analysis Report.

Overview

You can use the Account Analysis report to view information about the movement on a particular account for a period or range of periods.

Here is a screenshot of an example of the Account Analysis Report.

This screenshot shows an example of the Account
Analysis Report.

Key Insights

In the Account Analysis report, you can view only the details of journal entries that are posted to the general ledger.

Report Parameters

Let's look at the parameters of the Account Analysis Report.

Name Description

Subledger Application

Specify the subledger application for which the report is run.

Ledger

Select a ledger that you have access to, either directly through a GL data access set, or through a business unit, asset book, legal entity, or payroll security assignment.

From Accounting Period

Indicate the beginning period for the report data.

To Accounting Period

Indicate the ending period for the report data.

Balance Type

Specify whether the balance type is actual or encumbrance amounts.

Encumbrance Type

If the balance type is Encumbrance, select the encumbrance type.

Include User Transaction Identifiers

Specify whether the user transaction identifiers are included in the report data.

Include Accounts With No Activity

Indicate whether the report should include accounts with no activity in the selected period.

Account Filter

Enter the filtering conditions on the account. You can select all segments for the selected ledger and define conditions including account value ranges.

Frequently Asked Questions

This table contains frequently asked questions about the Account Analysis Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report to review detailed subledger journal entries as well as supporting transaction information.

What type of report is this?

Oracle Business Intelligence Publisher

SLA Journal Entries Report

This topic includes details about how you use the Journal Entries Report.

Overview

You can use the Journal Entries Report to view header and line information for Subledger Accounting and General Ledger journal entries.

Here is a screenshot of an example of the Journal Entries Report.

This screenshot shows an example of the Journal
Entries Report.

Key Insights

You can group the Journal Entries Report by ledger, journal source, journal category, and event class at submission.

Report Parameters

Let's look at the parameters of the Journal Entries Report.

Name Description

Journal Source

Select from a list of enabled journal sources mapped to an accounting generating subledger application.

Ledger

Select a ledger that you have access to either directly through a GL data access set or through a business unit, asset book, legal entity, or payroll security assignment.

Process Category

Specify the process category to report on a specific subledger process category, or leave blank to include all of the process categories.

Journal Category

Specify the journal category to report on a specific subledger journal category, or leave blank to include all of the journal categories.

From Accounting Period

Indicate the beginning period for the report data.

To Accounting Period

Indicate the ending period for the report data.

Balance Type

Indicate whether the balance type is actual or encumbrance amounts.

Encumbrance Type

If the balance type is Encumbrance, select the encumbrance type.

Journal Entry Status

Indicate whether the journal entries are in draft, final, or invalid status.

Transfer or Posting Status

Indicate whether the posting status is transferred but not posted, not transferred, or posted.

Include User Transaction Identifiers

Specify whether the user transaction identifiers are included in the report data.

Frequently Asked Questions

This table lists frequently asked questions about the Journal Entries Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report to review detailed information for Subledger Accounting and General Ledger journal entries.

What type of report is this?

Oracle Business Intelligence Publisher

Third-Party Control Account Balances Report

This topic includes details about how you use the Third-Party Balances Report.

Overview

You can use The Third-Party Control Account Balances Report to review subledger accounting third-party control account balances and activity for suppliers and customers.

Here is a screenshot of the Third-Party Control Account Balances Report.

The screenshot shows an example of  the Third-Party
Control Account Balances Report.

Key Insights

You can view these information in the Third-Party Control Account Balances Report:

  • Third-party balances for subledger accounting third-party control accounts.

  • Subledger journal entry lines that add up to the total period activity for each control account, third party, and third-party site.

  • Third party and third-party site information.

  • User transaction identifiers for the associated entries.

Report Parameters

Let's look at the parameters of the Third-Party Control Account Balances Report.

Name Description

Journal Source

Select from a list of enabled journal sources mapped to an accounting generating subledger application.

Ledger

Select a ledger.

You must have access to the ledger either directly through a GL Data Access Set or through a:

  • Business unit

  • Asset book

  • Payroll security assignment

From Accounting Period

Indicate the beginning period for the report data.

To Accounting Period

Indicate the ending period for the report data.

Third-Party Type

Select the type of third party defined for the subledger application for the journal source. Values are Customer, Supplier, and All.

Third-Party Name

Select a customer or supplier based on the third party type.

Third-Party Site

Select a third-party site for the supplier or customer identified by third-party name.

From Third-Party Number

Indicate the beginning of the range of customer or supplier numbers based on the third party type.

To Third-Party Number

Indicate the ending of the range of customer or supplier numbers greater than or equal to the From value.

Include User Transaction Identifier

Specify whether the user transaction identifiers are included in the report data.

Account Filter

Enter the filtering conditions on the account. You can select all segments for the selected ledger and define conditions including account value ranges.

Frequently Asked Questions

These are some frequently asked questions about the Third-Party Control Account Balances Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report when you want to review subledger accounting third-party control account balances and activity for suppliers and customers.

What type of report is this?

Oracle Business Intelligence Publisher

Accounting Event Diagnostic Report

This topic includes details about how you can use the Accounting Event Diagnostic report.

Overview

In the Accounting Event Diagnostic report, you can view the transaction data used in accounting.

Here is a screenshot of a page in the Accounting Event Diagnostic Report.

This screenshot shows a page in the Accounting
Event Diagnostic Report.

Key Insights

The Accounting Event Diagnostic report includes data that's collected when the profile option SLA: Enable Diagnostics is set and the Create Accounting process is run. This report shows transaction data that's used during a particular run of the create accounting process.

Report Parameters

Let's look at the parameters of the Accounting Event Diagnostic report.

Name Description

Subledger Application

Specify the subledger application for which the report is run.

Ledger

Optional; limits the diagnostic data selected to those of a particular ledger.

Select a ledger that you have access to, either directly through a GL data access set or through a business unit, asset book, legal entity, or payroll security assignment.

Event Class

Optional; limits the diagnostic data to the specified event class within the application.

List of values includes the event classes for the corresponding application.

Event Type

Optional; limits the diagnostic data to the specified event type within the event class.

List of values includes the event types of the current application, entity, and event class.

If no event class is selected, you can't enter a value. If the event type field is blank, all the event types are selected.

Transaction Number

Optional; limits the diagnostic data retrieved to the specified transaction.

Event Number

Optional; limits the diagnostic data retrieved to the specified event.

From Distribution Line Number

Optional; displays the data for the transaction object lines that are equal to or higher than the number specified.

To enable this field, you must enter a transaction number and an event number.

List of values includes all transaction object line numbers for the given event.

To Distribution Line Number

Optional; displays the data for the transaction object lines that are equal to or lower than the number specified.

To enable this field, you must enter a transaction number and an event number.

List of values includes all transaction object line numbers for the given event.

Accounting Program Request ID

Optional; restricts the diagnostic data to the specified request ID.

List of values retrieves the request IDs stored in the diagnostic framework tables.

Errors Only

Required

If Yes is selected, displays the diagnostic framework data only for the events that meet the selection criteria and whose status is Error. Default is No.

Display Source Name

Required

If Yes is selected, the source name is displayed. If No is selected, the source code is displayed. Default is No.

Display Accounting Attributes

Required

If Yes is selected, the accounting attributes are displayed. Default is No.

Frequently Asked Questions

Here are some frequently asked questions about the Accounting Event Diagnostic Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report to review the transaction data that's referenced during accounting through accounting rules and ledger setup.

What type of report is this?

Oracle Business Intelligence Publisher

Subledger Accounting Method Setups Report

This topic includes details about the Subledger Accounting Methods Setup Report.

Overview

The Subledger Accounting Methods Setup Report displays the accounting setups for a subledger application and accounting method.

These figures illustrate an example of the Subledger Accounting Methods Setups Report.

This figure illustrates the Table of Contents page
of the Subledger Accounting Methods Setups Report.This figure illustrates the Accounting Method and
Journal Entry Rule Sets page of the Subledger Accounting Methods Setups
Report.This figure illustrates the Header Description
Rule and Journal Line Rules page of the Subledger Accounting Methods
Setups Report.This figure illustrates the Account Rules page
of the Subledger Accounting Methods Setups Report.This figure illustrates the Line Description Rules
page of the Subledger Accounting Methods Setups Report.

Key Insights

The report can be filtered to view accounting setups for a particular event class and event type within the accounting method.

This report is useful to view the complete setup done for an accounting method as well as for audit purposes.

The Subledger Accounting Methods Setups Report includes details of the following, if they are present:

  • Accounting Method

  • Journal Entry Rule Sets

  • Header Description Rules

  • Journal Line Rules

  • Account Rules

  • Line Description Rules

Report Parameters

This table contains the Subledger Accounting Methods Setups Report parameters.

Name Description

Accounting Method

Specifies the accounting method name.

Subledger Application

Specifies the subledger application for which the report is run.

Event Class

Specifies the event class assigned to the accounting method for journal entry rule set assignments.

Report shows all event class and event type assignments for the accounting method and subledger application if this parameter is blank.

Event Type

Specifies the event type assigned to the accounting method for journal entry rule set assignments.

Report shows all event class and event type assignments for the accounting method and subledger application if this parameter is blank.

Include Component Usage

Specifies whether the report includes the section to show where each component is used.

Frequently Asked Questions

This table contains frequently asked questions about the Subledger Accounting Methods Setup Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Application Administrator or Implementor

When do I use this report?

Use this report to view the complete setup done for an accounting method as well as for audit purposes.

What type of report is this?

Oracle Business Intelligence Publisher

Subledger Period Close Exception Report

This topic includes details about the Subledger Period Close Exception Report.

Overview

The Subledger Period Close Exception Report displays all accounting events and journal entries that fail period close validation.

The following figure is an example of the report.

This figure displays details of the Subledger Period
Close Exception Report.

Key Insights

The report is automatically submitted when closing an accounting period if there are unprocessed accounting events or untransferred journal entries. You can also generate the Subledger Period Close Exceptions Report independently through Scheduled Processes work area.

Report Parameters

The following table describes selected process parameters.

Name Description

Journal Source

Select from a list of enabled journal sources mapped to an accounting generating subledger application.

Ledger or Ledger Set

Select a ledger that you have access to either directly through a GL data access set or through a business unit, asset book, legal entity, or payroll security assignment.

Journal Category

Specify the process category if you want to report on a specific subledger process category, or leave it blank if you want to include all the process categories.

Event Class

Specifies the data to the selected event class within the application. List of values includes the event classes for the corresponding application.

From Accounting Period

Indicate the beginning period for the report data.

To Accounting Period

Indicate the ending period for the report data.

Frequently Asked Questions

The following table lists frequently asked questions about the Subledger Accounting Methods Setup Report.

FAQ Answer

How do I find this report?

This report is automatically submitted when closing an accounting period if there are unprocessed accounting events or untransferred journal entries.

You can also schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report to review all accounting events and journal entries that fail period close validation.

What type of report is this?

Oracle Business Intelligence Publisher

Create Accounting Execution Report

When you submit the Create Accounting process, the Create Accounting Execution Report is submitted automatically if the Create Accounting process completes with a success or warning status. The Create Accounting process output contains a message with the Create Accounting Execution Report request identifier. Use this request identifier to retrieve the execution report output.

Create Accounting Execution Report

The Create Accounting Execution Report can be recreated.

This report can be recreated as needed using the following criteria:

  • Submit the Create Accounting process.

  • Use the same request identifier of the wanted Create Accounting process run previously by the same user, provided that no other Create Accounting process was run with the same criteria.

Carry Forward Subledger Accounting Balances Process

The Carry Forward Subledger Accounting Balances process will carry forward supporting reference balances and third-party control account balances to the current period for a ledger. This process is automatically initiated when the accounting period is newly opened.

Note: The process can also be submitted manually if the initial process executed abnormally when the accounting period was opened.

Parameters

Ledger

The list of ledgers is based on the business units, asset books or legal entities that a subledger user has access to. Only the list of ledgers associated with those business units, asset books or legal entities is shown.

Accounting Period

All periods for the accounting calendar and period type associated with the selected ledger.

Diagnose Subledger Accounting Event Data

The diagnostic framework stores data that is used in the creation of a journal entry so that the data can be reported to analyze accounting issues. The purpose of the process is to provide the transaction data that is referenced during accounting through accounting rules and ledger setup.

The diagnostic framework provides a tool that can be used to determine why the accounting was created in a particular way or why there are errors. Errors may occur because either the source system information or the accounting rules are not as expected.

The following examples describe typical uses of the diagnostic framework features.

  • In the implementation phase, you can launch the Accounting Event Diagnostic report to review the source values available in the transaction objects.

  • On a daily basis, you can use the Accounting Event Diagnostic report to troubleshoot exceptions.

Diagnostic Framework Features

The diagnostic framework features are as follows:

  • SLA: Diagnostic Enabled: This option controls whether diagnostic information is gathered by the Create Accounting process. Use with caution. Selecting this option can cause slow performance.

  • Diagnostic Framework Execution: When the SLA: Diagnostic Enabled option is set to Yes, the diagnostic framework is executed simultaneously with the Create Accounting process. The diagnostic framework data is stored in the diagnostic tables.

  • Accounting Event Diagnostic Report: To view the diagnostic framework report, users submit the Accounting Event Diagnostic process with the appropriate report parameters.

  • Purge Accounting Event Diagnostic Data: Purging is useful when accounting is successfully created so that the volume of information in the report does not increase to a point where it becomes unusable.

    Diagnostic framework data purged:

    • When the data collected can be purged by running the process.

    • When the administrator launches the Purge Accounting Event Diagnostic Data process.

Diagnostic Framework Business Process Flow

The following steps describe the diagnostic framework business process flow:

  1. The administrator sets the SLA: Diagnostics Enabled option to Yes for the user or responsibility.

  2. Users submit the Create Accounting process that automatically executes the diagnostic framework to populate the diagnostic tables. The diagnostic framework gathers source values and other information from the transaction objects.

  3. Users submit the Accounting Event Diagnostic process to view the diagnostic report. Based on the information in the diagnostic report, users may determine if additional or resubmission of information from source systems is required. They may also determine if any updates to the accounting rules is required.

  4. Users run the Create Accounting process again to generate subledger journal entries for events that had an error.

  5. The administrator submits the Purge Accounting Event Diagnostic Data process to purge the results of the diagnostic framework.

Import Supporting Reference Initial Balances

Use the Import Supporting Reference Initial Balances task to import initial supporting references balances. This task enables you to upload subledger journal entries to initialize supporting reference balances. The uploaded journal entries don't impact general ledger balances.

Note: When using the Manage Configuration Packages task to export or import setup data, initial balances that have been imported into one environment are not going to be migrated into another.

You must import balances separately into each environment you maintain.

Access the task from the Setup and Maintenance work area.

Update Subledger Accounting Balances Process

Use the Update Subledger Accounting Balances process (XLABABUP) to update subledger supporting reference balances and third-party control account balances.

This process is run automatically following the Create Accounting process. It should be run manually if the auto run fails for any reason.

Run the report from the Scheduled Processes page and optionally schedule the process to run periodically.

Note: Draft entries do not update balances. To include accurate balances, transactions must be accounted in Final.

Parameters

Subledger Application

List of all user accessible accounting generating subledgers.

Ledger

The list of ledgers is based on the user accessible business units, asset books or legal entities. Only the list of ledgers associated with those business units, asset books or legal entities is shown.

Access the Create Multiperiod Accounting Execution Report

When you submit the Create Multiperiod Accounting process, the Create Multiperiod Accounting Execution Report is automatically submitted. In this report, you can see entries created by the Create Multiperiod Accounting process.

Here is what you do to recreate a Create Multiperiod Accounting Execution Report.

  • Submit the Create Multiperiod Accounting process.

  • Use the same request identifier of the required Create Multiperiod Accounting process that was run previously by the same user. Also, no other Create Multiperiod Accounting process should have been run with the same criteria.

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 Columnsregion.

      • 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.