Oracle General Ledger Setup 101

1
Oracle General LedgerSetup 101

• Rob Colten
• Consultant

2
Partnering

• Scandent Solutions a global IT Resources
  Organization
• Oracle Application Worldwide Partner and Oracle
  Certified Solutions Partner
• Dedicated Oracle Applications business unit in
  Oak Brook, IL

3
GL Setup Steps
4
Flexfields

• Flexfield Combination of user-defined Segments
• General Ledger - Accounting (Chart of Accounts)
• Fixed Assets Location, Asset Category
• Receivables Sales Tax Location

5
Accounting Flexfield

• Segments
• Balancing
• Cost Center
• Account
• Intercompany (optional)

6
Other COA Segments

• Division
• Market
• Product
• Branch
• Sub-Account
• GAAP Type
• Region
• Sector

• Store
• Project
• Activity
• Phase
• Basel II
• Customer
• Reserved
• Future (?)

7
Accounting Flexfield

• Segment Qualifiers
• Posting Y/N
• Budgeting Y/N
• Account Type A, E, L, O, R
• Reconciliation Flag Y/N
• Control Account Y/N

8
COA Considerations

• One Global COA versus Multiple COAs with
  consolidation
• Legacy Systems
• Decoder Ring
• Business Process Re-Engineering
• Future is it really necessary?

9
COA Considerations

• Melanie Bock paper You CAN Change Your Chart
  of Accounts
• A Brief Word from one of the Sponsors
• WWW.OAUG.ORG

10
Segment Considerations

• Accounting versus Reporting
• Numeric versus Alphanumeric
• UPPER CASE versus Mixed Case
• Parent accounts
• Segment
• Summary accounts
• Full Code Combination

11
Segment Considerations

• Independent versus Dependent Value Sets
• Generic account descriptions and usage versus
  specific descriptions and usage
• Leading zeros
• Range of Values
• Statutory reporting requirements
• Avoid embedded logic in segment value

12
Test Drive COA

• Look at standard apps reports and FSGs
• Maintenance Routines
• Parents/Rollup Groups
• Code Combinations
• Dynamic Insertion on or off SOX Considerations
• Segment Security
• Cross-Validation Rules
• Shorthand Aliases

13
Descriptive Flexfields

• Store additional information for flexible
  reporting purposes
• 15 to 30 available per table
• Options
• Required/Not Required
• Context sensitive
• Validated/Non-Validated values
• Generally not transferred between apps

14
Calendars

• Period Types
• Calendar Period beginning and ending dates
• Period Name
• Nov-05 versus Period-11-2005
• Adjusting periods allowed

15
Sets of Books

• Three Cs
• Chart of Accounts
• Currency
• Calendar
• Oracle Vision Demo Many Sets of Books
• Global Consolidation System
• Global Intercompany System

16
Other Required Steps

• Profile Options
• Open/Close Accounting Period
• Prior Years ending balance
• Sources default values available
• Categories default values available
• Currencies default values available

17
Optional Steps

• Suspense Accounts
• Intercompany Accounts
• Summary Accounts
• Statistical Units of Measure
• Currency Rates

18
More Optional Steps

• Document Sequences
• Automatic Posting
• Encumbrance Types

19
Questions?

• Robert.Colten_at_scandent.com