Oracle General Ledger Implementation Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

General Ledger Setup

Overview of Setting Up

      Implementation Considerations

      Setting Up General Ledger

      General Ledger Setup Flowchart

      Accounting Setup Manager

      Setup Checklist

      General Ledger Setup Steps

Planning and Installation

      Defining Your Chart of Accounts

      The Intercompany Segment and Use of Security Rules

      Defining Descriptive Flexfields for General Ledger

Designing Your Accounting Flexfield

      Determining Your Account Needs

      Designing Your Account Segments

      Defining an Accounting Flexfield Segment for Future Use

      Defining Your Account Structure

      Permitted Chart of Accounts Changes

      Assigning the Management Segment to an Existing Chart of Accounts

      Defining Segment Qualifiers

      Parent and Child Values and Rollup Groups

Defining Accounts

      Segment Value Inheritance

The Account Hierarchy Manager

      Account Hierarchy Manager Overview

      Planning Your Hierarchies

      Security

      Starting the Account Hierarchy Manager

      The Account Hierarchy Manager Interface

      Displaying Multiple Hierarchies

      The Account Hierarchy Manager Toolbar

      The Account Hierarchy Manager Menu

      Mouse Activated Menus

      Adding or Changing Account Hierarchies with the Account Hierarchy Manager

      Adding or Changing Parent Values with the Account Hierarchy Manager

      Adding or Changing Child Values with the Account Hierarchy Manager

      Adding and Changing Rollup Groups with the Account Hierarchy Manager

      Exporting From the Account Hierarchy Manager

      Closing the Account Hierarchy Manager

Project Tracking in General Ledger

      Maintaining Project Balances

      Reporting on Projects in General Ledger

Mapping Charts of Accounts

      Definition Access Set Security

      Selecting Mapping Rules

      Rollup Rules

      Using Summary Accounts

Period Types

Calendars

      Defining Calendars

      Adding Periods to a Calendar

      Changing a Calendar

Defining Transaction Calendars

      Business Day Defaults

Defining Ledgers

Defining Ledger Sets

      Securing Ledger Sets

Data Access Sets

      Planning Your Data Access Sets

      Using Data Access Sets

      Data Access Set Examples

      Defining Data Access Sets

Definition Access Sets

      Defining Definition Access Sets

      Securing Definitions

      Modifying Definition Privileges

Setting Up Journal Approval

Setting Up General Ledger

      Journal Sources

Journal Categories

Suspense Accounts

Transaction Codes

Setting Up Transaction Codes

Defining Transaction Codes

Planning Your Summary Accounts

      Determining Your Summary Account Needs

      Planning the Summary Account Structure

      Planning Parent Values and Rollup Groups

      Planning Summary Account Templates

Defining Summary Accounts

      Entering Summary Account Templates

      Maintaining Summary Accounts

      Setting the Summary Account Budgetary Control Options

Defining Statistical Accounts

Defining Statistical Units of Measure

Document Sequences

Defining Document Sequences

Assigning Document Sequences

      Assigning Document Sequences by Ledger and Entry Method

Upgrading Balances to Track Balances Entered in the Ledger Currency

      Conflicts with Other Processes and Activities

Entering Employees

Setting Up Automatic Tax Calculation

Setting Up Journal Reconciliation

      1. Enable Reconciliation for Account Segment Values

      2. Enable Reconciliation for Code Combinations

Defining Financial Schedules

Storage Parameters for Interim Tables

Opening and Closing Accounting Periods

      Data Access Sets

      Open and Close Periods Window

      Opening an Encumbrance Year

      Open and Close Periods Programs

Oracle General Ledger Command Center Setup

Setting Up General Ledger Command Center

Setup and Configuration Steps for General Ledger Command Center

Reviewing Data Access Security Setup for General Ledger Command Center

Profile Options for General Ledger Command Center

Loading General Ledger Data

Integrating with Oracle Fusion Applications

Overview of Oracle Fusion Applications

Overview of Oracle General Ledger and Oracle Fusion Accounting Hub Integration

Integrating Hyperion Data Relationship Management (DRM) with Oracle General Ledger

Overview of Hyperion Data Relationship Management

Explaining DRM Configurations

Configuring Oracle General Ledger

      Setting System Profile Values

      Populating the Data Relationship Management Password

Loading Values from the Oracle E-Business Suite to DRM

Loading Segment Values and Hierarchies into Oracle General Ledger

Using DRM to Manage Segment Values and Hierarchies for Oracle General Ledger

Improving General Ledger Performance

Improving General Ledger Performance

Running the Maintain Summary Templates Program

Running the Optimizer Program

Setting Profile Options for Concurrent Program Performance

Optimizing Performance by Creating Indices on GL_CODE_COMBINATIONS Table

Function Security

Function Security in General Ledger

Business Events

Business Event System Seed Data for Oracle General Ledger

Index