Oracle General Ledger Predefined Reports

Oracle General Ledger provides predefined reports that cover the following areas: account analysis, journals, trial balance reports, reconciliation reports, charts 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. Use the Browse Catalog icon on the Reports and Analytics work area to open the business intelligence (BI) Catalog. You can run and edit reports in the BI Catalog.

The following table describes the predefined account analysis reports.

Name	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 that 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.

The following table describes the predefined journal reports.

Name	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 about 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 for each journal category and a grand total for each ledger and balancing segment value combination. Doesn't report on budget or encumbrance balances.
Journals Details Report	Provides information about manually entered journals prior to posting, including field by field, all data entered into the applications 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. Note: To run the report for all journal sources and categories, clear the Source and Category fields. 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. Note: When you set the General Ledger Journal Entry Summarization option, as part of the Manage Subledger Accounting Options task, to either Summarize by general ledger date or Summarize by general ledger period, the SUBLEDGER_DOC_SEQUENCE_ID and SUBLEDGER_DOC_SEQUENCE_VALUE columns will be empty in the GL_JE_LINES table, even though document sequencing is enabled. All subledger entry lines are summarized into a single general ledger entry if the following details are the same: accounting period or date, General Ledger journal category, account, entered currency, side, balance type. As a result, the report won't display details in the Subledger Document Sequence and Subledger Document Number columns. Prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.
Reconciled Transactions Report	Provides details of clearing account journal lines that have been successfully reconciled by both automatic and manual reconciliation processes.
Unreconciled Transactions Report	Lists all unreconciled clearing account journal lines, specifically the unreconciled lines that weren't subjected to reconciliation yet, those lines rejected by previous automatic or manual reconciliation processes, and those lines that were marked as reviewed.

The following table describes the predefined trial balance reports.

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

The following table describes the predefined reconciliation reports.

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

The following table describes the predefined chart of account reports.

Name	Description
Balancing Segment Value Assignments Report	Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting setups. Allows quick identification of overlapping balancing segment value errors and reviews of any unassigned values. Note: The application doesn't 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. For mappings with account rules, prints each subsidiary account range and the parent account into which it maps. For mapping with segment rules, prints the rule name and the parent and subsidiary segments. For mappings with a rollup range rule, prints each subsidiary segment value range and its corresponding parent segment value.

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

1. Click Schedule New Process.

2. Search for the process name.

3. Specify the parameters.

4. Enter the process options and schedule.

5. Click Submit.