This guide also applies to on-premise implementations

4Oracle Fusion General Ledger

This chapter contains the following:

Oracle Transactional Business Intelligence Reports for GL: Explained

This topic includes details about the Oracle Fusion General Ledger reports predefined using Oracle Transactional Business Intelligence (BI).

Overview

These reports assist in reviewing journals, accounts, and balances. You can use these reports as part of your reconciliation process.

The image is the Account Analysis Report using
Oracle Transactional Business Intelligence.

The Oracle Business Intelligence Publisher reports for the General Ledger include:

Journal Reports Description

Account Analysis Report

Provides the beginning, periodic activity, and ending balances for the selected accounts and periods. Drill down on the periodic activity balance provides journal details and transactions details including journal source, category, transaction number, and event class.

General Journals Report

Provides the journals activity for the selected period. The content can be filtered by ledger set, ledger, entered currency, approval status, date range, account, source, category, journal batch, and batch status.

Trial Balance Report

Provides the beginning, periodic activity, and ending balances summarized by balancing segment, natural account, and cost center for the selected ledger, accounting period, and currency.

Key Insights

Before running the journal reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Columns

Oracle Transactional Business Intelligence reporting tool provides embedded analytics and supports online inquiry for most transactions. The selections you make are dependent on the columns that were chosen during the report definition.

The output of data in a predefined format provides little or no interaction and simplifies your reporting.

The image shows the columns defined in the General
Journals report.

Frequently Asked Questions

The following table lists frequently asked questions about these reports.

FAQ Answer

How do find these reports?

Edit, run, and view these reports from Navigator > Tools > Reports and Analytics > Financials > General Ledger.

Who uses these reports?

  • Financial Managers

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During period close to verify all transactions have been imported and journals posted.

  • In account balance reconciliations.

What type of reports are these?

Oracle Transactional Business Intelligence

Oracle Fusion General Ledger Predefined Reports

Oracle Fusion General Ledger provides predefined reports that cover the following areas:

  • Account Analysis

  • Journals

  • Trial Balance Reports

  • Reconciliation Reports

  • Chart of Accounts

You can schedule and run reports from the Scheduled Processes work area. In some cases, you can access and open reports in the Reports and Analytics work area. Both work areas are found under Tools on the Navigator. Use the icon on the top of the Reports and Analytics work area to launch the business intelligence (BI) catalog where you can also run and edit reports.

The following tables are the predefined reports.

Account Analysis Reports Description

Account Analysis

  • Prints balances by account segment and a secondary segment for each journal entry.

  • Lists the subledger document number for transactions imported from subledgers.

General Ledger Account Details Report

  • Provides journal information to trace each transaction back to its original source.

  • Prints a separate page for each balancing segment value.

  • For each journal line, prints:

    • The account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.

    • Journal details including source, category, journal name, and effective date.

  • Lists accounts in ascending order by account segment value.

  • Prints a CR next to credit amounts.

Account Analysis for Contra Account Report

  • Prints balances by account segment and a secondary segment.

  • Lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.

  • Prints by date range, accounting flexfield range, contra account, and amount range.

Average Balance Audit Account Analysis Report

  • Displays the detail account activity which created the aggregate balances and related average balances.

  • Displays daily average balance information for the selected accounts for the specified range of dates.

  • Contains parameters such as the as-of reporting date, average balance type (period, quarter, or year average-to-date), and account ranges.

Note

Use to research how average balances are calculated for an account.

Journal Reports Description

Journals Report

  • Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

  • Prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal.

  • Includes a total for each balancing segment and a grand total for all the activity.

General Journals Report

Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

Journals Batch Summary Report

  • Lists posted journal batches for a particular ledger, balancing segment value, currency, and date range.

  • Provides information on actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. Sorts the information by journal batch within each journal entry category.

  • Includes totals each journal category and a grand total for each ledger and balancing segment value combination.

  • Does not report on budget or encumbrance balances.

Journals Details Report

Provides information on manually entered journals prior to posting, including field by field, all data entered into the system or data imported from external sources.

Journals Day Book Report

  • Provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.

  • Sorts journal entries for each accounting date by document number.

  • Prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate.

  • Prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.

Trial Balance Reports Description

Trial Balance Report

Provides summarized actual account balances and activity by ledger, balancing segment, and account segment value.

Trial Balance - Average Balances

  • Provides a listing of ending balances and average balances for selected accounts based on an effective date specified.

  • Prints the ledger currency or foreign-entered balances.

  • Displays period, quarter, and year average-to-date balances.

Note

Request additional information by specifying balancing segments and account ranges.

Reconciliation Reports Description

Cash to General Ledger Reconciliation Report

Extracts cash management and general ledger accounting and transactional data for reconciling cash management to the general ledger.

Payables to Ledger Reconciliation Report

  • Provides both summarized and detailed reconciling data for review.

  • Shows payables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted.

Receivables to Ledger Reconciliation Report

  • Provides reconciliation of receivables data to the general ledger.

  • Shows receivables and accounting beginning and ending balances, as well as summarized activity for the period and how the activity was accounted.

Chart of Accounts Reports Description

Balancing Segment Value Assignments Report

  • Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting set ups.

  • Allows quick identification of overlapping balancing segment value errors and reviews of any unassigned values.

Note

The application does not check for overlapping balancing segment values online.

Chart of Accounts Mapping Rules Report

  • Provides both the segment and account rules defined for a specific chart of accounts mapping.

  • If the mapping has account rules, prints each subsidiary account range and the parent account into which it maps.

  • If the mapping has segment rules, prints the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, prints each subsidiary segment value range and its corresponding parent segment value.

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

  1. Click the Schedule New Process button.

  2. Search for your process name.

  3. Enter your parameters.

  4. Enter your process options and schedule.

  5. Click Submit.

GL Account Analysis Reports: Explained

This topic includes details about the Oracle Fusion General Ledger account analysis reports.

Overview

The account analysis reports assist in reviewing journals and related transactions. You can use these reports as part of your reconciliation process and in preparation of your closing entries.

The image shows an Account Analysis for Contra
Account Report.

The account analysis reports include:

Account Analysis Reports Description

Account Analysis

  • Prints balances by account segment and a secondary segment for each journal entry.

  • Lists the subledger document number for transactions imported from subledgers.

General Ledger Account Details Report

  • Provides journal information to trace each transaction back to its original source.

  • Prints a separate page for each balancing segment value.

  • For each journal line, prints:

    • The account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.

    • Journal details including source, category, journal name, and effective date.

  • Lists accounts in ascending order by account segment value.

  • Prints a CR next to credit amounts.

Account Analysis for Contra Account Report

  • Prints balances by account segment and a secondary segment.

  • Lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.

  • Prints by date range, accounting flexfield range, contra account, and amount range.

Average Balance Audit Account Analysis Report

  • Displays the detail account activity which created the aggregate balances and related average balances.

  • Displays daily average balance information for the selected accounts for the specified range of dates.

  • Contains parameters such as the as-of reporting date, average balance type (period, quarter, or year average-to-date), and account ranges.

Note

Use to research how average balances are calculated for an account.

Key Insights

Before running the account analysis reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the reports above:

Parameter Description Example

Data Access Set

Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.

US Ledger Set

Encumbrance Type

When Balance Type of Encumbrance is selected, gives the option to select Commitments or Obligations.

Commitments

Account Type

Indicates whether the amounts represent Base, Period, Quarter, or Year to Date. For Average Balancing, indicates Period Average, Quarter Average, or Year Average to Date.

PATD Period Average to date balance used in average balance processing.

Includes User Transaction Identifiers

List of identifiers linking the account generation and the transaction, for example PO Number. This helps in identifying the parent transaction.

No

Account, Account Range, or Contra Account Filters and Conditions Defined

Restricts the data reported based on the entered filter and condition.

Company equals 101

Additional Segment

To run the report by account and another segment.

Cost Center

Document Sequence

Uniquely identifies each business document or business event with a number if enabled.

Invoice

From and To Document Number

Assigned unique document sequence number.

101

Frequently Asked Questions

The following table lists frequently asked questions about the account analysis reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During preparation of closing entries.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

GL Journal Reports: Explained

This topic includes details about the Oracle Fusion General Ledger journal reports.

Overview

The journal reports assist in reviewing journals activity. You can use these reports as part of your reconciliation process and in ensuring completion of posting of all entries before period close.

The image shows the Journals Report.

The journal reports include:

Journal Reports Description

Journals Report

  • Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

  • Prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal.

  • Includes a total for each balancing segment and a grand total for all the activity.

General Journals Report

Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

Journals Batch Summary Report

  • Lists posted journal batches for a particular ledger, balancing segment value, currency, and date range.

  • Provides information on actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. Sorts the information by journal batch within each journal entry category.

  • Includes totals each journal category and a grand total for each ledger and balancing segment value combination.

  • Does not report on budget or encumbrance balances.

Journals Details Report

Provides information on manually entered journals prior to posting, including field by field, all data entered into the system or data imported from external sources.

Journals Day Book Report

  • Provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.

  • Sorts journal entries for each accounting date by document number.

  • Prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate.

  • Prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.

Key Insights

Before running the journal reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the reports above:

Parameter Description Example

Data Access Set

Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.

US Ledger Set

From and To Accounting Date

Determines the date on which the journal is recorded. Must be in an open or future enterable accounting period.

10-01-2014

Includes Adjustment Period

Select to include journals posted in adjustment periods.

No

Frequently Asked Questions

The following table lists frequently asked questions about the journal reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During period close to verify all transactions have been imported and journals posted.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

GL Trial Balance Reports: Explained

This topic includes details about the Oracle Fusion General Ledger trial balance reports.

Overview

The trial balance reports assist in reviewing general ledger balances. You can use these reports as part of your reconciliation process and in ensuring completion of the period close.

The image shows the Trial Balance Report.

The trial balance reports include:

Trial Balance Reports Description

Trial Balance Report

Provides summarized actual account balances and activity by ledger, balancing segment, and account segment value.

General Ledger Trial Balance

Lists detail or summary actual account balances and activity by ledger, balancing segment, and account segment: the report prints the value, description, debit or credit balance for beginning and period end, and debits and credits for period activity.

Trial Balance - Average Balances

  • Provides a listing of ending balances and average balances for selected accounts based on an effective date specified.

  • Prints the ledger currency or foreign-entered balances.

  • Displays period, quarter, and year average-to-date balances.

Note

Request additional information by specifying balancing segments and account ranges.

Key Insights

Before running the trial balance reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the reports above:

Parameter Description Example

Data Access Set

Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.

US Ledger Set

Balancing Segment Filter and Condition Defined

Restricts the data reported based on the entered balancing segment filter and condition.

Company equals 101

Account Filter and Condition Defined

Restricts the data reported based on the account segment filters and conditions.

Cost Center does not equal 100

Summarized By

Determines if the report is only summarized by the Natural Account or the Natural Account plus another segment.

Natural Account

From and To Accounting Date

Determines the date on which the journal is recorded. Must be in an open or future enterable accounting period.

10-01-2014

Includes Adjustment Period

Select to include journals posted in adjustment periods.

No

Frequently Asked Questions

The following table lists frequently asked questions about the trial balance reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Managers

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During month-end reconciliation.

  • During period close to verify all transactions have been processed.

What type of reports are these?

Oracle Business Intelligence Publisher

GL Reconciliation Reports: Explained

This topic includes details about the Oracle Fusion General Ledger reconciliation reports.

Overview

The reconciliation reports assist in reconciling journals and related transactions. You can use these reports as part of your reconciliation with your subledgers.

The image show the Receivables to Ledger Reconciliation
Summary Report.

The reconciliations reports include:

Reconciliation Reports Description

Cash to General Ledger Reconciliation Report

Extracts cash management and general ledger accounting and transactional data for reconciling cash management to the general ledger.

Payables to Ledger Reconciliation Report

  • Provides both summarized and detailed reconciling data for review.

  • Shows payables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted.

Receivables to Ledger Reconciliation Report

  • Provides reconciliation of receivables data to the general ledger.

  • Shows receivables and accounting beginning and ending balances, as well as summarized activity for the period and how the activity was accounted.

Key Insights

Before running the reconciliations reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the reports above:

Parameter Description Example

Bank Account

Account used for your cash transactions.

Bank of America

Include Intercompany Transactions

Include or exclude intercompany transactions or run the report for intercompany transactions only.

Yes

Include Bills Payable

Include the transactions formerly known as a future dated payment which instruct your bank to disburse funds to your supplier's bank on a specific date known as the maturity date.

Yes

Include On-Account Items

Include items which are credits applied to a customer's account.

Yes

Include Unapplied and Unidentified Receipts

Include receipts that have not been applied to a customer's account.

Yes

Account Filters and Conditions Defined

Restricts the data reported based on the entered filter and condition.

Company equals 101

Frequently Asked Questions

The following table lists frequently asked questions about the reconciliation reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During period close to verify all transactions have been imported and journals posted.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

GL Chart of Accounts Reports: Explained

This topic includes details about the Oracle Fusion General Ledger chart of accounts reports.

Overview

The account analysis reports assist in reviewing journals and related transactions. You can use these reports as part of your reconciliation process and in preparation of your closing entries.

The image shows the Chart of Accounts Mapping Rules
Report.

The chart of accounts reports include:

Chart of Accounts Reports Description

Balancing Segment Value Assignments Report

  • Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting set ups.

  • Allows quick identification of overlapping balancing segment value errors and reviews of any unassigned values.

Note

The application does not check for overlapping balancing segment values online.

Chart of Accounts Mapping Rules Report

  • Provides both the segment and account rules defined for a specific chart of accounts mapping.

  • If the mapping has account rules, prints each subsidiary account range and the parent account into which it maps.

  • If the mapping has segment rules, prints the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, prints each subsidiary segment value range and its corresponding parent segment value.

Key Insights

Before running the chart of accounts reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the reports above:

Parameter Description Example

Value Set

Enter the value set that contains the balancing segments you are reporting on.

Corporate Company

From and To Balancing Segments

Enter the description of the balancing segment value to report from and to.

Canada

Assignment Status

Select one of the following options: All, Ledger only, Legal Entity, only, or Unassigned to

Ledger only

Actuating Configuration

Select the ledger you want to report on.

US Primary Ledger

Show Only Balancing Segment Values with Multiple Assignments

Show only those balancing segment values that have more than one legal entity assigned to it.

No

Chart of Accounts Mapping

Select the mapping you have defined.

CN code to US CoAs Mapping

Tree Version Effective Date

Select the date that determines which tree version to use as one of the report's criteria.

11/28/2014

Frequently Asked Questions

The following table lists frequently asked questions about the chart of accounts reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During preparation of closing entries.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher