590 likes | 1.61k Views
Oracle General Ledger Process. R12 General Ledger Management Fundamentals. Objectives. After completing this lesson, you should be able to do the following: Identify the steps required to complete the accounting cycle using Oracle General Ledger.
E N D
Oracle General Ledger Process R12 General Ledger Management Fundamentals
Objectives After completing this lesson, you should be able to do the following: Identify the steps required to complete the accounting cycle using Oracle General Ledger. Describe how Oracle General Ledger integrates with other Oracle eBusiness applications. Describe the implementation considerations for setting up and using Oracle General Ledger and the Oracle eBusiness Suite.
Oracle General Ledger Overview Other Subledgers Manufacturing Customer Relationship Management Oracle General Ledger Projects Oracle Financials Human Resources Management
General Ledger Overview Other Subledgers Review Edit General Ledger Record Analyze, Correct, and Adjust
Functions and Features Information Access Data Collection Financial Controls Financial Reporting and Analysis
General Ledger Accounting Cycle Review/ Correct Balances Consolidate Run Reports/ Close Period Revalue/ Translate Open Period Review Create/Reverse Journal Entries Post
Critical Implementation Issues Identify critical implementation issues that affect multiple business areas: Shared information Information flows Open interfaces Non-Oracle systems
Oracle General Ledger Integrates with … Financials • Payables • Receivables • Assets • Purchasing • Projects • Treasury • Property Manager • Lease Management HRMS • Human Resources • Payroll Continued…
Manufacturing Inventory Work in Process Labor Distribution Oracle General Ledger Integrates with … • Public Sector • Grants Accounting • Public Sector Budgeting • Public Sector Financials • Federal Financials Continued…
Also Integrates with … Business Intelligence/Analytic Solutions • Financial Consolidation Hub • Enterprise Planning and Budgeting (EPB) • Oracle Financial Services Applications (OFSA) • Daily Business Intelligence (DBI) • Activity-Based Management (OABM)
Integrating with Subledgers Journal Import Subledgers GL_INTERFACE GL_BALANCES Post Journals
Importing to General Ledgerfrom Non-Oracle Applications Journal Import Web ADI Budgets Other feeder systems General Ledger
Overview of Accounting Setup Manager Central place for defining and maintaining accounting setup for the following: • Legal Entities • Operating Units • Ledgers (primary and secondary ledgers) • Reporting Currencies • Subledger Accounting • Intercompany and Intracompany Balancing • Sequencing (Accounting and Reporting Sequencing)
Foreign Currency Concepts The three key foreign currency concepts in Oracle General Ledger are: Conversion Revaluation Translation
If one or more of the following are different, If difference is only currency, US GAAP Accrual Calendar Accounting Method Chart of accounts Currency Use Reporting Currencies Use a Secondary Ledger Multiple Currency Support
Budgeting Oracle General Ledger gives you a variety of tools to create, maintain, and track your budgets, including the ability to upload budget amounts from an Excel spreadsheet. January 2002 Cost Center 100 Actuals Budgets Variance Salaries 14,000 15,000 1,000 Supplies 4,000 3,500 (500) Travel 1,500 1,700 200 TOTAL 19,500 20,200 700
Exception alerts • Allocations rules Enhanced reporting • Many out of the box calculations Businessprocess flows Overview of Enterprise Planning and Budgeting (EPB) EPB
Reporting and Analysis Oracle General Ledger provides you with a variety of reporting, consolidating, and analysis capabilities. Online account and transaction analysis Standard reports and listings Financial Statement Generator reports Web ADI Report Manager Oracle Enterprise Planning and Budgeting
Standard Reports and Listings Oracle General Ledger delivers over 70 standard reports. The following categories provide financial and non-financial information for General Ledger data. Account Analysis Budget Chart of Accounts Consolidation Currency General Ledger Journals Trial Balance Execution Other
Financial StatementGenerator Reports (FSG) Oracle General Ledger's Financial Statement Generator (FSG) is a powerful and flexible tool you can use to build your own custom reports without programming. Row Report Column
Summary In this lesson, you should have learned how to: Identify the steps required to complete the accounting cycle using Oracle General Ledger. Describe how Oracle General Ledger integrates with other Oracle eBusiness applications. Describe the implementation considerations for setting up and using Oracle General Ledger and the Oracle eBusiness Suite.