Oracle General Ledger Guide

Oracle General Ledger Guide

by Melanie Cameron
Released May 2009
Publisher(s): McGraw Hill Computing
ISBN: 9780071622301

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Master Oracle E-Business Suite's Oracle General Ledger

Maintain a centralized, highly automated processing platform across a fully integrated set of Oracle E-Business Suite applications using Oracle General Ledger. This Oracle Press guide explains how to utilize Oracle General Ledger to distribute timely and accurate financial information enterprise-wide. Learn efficient techniques for creating transactions and budgets, defining custom rules and flows, reconciling balances, and easing regulatory compliance. You will also discover how to consolidate financial data, process foreign currencies, and implement the brand-new Oracle Subledger Accounting.

  • Plan, test, and carry out a new implementation or upgrade
  • Work with ledgers, calendars, journals, budgets, and business flows
  • Convert and load data from external systems and spreadsheets
  • Perform company-wide consolidations
  • Render reports using the Financial Statement Generator
  • Handle foreign transactions, translations, and revaluations
  • Centralize accounting rules using Oracle Subledger Accounting
  • Understand implications of setup and implementation decisions

Table of contents

  1. Cover Page
  2. Oracle General Ledger Guide
  3. Copyright Page
  4. Dedication
  5. About the Author
  6. Contents
  7. Acknowledgments
  8. Introduction
  9. PART I General Ledger: Concepts, Setups, and Processing
    1. CHAPTER 1 Business Considerations for New Implementations
      1. Chart of Accounts and Ledger
        1. Basics
        2. Chart of Accounts
      2. Business Process Reengineering
      3. Customizations
      4. Data Conversions
        1. Payables
        2. Receivables
        3. General Ledger
        4. Fixed Assets
        5. Manufacturing and Purchasing
        6. Conversion Tools
      5. Accelerator Tools
      6. Testing
      7. Consistency and Data Entry
      8. Training
    2. CHAPTER 2 Business Considerations for Upgrades
      1. Reimplement vs. Upgrade?
        1. Instances
        2. Current System Version
        3. Data and Setup Accuracy
        4. Customizations
        5. System Resources
      2. Considerations During the Project and Post-Production
      3. Planning for the Upgrade
      4. R12 Specific Considerations
        1. Ledgers
        2. Chart of Accounts
        3. Subledger Accounting
        4. ADI Differences and FSG Reporting
    3. CHAPTER 3 Setup Considerations: New Implementation and Upgrades
      1. Chart of Accounts
      2. Descriptive Flexfields
      3. Journal Options
      4. Calendars
      5. Securing the General Ledger
        1. Setting Up Access Sets
      6. Year-End Processing Options
    4. CHAPTER 4 General Ledger Setups and Maintenance: Step by Step
      1. The Account Number
        1. Setting Up the Accounting Flexfield
        2. Adding Segments to the Accounting Flexfield
        3. Creating a Value Set for the Accounting Flexfield
        4. Adding Information on the Segments
        5. Adding and Maintaining Values for Your Accounting Segments
        6. Viewing and Maintaining Account Hierarchies for Parent/Child Relationships
        7. Account Maintenance
        8. Correcting Accounts Set Up Incorrectly
      2. Custom Segments for Tracking Additional Data (Optional)
      3. Calendars (Required)
        1. Calendar Types
        2. Calendars
        3. Validating Calendars
        4. Changing Your Fiscal Year End
        5. Special Calendars for Average Balance Calculations
      4. Currencies (Optional)
      5. Journal Controls
        1. Journal Sources
        2. Journal Categories
        3. Enabling Automatic Posting and Reversals
        4. Journal Approvals
      6. Ledger and Legal Entity Setups (Required)
        1. Setting Up Legal Entities (Conditionally Required)
        2. Setting Up Ledgers (Required)
        3. Required Profile Options
        4. Inter- and Intracompany Setups
      7. Secondary Ledgers (Optional)
        1. Additional Secondary Ledger Setup Options
      8. Restricting and Grouping Data (Optional)
        1. Ledger Sets to Group Ledger Access
        2. Data Access Sets
      9. Document Sequences: Additional Setups (Required If Using Sequencing)
        1. Defining Sequences
        2. Assigning Sequences
      10. Additional Security
        1. Defining Security Rules
        2. Assigning Security Rules
      11. General Ledger Profile Options
    5. CHAPTER 5 Transaction Processing and Flows
      1. Subledger Transaction Flows
        1. Procure to Pay
        2. Order to Cash
      2. Journal Entries
        1. Importing Journals from Third-Party Sources or Subledgers
        2. Manual Journal Entries
        3. Attachments
        4. Journal Wizard-Web ADI
        5. Posting Journals
        6. Reversing Journal Entries
        7. Allocation and Recurring Journals
      3. Account Reconciliations
      4. Copying Journal Entries
      5. Tying It All Together
    6. CHAPTER 6 Financial Statement Generator
      1. FSG Overview
      2. Report Overview
      3. Row Definitions
      4. Column Definitions
      5. Restricting Content
      6. Ordering Detailed Account Information
      7. Display Options to Control Rows and Columns Displayed on a Report
        1. Display Groups
        2. Display Sets
      8. Putting It All Together
      9. Report Maintenance
        1. Copying in the Same Instance
        2. Copying from One Instance to Another
        3. Standard Reports
      10. Running FSG Reports
        1. Report Manager
    7. CHAPTER 7 Consolidations
      1. Consolidation Considerations
        1. Ledger Considerations
      2. Consolidation Hub
      3. Setups
        1. Defining the Consolidation Definition and Mapping
        2. Defining Mappings
        3. Defining Consolidations
        4. Combining Consolidations into Sets for Processing
      4. Performing Consolidations
      5. Eliminations
    8. CHAPTER 8 Budget Tracking
      1. Budget Setups
        1. The Budget
        2. The Organization
        3. Advanced Features
      2. Loading Budget Data into EBS
        1. Budget Amount Form
        2. Budget Journals
        3. Budget Wizard
      3. Freezing Budget Data
      4. Annual Budget Flows
      5. Forecasting
      6. Encumbrances and Budgetary Controls
        1. Setups for Encumbrances and Budgetary Controls
      7. Using Encumbrances and Budgetary Controls
        1. Creating Encumbrance Entries
        2. Performing Funds Checking on Manual Journal Entries
        3. Funds Inquiry
    9. CHAPTER 9 Currencies
      1. Types of Currency Transactions
        1. Foreign Currency Transactions
        2. Translations
        3. Revaluations
      2. Currency Setups
        1. Currencies
        2. Rates
      3. Running a Translation for Balance Level Reporting Currencies
      4. Performing Revaluations
        1. Defining Revaluations
        2. Running Revaluations
    10. CHAPTER 10 Reporting, Inquiry, and Integration
      1. Grouping Requests to Run Together
      2. Running Reports
      3. Programs That Update Data
      4. Listings of Setup Data
      5. Transactional Reports
      6. Integration
        1. Purchasing
        2. Payables
        3. Assets
        4. Receivables
        5. Inventory
        6. Other EBS Subledgers
      7. Inquiry and Research
    11. CHAPTER 11 Monthly Processing
      1. Subledgers
        1. Subledger Closing Order
      2. Opening and Closing Periods in the General Ledger
  10. PART II Subledger Accounting: Concepts and Setups
    1. CHAPTER 12 Subledger Accounting
      1. SLA Upgrade Considerations
      2. Defining Subledger Accounting Step-by-Step
    2. CHAPTER 13 Subledger Accounting Seeded Setups
      1. Defining Subledger Applications (Seeded for EBS Subledgers)
      2. Building the Accounting Methods
        1. Defining Subledger Accounting Events (Seeded for EBS Events)
        2. Creating Entities in the Event Modeler
        3. Adding Process Categories (Seeded)
        4. Identifying Transactions and Their Associated Database Columns (Seeded)
      3. Subledger Sources (Seeded for EBS Subledgers)
        1. Validating Event Class Options (Seeded for EBS Subledgers)
      4. Reviewing and Modifying Journal Entry Setups (Seeded)
        1. Journal Line Types
        2. Journal Descriptions (Seeded)
    3. CHAPTER 14 Subledger Accounting Modified Setups
      1. Mapping Sets
        1. Value Sets Set Up for Use in Mapping Sets
        2. Creating Mapping Sets
      2. Account Derivation Rules for Building the Account Strings
      3. Adding Reference Data
      4. Putting All the Data Together
        1. Journal Line Definitions
      5. Recap of Setups So Far
        1. Application Accounting Definitions
        2. Subledger Accounting Methods
      6. Ledger Setups
        1. Assigning Subledger Accounting Methods to a Ledger
        2. Creating Ledger Accounting Options
  11. Glossary
  12. Index

Product information

  • Title: Oracle General Ledger Guide
  • Author(s): Melanie Cameron
  • Release date: May 2009
  • Publisher(s): McGraw Hill Computing
  • ISBN: 9780071622301