Tài liệu Oracle General Ledger Guide docx

®

Oracle

General Ledger

Guide

This page intentionally left blank

®

Oracle

General Ledger

Guide

Melanie Anjele Cameron

New York Chicago San Francisco

Lisbon London Madrid Mexico City Milan

New Delhi San Juan Seoul Singapore Sydney Toronto

Copyright © 2009 by The McGraw-Hill Companies, Inc. All rights reserved. Except as permitted under the United States Copyright Act

of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval

system, without the prior written permission of the publisher.

ISBN: 978-0-07-162230-1

MHID: 0-07-162230-6

The material in this eBook also appears in the print version of this title: ISBN: 978-0-07-162229-5, MHID: 0-07-162229-2.

All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked

name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the

trademark. Where such designations appear in this book, they have been printed with initial caps.

McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate train￾ing programs. To contact a representative please e-mail us at [email protected].

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. All other trademarks are the property of their respective own￾ers, and McGraw-Hill makes no claim of ownership by the mention of products that contain these marks.

Screen displays of copyrighted Oracle software programs have been reproduced herein with the permission of Oracle Corporation and/or

its affiliates.

Information has been obtained by Publisher from sources believed to be reliable. However, because of the possibility of human or

mechanical error by our sources, Publisher, or others, Publisher does not guarantee to the accuracy, adequacy, or completeness of any

information included in this work and is not responsible for any errors or omissions or the results obtained from the use of such infor￾mation.

Oracle Corporation does not make any representations or warranties as to the accuracy, adequacy, or completeness of any information

contained in this Work, and is not responsible for any errors or omissions.

TERMS OF USE

This is a copyrighted work and The McGraw-Hill Companies, Inc. (“McGraw-Hill”) and its licensors reserve all rights in and to the

work. Use of this work is subject to these terms. Except as permitted under the Copyright Act of 1976 and the right to store and retrieve

one copy of the work, you may not decompile, disassemble, reverse engineer, reproduce, modify, create derivative works based upon,

transmit, distribute, disseminate, sell, publish or sublicense the work or any part of it without McGraw-Hill’s prior consent. You may use

the work for your own noncommercial and personal use; any other use of the work is strictly prohibited. Your right to use the work may

be terminated if you fail to comply with these terms.

THE WORK IS PROVIDED “AS IS.” McGRAW-HILL AND ITS LICENSORS MAKE NO GUARANTEES OR WARRANTIES AS

TO THE ACCURACY, ADEQUACY OR COMPLETENESS OF OR RESULTS TO BE OBTAINED FROM USING THE WORK,

INCLUDING ANY INFORMATION THAT CAN BE ACCESSED THROUGH THE WORK VIA HYPERLINK OR OTHERWISE,

AND EXPRESSLY DISCLAIM ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED

WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. McGraw-Hill and its licensors do not

warrant or guarantee that the functions contained in the work will meet your requirements or that its operation will be uninterrupted or

error free. Neither McGraw-Hill nor its licensors shall be liable to you or anyone else for any inaccuracy, error or omission, regardless

of cause, in the work or for any damages resulting therefrom. McGraw-Hill has no responsibility for the content of any information

accessed through the work. Under no circumstances shall McGraw-Hill and/or its licensors be liable for any indirect, incidental, spe￾cial, punitive, consequential or similar damages that result from the use of or inability to use the work, even if any of them has been

advised of the possibility of such damages. This limitation of liability shall apply to any claim or cause whatsoever whether such claim

or cause arises in contract, tort or otherwise.

For Bill, whose support and love made this book possible.

About the Author

Melanie Anjele Cameron has

dedicated her career to improving

business processes and business

systems, especially in the areas of

finance and accounting. Always a

strong believer in the sharing of

knowledge about computer systems

and how to use them, she has been

the chairperson for the AZOAUG,

the Phoenix-area Oracle applications

users group, for the past seven

years, participating not only in

scheduling the events but also as a

lecturer. Her career has taken her

from a transaction processing clerk

to an executive during an IPO, as

well as co-owner of her husband’s

business, giving her a well-rounded

and in-depth knowledge of business,

from detailed transactions to their broader impact on the business itself. Lucky to find

an organization where this breadth of knowledge can be used to assist other

companies, Melanie now manages the E-Business Suite practice at MSS Technologies,

Inc. (www.MSSTech.com).

While participating in the high-tech world of business, Melanie keeps her feet firmly

planted in the low-tech world of needlework, spending most of her nonworking hours

knitting and creating pieces of art with a needle, including needlepoint and Japanese

embroidery. This, combined with a love for good food and cooking, helps to keep the

pressures of our high-tech society at bay. Melanie lives in Scottsdale, Arizona, with her

husband, Bill, and two dogs, Josie and Yuki.

About the Technical Editor

Colin Terry is a Chartered Management Accountant who currently works as an

independent consultant in the ERP software and associated applications arena. Relying

on his accounting background, his primary area of expertise is financials applications,

and most of his experience has involved the Oracle E-Business Suite. He does, however,

have a strong understanding of much of the Oracle E-Business Suite product set and has

had exposure to a number of other software applications, both COTS and proprietary.

Since originally transferring from the accounting function to information systems

and technology some fifteen years ago, Colin’s roles have encompassed business

process design, applications configuration, training, test execution and management,

data migration, and support. He has been engaged to work for companies in a wide

range of industry sectors, including aerospace and defense, software publishing and

distribution, and public transport. Colin is an active member of the UK Oracle User

Group and currently sits on the committee of the Financials Special Interest Group.

Contents at a Glance

PART I

General Ledger: Concepts, Setups, and Processing

1 Business Considerations for New Implementations . . . . . . . . . . . . . . . . . . . . . . . 3

2 Business Considerations for Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

3 Setup Considerations: New Implementation and Upgrades . . . . . . . . . . . . . . . . . 25

4 General Ledger Setups and Maintenance: Step by Step . . . . . . . . . . . . . . . . . . . . 35

5 Transaction Processing and Flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103

6 Financial Statement Generator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127

7 Consolidations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159

8 Budget Tracking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171

9 Currencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193

10 Reporting, Inquiry, and Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203

11 Monthly Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223

PART II

Subledger Accounting: Concepts and Setups

12 Subledger Accounting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231

13 Subledger Accounting Seeded Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235

14 Subledger Accounting Modified Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247

Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271

vii

This page intentionally left blank

Contents

Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii

PART I

General Ledger: Concepts, Setups, and Processing

1 Business Considerations for New Implementations . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Chart of Accounts and Ledgers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

Business Process Reengineering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

Customizations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Data Conversions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Payables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Receivables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

Fixed Assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Manufacturing and Purchasing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Conversion Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Accelerator Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

Testing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

Consistency and Data Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Training . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

2 Business Considerations for Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

Reimplement vs. Upgrade? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Instances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Current System Version . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

Data and Setup Accuracy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

Customizations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

System Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

Considerations During the Project and Post-Production . . . . . . . . . . . . . . . . . . . . . . . . 18

Planning for the Upgrade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

ix

x Oracle General Ledger Guide

R12 Specific Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20

Ledgers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21

Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21

Subledger Accounting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22

ADI Differences and FSG Reporting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23

3 Setup Considerations: New Implementation and Upgrades . . . . . . . . . . . . . . . . . . . . . 25

Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

Descriptive Flexfields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

Journal Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27

Calendars . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27

Securing the General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27

Setting Up Access Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30

Year-End Processing Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32

4 General Ledger Setups and Maintenance: Step by Step . . . . . . . . . . . . . . . . . . . . . . . . 35

The Account Number . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

Setting Up the Accounting Flexfield . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38

Adding Segments to the Accounting Flexfield . . . . . . . . . . . . . . . . . . . . . . . . . . 39

Creating a Value Set for the Accounting Flexfield . . . . . . . . . . . . . . . . . . . . . . . 40

Adding Information on the Segments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42

Adding and Maintaining Values for Your Accounting Segments . . . . . . . . . . . . 44

Viewing and Maintaining Account Hierarchies for

Parent/Child Relationships . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47

Account Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49

Correcting Accounts Set Up Incorrectly . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

Custom Segments for Tracking Additional Data (Optional) . . . . . . . . . . . . . . . . . . . . . . 55

Calendars (Required) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

Calendar Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

Calendars . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57

Validating Calendars . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58

Changing Your Fiscal Year End . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58

Special Calendars for Average Balance Calculations . . . . . . . . . . . . . . . . . . . . . 59

Currencies (Optional) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

Journal Controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61

Journal Sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61

Journal Categories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61

Enabling Automatic Posting and Reversals . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63

Journal Approvals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65

Ledger and Legal Entity Setups (Required) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68

Setting Up Legal Entities (Conditionally Required) . . . . . . . . . . . . . . . . . . . . . . 68

Setting Up Ledgers (Required) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70

Required Profile Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79

Inter- and Intracompany Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79

Secondary Ledgers (Optional) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83

Additional Secondary Ledger Setup Options . . . . . . . . . . . . . . . . . . . . . . . . . . . 84

Restricting and Grouping Data (Optional) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85

Ledger Sets to Group Ledger Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85

Data Access Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86

Contents xi

Document Sequences: Additional Setups (Required If Using Sequencing) . . . . . . . . . . . 88

Defining Sequences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88

Assigning Sequences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88

Additional Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89

Defining Security Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90

Assigning Security Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90

General Ledger Profile Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91

5 Transaction Processing and Flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103

Subledger Transaction Flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104

Procure to Pay . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105

Order to Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105

Journal Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105

Importing Journals from Third-Party Sources or Subledgers . . . . . . . . . . . . . . . . 106

Manual Journal Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110

Attachments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113

Journal Wizard–Web ADI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114

Posting Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118

Reversing Journal Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120

Allocation and Recurring Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120

Account Reconciliations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124

Copying Journal Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126

Tying It All Together . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126

6 Financial Statement Generator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127

FSG Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128

Report Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129

Row Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131

Column Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137

Restricting Content . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143

Ordering Detailed Account Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145

Display Options to Control Rows and Columns Displayed on a Report . . . . . . . . . . . . 146

Display Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146

Display Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147

Putting It All Together . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147

Report Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149

Copying in the Same Instance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149

Copying from One Instance to Another . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149

Standard Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150

Running FSG Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151

Report Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151

7 Consolidations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159

Consolidation Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160

Ledger Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160

Consolidation Hub . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161

Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161

Defining the Consolidation Definition and Mapping . . . . . . . . . . . . . . . . . . . . . 161

Defining Mappings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161

Defining Consolidations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162

Combining Consolidations into Sets for Processing . . . . . . . . . . . . . . . . . . . . . . 164

xii Oracle General Ledger Guide

Performing Consolidations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165

Eliminations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168

8 Budget Tracking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171

Budget Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172

The Budget . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173

The Organization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174

Advanced Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176

Loading Budget Data into EBS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176

Budget Amount Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177

Budget Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178

Budget Wizard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179

Freezing Budget Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180

Annual Budget Flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180

Forecasting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181

Encumbrances and Budgetary Controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181

Setups for Encumbrances and Budgetary Controls . . . . . . . . . . . . . . . . . . . . . . 181

Using Encumbrances and Budgetary Controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189

Creating Encumbrance Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189

Performing Funds Checking on Manual Journal Entries . . . . . . . . . . . . . . . . . . . 189

Funds Inquiry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 190

9 Currencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193

Types of Currency Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194

Foreign Currency Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194

Translations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194

Revaluations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196

Currency Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196

Currencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196

Rates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197

Running a Translation for Balance Level Reporting Currencies . . . . . . . . . . . . . . . . . . . 198

Performing Revaluations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200

Defining Revaluations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200

Running Revaluations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201

10 Reporting, Inquiry, and Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203

Grouping Requests to Run Together . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204

Running Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207

Programs That Update Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209

Listings of Setup Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 212

Transactional Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215

Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218

Purchasing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218

Payables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219

Assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219

Receivables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219

Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220

Other EBS Subledgers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220

Inquiry and Research . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220

Contents xiii

11 Monthly Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223

Subledgers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 224

Subledger Closing Order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225

Opening and Closing Periods in the General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . 227

PART II

Subledger Accounting: Concepts and Setups

12 Subledger Accounting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231

SLA Upgrade Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 232

Defining Subledger Accounting Step-by-Step . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233

13 Subledger Accounting Seeded Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235

Defining Subledger Applications (Seeded for EBS Subledgers) . . . . . . . . . . . . . . . . . . . 236

Building the Accounting Methods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237

Defining Subledger Accounting Events (Seeded for EBS Events) . . . . . . . . . . . . 237

Creating Entities in the Event Modeler . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237

Adding Process Categories (Seeded) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238

Identifying Transactions and Their Associated Database Columns (Seeded) . . . 240

Subledger Sources (Seeded for EBS Subledgers) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241

Validating Event Class Options (Seeded for EBS Subledgers) . . . . . . . . . . . . . . . 241

Reviewing and Modifying Journal Entry Setups (Seeded) . . . . . . . . . . . . . . . . . . . . . . . . 242

Journal Line Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 242

Journal Descriptions (Seeded) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 244

14 Subledger Accounting Modified Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247

Mapping Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248

Value Sets Set Up for Use in Mapping Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248

Creating Mapping Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250

Account Derivation Rules for Building the Account Strings . . . . . . . . . . . . . . . . . . . . . . 251

Adding Reference Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255

Putting All the Data Together . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256

Journal Line Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256

Recap of Setups So Far . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260

Application Accounting Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261

Subledger Accounting Methods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 262

Ledger Setups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263

Assigning Subledger Accounting Methods to a Ledger . . . . . . . . . . . . . . . . . . . 263

Creating Ledger Accounting Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263

Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271

This page intentionally left blank