Oracle General Ledger User's Guide

Prerequisites

Creating Journal Entries with the Journal Wizard

Working with Web ADI Layout

Customizing the Layout

Uploading Data

Importing Data using Web ADI Content

Entering Journals for a Prior Period

Entering Journals for a Future Period

Reviewing Budgetary Control Transactions

Reviewing Budgetary Control Transaction Detail

Printing a Budgetary Control Transactions Report

Journal Approval

Oracle General Ledger Journal Approval

GL Initialization & Validation Process

GL Preparer Approval Process

GL Approval Process

GL Request Approval Process

GL No Approver Response Process

Customizable: Verify Authority Process

Oracle General Ledger Journal Approvals Integration with Oracle Approvals Management and Oracle Workflow

Allocating Amounts with Recurring Journals and MassAllocations

Creating Allocation Entries

Creating Allocations Using Recurring Journal Formulas

Creating Net Allocations

Creating Step-Down Allocations

Creating Rate-Based Allocations

Creating Usage-Based Allocations

Using Allocations for Standard Costing

Recurring Journals

About Recurring Journals

Creating Recurring Journal Formula Batches

Securing Recurring Journals

Creating Recurring Journal Entries

Entering Recurring Journal Entry Lines

Entering Recurring Journal, Budget, and Eliminating Entry Formulas

Reporting Currencies

Entering Formulas with EasyCalc

Creating Skeleton Journal Entries

Creating Standard Recurring Journal Entries

Creating Entered Currency Recurring Journal Entries

Copying Entries from an Existing Recurring Journal Batch

Changing a Recurring Journal Entry

Performing Standard Costing with Recurring Journals

Generating Recurring Journal Batches

Scheduling Your Recurring Journal Batch

MassAllocations

About MassAllocations

Creating MassAllocation Batches

Creating MassAllocation Formulas

Entering MassAllocation Formula Lines

Entering a Target Account

Entering an Offsetting Account

Allocation Formula Rules

Validation Business Rules

Reporting Currencies

Generating MassAllocation Journals

Reusing MassAllocation Formulas for Different Ledgers and Balancing Segment Values

Choosing an Allocation Method

MassAllocation Examples

AutoAllocations

AutoAllocations Overview

Oracle Projects and Oracle General Ledger

Parallel Allocation Sets

Step-Down AutoAllocation Sets

Securing AutoAllocation Sets

Submitting AutoAllocation Set Requests

Reviewing the status of your AutoAllocation Sets

Step-Down AutoAllocation Approval Process

Customizing Step-Down AutoAllocations

AutoAllocation Processes

Journal Import

Integrating General Ledger Using Journal Import

Preparing to Import Journals

Exporting Data From Your Feeder System

The GL_INTERFACE Table

Assigning Values for Accounts

Assigning Values for Additional Required and Conditionally Required Columns

Assigning Values for Currency Conversion

Assigning Values to Optional Columns

Required NULL Columns in the GL_INTERFACE Table

Importing Specialized Data

About Journal Import Validation

Multi-Table Journal Import

Importing Journals

How to Import Journals

Setting the Journal Import Run Options

Running the Journal Import Program from Standard Report Submission (SRS)

Correcting Journal Import Data

Correcting Accounts in Journal Import Data

Troubleshooting

Deleting Journal Import Data

Posting Journals

Posting Journal Batches

Cancelling a Batch Posting

Posting to a Suspense Account

Reviewing the Batch Posting Status

Correcting Batch Posting Errors

Posting Journal Batches Automatically (AutoPost)

Generating Reporting Currency Journals

Reversing Journals

Defining Reverse Journal Entries

Generating Reversing Journal Batches

Automatic Journal Reversal

Automatic Journal Reversal Overview

Definition Access Sets

Default Reversal Criteria for Seeded Journal Categories

Setting up an Automated Reversal in a Secondary Ledger

Overview of Journal Reconciliation

Entering Reconciliation References

Performing Automatic Account Reconciliation

Performing Manual Account Reconciliation

Performing Manual Account Reconciliation Reversal

Reconciliation of Transactions with Single or Multiple Currencies

Automatic Journal Scheduling

Incrementing Submissions

Year-End Closing Journals

Income Statement Closing Journals

Balance Sheet Closing Journals

Secondary Tracking Segment

Year-End Close Checklist

Budgeting

Overview of Budgeting

Budgeting Methods

Creating Budget Formulas to Allocate Budget Amounts

Creating a Flexible Budget

Using Top-Down, Bottom-Up, and Middle-Out Budgeting

Using MassBudgeting

Creating Master/Detail Budgets

Master/Detail Budget Example

Uploading Budgets from a Spreadsheet

Budgets

Defining Budgets

Assigning Budget Periods

Opening a Budget Year

Copying Budget Amounts from an Existing Budget

Budget Organizations

Defining Budget Organizations

Assigning Account Ranges to a Budget Organization

Protecting a Budget Organization with a Password

Setting Budgetary Control Options for an Account Range

Copying Account Ranges from an Existing Budget Organization

Adding or Changing Individual Accounts

Changing a Budget Organization

Deleting a Budget Organization

Budget Formulas

Creating Budget Formula Batches

Creating a Budget Formula Entry

Securing Budget Formulas

Entering Budget Formula Entry Lines

Copying Existing Budget Formulas

Changing a Budget Formula Entry

Calculating Budget Amounts

Scheduling Your Budget Formula Batch

MassBudgets

Overview

Defining MassBudgets

Defining a MassBudget Formula

Entering MassBudget Formula Lines

Assigning Segment Types

Entering a Target Account

Entering an Offset Account

Generating MassBudget Journals

Choosing an Allocation Method

Scheduling Your MassBudget Journal Batch

Entering Budget Amounts

Entering Budget Amounts for Multiple Accounts

Using Budget Rules to Distribute Budget Amounts

Budget Rules

Setting the Budget Rule Rounding Options

Entering Statistical Budget Amounts

Entering Budget Journals

Entering Statistical Budget Journals

Creating Unposted Budget Journal Batches

Budget Wizard

Creating a Budget Worksheet

Changing the Budget Worksheet View

Updating Budget Balances Using Budget Wizard

Adding Budget Notes to a Budget Worksheet

Graphing Budgets

Uploading Budgets from Budget Wizard to General Ledger

Transferring Budget Amounts

Transferring Budget Amounts Using Budgetary Control

Entering Budget Transfer Amounts

Uploading Budgets

Integrating General Ledger Using Budget Upload

Understanding the Budget Interface Table

Creating Your Budget Spreadsheet

Loading Data into the Budget Interface Table

About Budget Upload Validation

Correcting Budget Upload Errors

Uploading Budgets to Undefined Accounts

Uploading Budget Amounts to Undefined Accounts

Freezing Budgets

Freezing Budget Formula Batches

Freezing Budget Organizations

Freezing Budgets for a Range of Accounts

Using Budgetary Control and Online Funds Checking

Overview

Funds Checking and Encumbrance Accounting

Defining an Account

Budgetary Control Options

Funds Check Level

Tolerance Percent and Tolerance Amount

Override Amount

Amount Type and Boundary

Latest Encumbrance Year

Budgetary Control Options for Accounts

Budgetary Control Options for Journal Sources and Categories

Detail and Summary Level Budgetary Control

Changing Budgetary Control Options

About Funds Checking

Setting Up Budgetary Control

Reports

Creating Your Own Funds Available Reports

Inquiry

Setting Up Budgetary Control in Purchasing and Payables

Budgetary Control in Purchasing

Checking Funds on Purchasing Documents

Failing Funds Checking

Document Approvals

Reserving Funds for a Purchasing Document

Funds Reservation Status of Purchasing Documents

Requisitions and Budgetary Control

Creating a Requisition

Importing Approved Requisitions

Cancelling a Requisition

Internal Requisitions

Closing a Requisition

Purchase Orders and Budgetary Control

Creating a Purchase Order

Planned Purchase Orders

Blanket Purchase Agreements

Reserving Funds for a Purchase Order

Modifying a Purchase Order

Cancelling a Purchase Order

Receiving

Closing a Purchase Order

Reports and Inquiries in Oracle Purchasing

Budgetary Control in Oracle Payables

Entering an Invoice

Final Match

Prepayments

Approval and Online Invoice Validation

Releasing Funds Holds

Maintaining a Matched Invoice

Relieving Encumbrance Entries

Multiple Currency Transactions

Creating a Budgetary Control Group

Setting Budgetary Control Options for Journal Sources and Categories

Running the Create Journals Program

Running the Mass Funds Check/Reservation Program

Oracle General Ledger Command Center

General Ledger Command Center Overview

Account Analysis Dashboard

Journal Processing Dashboard

Balances Dashboard

Encumbrance Accounting

Overview of Encumbrance Accounting

Defining Encumbrance Types

Entering Encumbrances

Reviewing Encumbrances

Relieving Encumbrances

Viewing Funds Available

Year-End Encumbrance Processing

Performing Year-End Encumbrance Processing

Carrying Forward Year-End Encumbrance and Budget Balances

Average Balance Processing

Overview of Average Balance Processing

Basic Business Needs

Average Balance Examples

General Example

Relationship Between Aggregate and Average Balances

Example: Period Average-to-Date Balance

Example: Quarter Average-to-Date Balance

Example: Year Average-to-Date Balance

Major Features

Effective Date Handling

Back-Value Transactions

Weekends and Holidays

Set Up and Maintenance

Enabling Average Balance Processing

Processing Options for Non-Business Days

Opening a New Period

Archiving and Purging

Multi-Currency Processing

Conversion

Revaluation

Translation

Consolidation

Consolidating Transactions

Consolidating Balances

Online Inquiry

Reporting

Standard Reports

Financial Statement Generator

Online Inquiries

Introduction

Overview of Account Analysis and Drilldown

Overview of Account Inquiry

Account Inquiry

Performing an Account Inquiry

Account Inquiry Example

Performing an Account Inquiry for Ledger Sets

Reviewing Balances in an Account Inquiry

Reviewing Variances Between Account Balance Types

Drilling Down to Journal Detail

Performing a Journal Entry Inquiry

Drilling Down to Oracle Subledger Applications

Drilling Down to Subledger Detail

T-Accounts

Average Balance Inquiry

Performing an Average Balance Inquiry

Detail Average Balance Inquiry

Summary Average Balance Inquiry

Inquiring on Budgets

Performing a Budget Inquiry

Reviewing Budget Balances in a Master Budget Inquiry

Reviewing Budget Balances in a Detail Budget Inquiry

Reviewing Detail Account Balances

Reviewing Budget Journal Detail

Consolidated Balance Inquiry

Performing Consolidated Balance Inquiries

Financial Reporting

Overview of Reporting in General Ledger

Overview of the Financial Statement Generator

Report Building Concepts

Simple Reports

Special Format Reports

Report Distribution

Other FSG Features

Tips and Techniques for Using FSG

Using Financial Statement Generator

Suggestions for Specific Financial Reports

Tips for Designing FSG Reports

Frequently Asked Questions About FSG

FSG Tasks

Defining Row Sets

Securing Row Sets

Assigning Accounts

Defining Report Calculations

Defining Column Sets

Using the Column Set Builder

Creating Column Headings

Defining Column Exceptions

Defining Content Sets

Securing Content Sets

Defining Row Orders

Securing Row Orders

Defining Display Sets

Copying Report Objects

Defining Financial Reports

Securing Reports

Including Budgets, Encumbrances, Currencies, and Constant Periods of Interest in an FSG Report

Defining Financial Report Sets

Securing Report Sets

Copying Report Objects From Another Database (FSG Transfer Program)

FSG Transfer Program Parameters

Running Financial Reports

Running Financial Reports with BI Publisher

FSG Security Rules

Creating a Report Template Using Report Manager

Reporting Attributes

Setting Up Reporting Attributes

Defining Reporting Attribute Value Sets and Values

Defining Context-Sensitive Descriptive Flexfields for Reporting Attributes

Assigning Reporting Attribute Values to Account Segment Values

Specifying Descriptive Flexfield Segments to Use as Reporting Attributes

Running the Reporting Attribute Preparation Program

Running the Reporting Attribute Historical Program

Reporting Attributes Examples

Defining Ad Hoc Reports

Deleting Ad Hoc Reports

Downloading Financial Reports

FSG Reference Information

Row Set Format Options

Row Set Display Types

Content Set Display Types

Standard Column Sets

Amount Types

Column Set Builder Toolbar

Format Masks

Balance Control Options

Currency Control Value Options

Row Set Advanced Options

Column Set Advanced Options

Override Segment Assignments

Display Options

Relative Headings

Row and Column Overrides

FSG Report Parameters

XBRL

Loading/Removing XBRL Taxonomies

BI Publisher Basic Report Templates

Country-Specific Reports

Maintenance

Mass Maintenance

Moving or Merging Account Balances

Defining a Move/Merge Request

Submitting a Move/Merge Request

Mass Maintenance Statuses

Validation and Prevalidation

Reversing a Move/Merge

Purging Move/Merge Tables

Reviewing Move/Merge Audit Journals

Creating New Accounts with Mass Creation

Correcting Misclassified Account Types

Archiving Account Balances and Journal Detail

Prerequisites

Creating a Tablespace for Archived Data

Exporting Archived Data

Purging Archived Account Balances and Journals

Global Consolidation System

Global Consolidation System

Overview

What You Can Consolidate

Special Considerations for Average Daily Balance Ledgers

Implementation Options

Consolidation Process Steps

Consolidation Workbench

Using the State Controller

Gathering Subsidiary Data from Multiple Instances Using Oracle Applications

Gathering Subsidiary Data from Multiple Instances Using Non-Oracle Applications

Consolidating Ledgers with Different Charts of Accounts

Defining Consolidation Definitions

Definition Access Set Security

Consolidation Run Options

Creating Consolidation Sets

Preparing Subsidiary Data

Transferring Subsidiary Data to Your Parent

Consolidating Balances

Consolidating Transactions

Transferring Consolidation Sets

Posting Subsidiary Data

Eliminating Entries

Creating Eliminating Entries

Inquiry, Reporting, and Analysis

Purging Consolidation Audit Data

Multi-Currency

Overview of Multi-Currency Accounting

Overview

Currencies

Defining Currencies

Conversion Rates

Defining Conversion Rate Types

Entering Daily Rates

Loading Daily Rates Automatically

Entering Historical Rates

Revaluing Balances

Translating Balances

Notes on Translation with Historical Rates and Amounts

Notes on Translating Owners' Equity Accounts

Notes on Translating Revenue/Expense Accounts

Notes on Translating Average Balances

Currency Rates Manager

Cross Rates

Using the Daily Rates Spreadsheet Interface

Using the Historical Rates Spreadsheet Interface

Standard Reports and Listings

Running Standard Reports and Listings

Generating Standard Reports Using BI Publisher

XML Output File

Placeholder Syntax for Standard Report Templates

Example of Report Template Layout

General Ledger Standard Reports and Listings

Account Analysis Reports

Account Analysis - Contra Account

Account Analysis Report

Budget Reports and Listings

Budget Hierarchy Listing

Budget Journals by Account Report

Budget Organization Listing

Budget Organization Range Listing

Budgetary Control Transactions Report

Frozen Budgets Accounts Listing

Funds Available Analysis Report

Master/Detail Budget Report

Summary/Detail Budget Report

Unbudgeted Master/Detail Accounts Report

Chart of Accounts Reports and Listings

Account Hierarchy Report

Chart of Accounts Detail Listing

Chart of Accounts Mapping Rules Report

Rollup Detail Listing

Rollup Range Listing

Inactive Accounts Listing

Segment Values Listing

Suspense Accounts Listing

Consolidation Reports

Consolidation Audit Report

Consolidation Exception Report: Disabled Parent Accounts

Consolidation Exception Report: Unmapped Subsidiary Accounts

Consolidation Journals Report

Currency Listings

Daily Conversion Rates Listing

Historical Rates Listing

Financial Statement Generator Reports and Listings

Column Set Detail Listing

Column Set Summary Listing

Content Set Detail Listing

Content Set Summary Listing

Report Detail Listing

Report Set Detail Listing

Report Set Summary Listing

Report Summary Listing

Row Order Detail Listing

Row Set Detail Listing

Row Set Summary Listing

Where Used Report

General Ledger Reports

General Ledger Account Balances Across Ledgers Report

Entered Currency General Ledger Report

General Ledger Report

Journals Reports

Entered Currency Journals Report

General Journals Reports

Journal Batch Summary Report

Journal Entry Report

Journals Line Report

Journals by Document Number Report

Journals - Extended

Journals - Day Book

Journals - Voucher

Journals - Check Report

Tax Journals Report

Automatic Reconciliation Report

Reconciled Transactions Report

Unreconciled Transactions Report

Trial Balance Reports

Trial Balance Report

Average Balance Trial Balance Report

Budget Trial Balance Report

Detail Trial Balance Report

Encumbrance Trial Balance Report

Expanded Trial Balance Report

Trial Balance - Additional Segment Detail Report

Translation Trial Balance Report

Encumbrance Reports

Other Reports and Listings

MassAllocation Formula Listing

Other - Open Encumbrance Balance Report

Recurring Formula Listing

Transaction Code Listing

Units of Measure Report

Value-Added Tax Report

Execution Reports

Archive and Purge Audit Report

Assign Budget Account Ranges Execution Report

AutoPost Execution Report

AutoReverse Execution Report

Budget Assignments AutoCopy Execution Report

Budget Spreadsheet Upload Execution Report

Calendar Validation Execution Report

Carry Forward Execution Report

Create Journal Entries Execution Report

Delete Journal Import Data Execution Report

Historical Rates Execution Report

Journal Import Execution Report

MassAllocations/MassBudgeting Execution Report

Mass Funds Check/Reservation Journal Execution Report

Posting Execution Report

Revaluation Execution Report

Segment Value Inheritance Execution Report

Journal or Subledger-Level Reporting Currencies

Overview of Reporting Currencies

When to Use Reporting Currencies

Translation versus Reporting Currencies

Reporting Currency Features

Setting Up Reporting Currencies

Reporting Currency Setup Steps

Step 1 - Enable or Define Ledgers

Step 2 - Enable and/or Define Currencies

Step 3 - Define Reporting Currencies

Step 4 - Define Responsibilities

Step 5 - Assign Data Access Sets to Responsibilities

Reporting Currency Conversion Rules

Conversion Rounding

Using Reporting Currencies

Considerations For Entering Data into Reporting Currencies

Performing Standard General Ledger Activities

Completing Reporting Currencies-Related Activities in the Correct Order

Implementation Considerations

Terms

Type of Installation

Defining Reporting Currencies for Fresh Install or Upgrade Scenario One

Defining Reporting Currencies for Upgrade Scenario Two

Reporting Currency - Create Opening Balance Journals in Reporting Currency Program

Initialization Tasks

Plan the Initialization

Prepare for the Initialization

Perform the Pre-initialization Tasks

Perform the Initialization

Perform the Post-initialization Tasks

Resume Normal Transaction Processing

Perform Historical Conversion Maintenance

Parameters for Reporting Currency - Create Opening Balance Journals in Reporting Currency Program

Running the Reporting Currency - Create Opening Balance Journals in Reporting Currency Program

Reporting Currency Account Type Specific Conversion

Setup

ADI Journal Wizard Entry

Transaction Processing

Inquiry and Reporting

Using Attachments in General Ledger

Using Attachments in General Ledger

General Ledger Windows with the Attachments Feature

Creating an Attachment

Deleting an Attachment

Types of Attachments

Attachment Security

Index

Oracle General Ledger User's Guide

Contents