Oracle General Ledger Implementation Guide

Contents

Title and Copyright Information

Send Us Your Comments

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

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 Step-Down AutoAllocation

Setting Up General Ledger

Journal Sources

Journal Categories

Suspense Accounts

Setting Up Interface Data Transformer (IDT)

Registering a Lookup Table in Meta-Data Structure

Registering a PL/SQL Function in Meta-Data Structure

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

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

Copyright © 1988, 2010, Oracle and/or its affiliates. All rights reserved.