1. Using Subledger Accounting
  2. Subledger Accounting Predefined Reports

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.

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.