Oracle General Ledger

Oracle General Ledger

The Oracle General Ledger module within Oracle Financials is an integrated part of the ERP package of Oracle applications. It is a financial management solution within E-business suite for entering and reporting on the financial data of large companies. Oracle claims its GL module can import and post 42 million journal lines per hour, which would make it a suitable GL application for very large enterprises with high GL transaction volume.[1]



The screenshot below [2] from Oracle demonstrates the accounting cycle of Oracle General Ledger.

Accounting cycle.gif

Before setting up oracle GL, The following need to be set up:

(M) = Mandatory step, others are optional

  • Chart of Accounts (M)
  • Account Combinations
  • Period Types (M)
  • Calendar (M)
  • Transaction Calendar
  • Currencies (M)
  • Set of Books or SOB (M)
  • Assign SOB to a responsibility (M)
  • Daily conversion Rate types (M)
  • Rates

Once the above steps are done, to implement Oracle GL the following need to be set up

  • Journal Sources (M)
  • Journal categories (M)
  • Suspense Accounts
  • Inter-company and Summary Accounts
  • Statistical UOM (Unit of Measure)
  • Historical Rates and Document Sequences
  • Automatic Posting and Incumberance types
  • System Controls (M)
  • Budgetory Control Groups
  • Profile options (M)
  • Open / Close GL accounting periods.

Other features of Oracle GL include

  • A single legal entity is possible to assign with multiple ledgers to meet statutory, corporate and regulatory reporting.
  • Multi-currency functionality
  • Chart of Accounts is created segment-wise for reporting hierarchies. Up to 30 segments can be created in a chart of accounts with 25 characters per segment.
  • Financial Statement Generator (FSG) which comes with Oracle GL generates financial reports, such as the income statements and balance sheets from the GL data applying the access security rules. Ad-hoc reports can be prepared with the FSG.
  • Technically, oracle General Ledger - Release 11i contains approximately 130 tables, excluding the temporary processing tables, 70 forms and 140 concurrent programs or reports. The tables and forms which are part of and accessible to GL , but are not owned by the GL user are not included in the above counts. e.g. FND objects owned by APPLSYS are not included.

See also

Further reading

  • Cameron, Melanie. Oracle General Ledger Guide (2009) McGraw-Hill. ISBN 0071622292.



  1. ^ Oracle General Ledger
  2. ^ The General Ledger Accounting Cycle

External links

Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Oracle Applications — comprise the applications software or business software of Oracle Corporation. The term refers to the non database parts of Oracle s software portfolio. Oracle sells many functional modules which use the Oracle RDBMS as a back end, notably Oracle …   Wikipedia

  • Oracle E-Business Suite — Within the overall rubric of Oracle Applications Apps,[1] Oracle Corporation s E Business Suite (also known as Applications/Apps or EB Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management… …   Wikipedia

  • Oracle Property Manager — is a real estate management ERP from Oracle Corporation. It is a part of Oracle e business suite. The current version is PN.M. Oracle Property Manager streamlines and automates lease administration and space management. The cornerstone of Oracle… …   Wikipedia

  • Comparison of accounting software — The following comparison of accounting software documents the various features and differences between different professional accounting software and personal finance packages. Contents 1 Free and open source software 2 Proprietary software 3… …   Wikipedia

  • PeopleSoft — Logo de PeopleSoft Création 1987 Disparition 2005 …   Wikipédia en Français

  • SAP ERP — ist das Hauptprodukt des deutschen Software Unternehmens SAP AG, das es seit 1993 vertreibt. ERP steht für Enterprise Resource Planning oder Unternehmens Informationssystem, womit alle geschäftsrelevanten Bereiche eines Unternehmens im… …   Deutsch Wikipedia

  • J. D. Edwards — J.D. Edwards, also called JDE, is a software company founded in March 1977 in Denver, Colorado by Jack Thompson, C.T.P. Chuck Hintze, Dan Gregory and Ed McVaney. The company made its name building accounting software for IBM minicomputers,… …   Wikipedia

  • Accounts payable — Accountancy Key concepts Accountant · Accounting period · Bookkeeping · Cash and accrual basis · Cash flow management · Chart of accounts  …   Wikipedia

  • Opentaps — Stable release 1.5.0 / February 23, 2011; 8 months ago (2011 02 23) Written in Java …   Wikipedia

  • C. Edward McVaney — Infobox Celebrity image size = 150px name = C. Edward McVaney | birth date = birth date and age|1940|9|29 birth place = Omaha, Nebraska, USA death date = death place = occupation = philanthropist, investor and former Chief executive officer… …   Wikipedia