Oracle General Ledger User's Guide


Title and Copyright Information

Send Us Your Comments


Journal Entry

The General Ledger Accounting Cycle
Entering Journals
      Creating Journal Batches
      Entering Journals
      Entering Journal Lines
      Entering Taxable Journal Entries
      Entering Entered Currency Journals
      Entering Statistical Journals
      Autocopying Journal Batches
      Changing a Batch Period
      Changing the Journal Entry Currency
      Checking or Reserving Funds for a Journal Batch
      Submitting Journal Batches for Approval
      Approving Journal Batches
Journal Wizard
      Journal Wizard Overview
      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
      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 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
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


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
      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
      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
      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
      Creating Your Own Funds Available Reports
      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
      Closing a Purchase Order
      Reports and Inquiries in Oracle Purchasing
      Budgetary Control in Oracle Payables
      Entering an Invoice
      Final Match
      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

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
      Consolidating Transactions
      Consolidating Balances
      Online Inquiry
      Standard Reports
      Financial Statement Generator

Online Inquiries

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
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
      Loading/Removing XBRL Taxonomies
BI Publisher Basic Report Templates
Country-Specific Reports


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
      Creating a Tablespace for Archived Data
      Exporting Archived Data
      Purging Archived Account Balances and Journals

Global Consolidation System

Global Consolidation System
      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


Overview of Multi-Currency Accounting
      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
      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
      Reporting Currency Account Type Specific Conversion
      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