General Ledger Chart of Accounts Reports

This topic includes details about the Oracle 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 following figure shows an example of the Chart of Accounts Mapping Rules Report. The parameters for the report include the chart of accounts mapping name and the tree version effective date. The report provides the account rules and segment rules for the specified mapping.

This figure shows the Chart of Accounts Mapping Rules Report.

The following table describes the chart of accounts reports.

Name

Description

Balancing Segment Value Assignments Report

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

  • Lets you quickly identify overlapping balancing segment value errors and review for 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, the report prints each subsidiary account range and the parent account into which it maps.

  • If the mapping has segment rules, the report prints the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, the report 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 and provides examples.

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 Mapping

Tree Version Effective Date

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

8/28/2016

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 Analytics Publisher