Oracle General Ledger Overview

Saturday, 31 May 2008 06:32 Ranu Srivastava

Let me first begin with introducing Ranu Srivastava.
Ranu is a techno functional consultant who has worked across Europe in various large scale implementations.
Currently he is implementing apps for one of the largest corporations in the world.
Ranu will be sharing his in-depth technical and functional knowledge with apps2fusion readers. In this first article, he has documented details of steps involved in Oracle General Ledger Implementation. This will give a very good overview of General Ledger product to those that aspire to become Functional Consultants.

Please click on this link, and then right click on gl.pdf to save on your PC

Topics covered in the above article are
General Ledger Overview
Functions and Features
General Ledger Accounting Cycle
Global Accounting Engine
Accounting Methods
Set-Of-Books
Chart of Accounts
Validation and Value Sets
Creating Accounting Flexfields :
Defining the Accounting Flexfield Structure
Defining Hierarchies
Accont Hierarchy Manager :
Set of Books Options
Defining Shorthand Aliases
Maintain the General Ledger Chart of Accounts
Journal Processing in General Ledger
Journal Creation Methods
Journal Components
Journal Entry level information
Importing Journal Entries
Reversing Journal Entries
Posting Journals
Creating Reversing Journals
Reviewing and Correcting Balances
Drilling Down to Journal Detail
T-Accounts
Using Applications Desktop Integrator to Enter Journals
Journal import from Feeder Systems
Journal Entry Automation
Performing Journal Entry Functions
Journal Entry Types
Journal Components
Manual Journal Entries
Reversing Journal Entries
Creating Reversing Journals
Using ADI to Create Journal Entries (refer student guide ,second round?)
Overview of Importing Journal Entries
Importing Journals (N) Journals > Import > Run
Importing Journal References
Reviewing Journal Import Data
Journal Import Verification Process
Posting Journals
Overview of AutoPost
Reversing Journals Automatically
Journal Reversal Criteria
Financial Reporting
R11i Utilizing Standard Financial Reports
Run Financial Reports with ADI
Multiple Reporting Currencies
Foreign Currency Concepts
Multiple Currency Accounting
Conversion Overview
Defining Conversion Rate Types
Entering Daily Rates
Revaluation Overview
Revaluation Process
Period Rates
Translation Overview
Translation with Historical Rates and Amounts
Translating Owners' Equity Accounts
Foreign Currency Listings
Foreign Currency Reports
Quick Reference

Set as favorite

Bookmark

Email This

Comments (30)

Subscribe to this comment's feed

unable to read docs
written by Nathan Jook , May 31, 2008

Hi,
Thanks!!!. When I click on page it doesn't display

report abuse

vote down

vote up

Votes: +2

Download
written by Anil Passi- , May 31, 2008

Apologies, it appears that there were some caching related issues, as I recently enabled caching this site pages for better performance.

Please click on URL below and right click to save gl.pdf

http://apps2fusion.com/trainin...oracle-gl/

report abuse

vote down

vote up

Votes: +2

Thanks
written by Jithendra , June 01, 2008

Hey Ranu and Anil,

Thank you both very much for bringing in a organized and useful article! Thanks a lot once again!

report abuse

vote down

vote up

Votes: +0

Download pdf file
written by William , June 02, 2008

Hi all,

just click the linked document, and write click and save as, thats it. Thanks a lot, good article.

William.

report abuse

vote down

vote up

Votes: +3

...
written by Raj K , June 02, 2008

Hi Ranu

This is excellent compilation of notes in oracle general ledger.

- raj

report abuse

vote down

vote up

Votes: +0

...
written by Ashok Thombre , June 02, 2008

Hi Anil,
Great document..and equally great efforts to made it available to us like me.
Can I request you to have the same document of Order-to-Cash and Procure-to-Pay cycle, please.

Thanks & Regards
Ashok

report abuse

vote down

vote up

Votes: +1

...
written by Anil Passi , June 02, 2008

Indeed a great article from Ranu. He has much more in pipeline.

For procure to pay, visit this link http://apps2fusion.com/trainin...eceivables

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +1

Thank you!!!
written by Nathan Jook , June 02, 2008

I am able to download it now. Thanks again!!!!

report abuse

vote down

vote up

Votes: +0

...
written by praveen appidi , June 05, 2008

hi
for gl.df , when i opened the link , it is showing me error. i cannot see the GL pdf.
thanks
praveen

report abuse

vote down

vote up

Votes: +1

...
written by praveen appidi , June 05, 2008

finally i got it..

can u provide me screen shots for ADI (Application desktop integrator)

thanks

praveen appidi

report abuse

vote down

vote up

Votes: +0

Thanx
written by mohinder , July 25, 2008

Can anybody give me the pdf of Procure to Pay and AR cycle and Manufacturing Cycle

report abuse

vote down

vote up

Votes: +0

...
written by mohinder , July 25, 2008

Can anybody provide me the Procure to Pay , AR and Manufacturing Cycle in pdf format.

report abuse

vote down

vote up

Votes: +0

...
written by pradip , September 02, 2008

Dear all,
I need some urgent help regarding the implementation of Oracle E Business Suite for our 2nd Operating Unit. Pls help me in mentioning the steps to be followed for that.
We have already implemented successfully at our 1st Operating Unit for the modules like
GL, AP,AR Inventory, BOM, WIP ,Purchasing and Order Management.
We are using India Localization, version 11.5.9.
I am explaining the steps what was done for the 1st Operating Unit.

1) Created the Location for the Inventory organization in the location screen as well as Global master and local master for Master Inventory Organization.
2) Created Business Group under the create organization screen. In that under the organization classification we have attached Business group and HR organization.
3) Created Legal entity and attached The SOB and VAT registration Number. named it as XXX1 corporate organization(Master Inventory organization).
In the same form under organization classification we have added the Operating unit and Inventory organization means to say that legal entity, Operating unit and Master Inventory Organization shares the same name.
4) Created the respective Inventory Organization for the Operating Unit .attached Inventory Organization under organization classification.

Now to start off with my new Operating Unit 2 what are the steps I need to follow I suppose
a)I need to create the separate SOB and Legal entity lets name it as XXX2 corporate organization(Master Inventory organization).
b)A separate Operating Unit.
Now can I name the both LE and OU as same as we did for the 1st OU
c)Do I have to create one more Master Inventory Organization for the 2nd Operating Unit. If not then what is the alternative steps.
In My existing Business group the two OU’s have to be brought under( with one already there one more has to be configured)

Pls help me with the set of steps to be followed for that

Thanks a Lot for future suggestions
Regards,
Pradip

report abuse

vote down

vote up

Votes: +0

Full and Thin Multiple Reporting Currency
written by Renuka Kotha , November 05, 2008

I need some help in Multiple Reporting Currency.

Can we have Full and Think MRC in one Instance

Regards
Renuka

report abuse

vote down

vote up

Votes: +0

Thanks for Compherensive and Coot tutorials
written by Virtualkey , November 05, 2008

Hi,

Thanks for detailed tutorials provided here,
Great work.

Virtualkey.

report abuse

vote down

vote up

Votes: +1

...
written by kishor nagbhire , December 09, 2008

hi Ranu
i'm a new user of ur site
can u help me on that topic
i want record in GL

'''''' undefined accounting periods in the current accounting calendar '''''''''''

help me
thanks

report abuse

vote down

vote up

Votes: -1

Nice article
written by Reetesh Sharma , July 27, 2009

Hi Ranu,

Thanks a lot for such a nice and informative article

Regards,
Reetesh Sharma

report abuse

vote down

vote up

Votes: +0

Hi,
written by Vijayabalusu , December 22, 2009

I am not able to open the gl.pdf doc. The doc opens with an error msg. Please advice.

Thanks and Regards
Vijaya

report abuse

vote down

vote up

Votes: +0

Transalation Process steps
written by Zakir , January 26, 2010

Hi

I want to create a translations, and i cannot see my subsidary in the LOV and I cannot see any thing in Type LOV.

request for help

Thank you very much in advance
Zakir

report abuse

vote down

vote up

Votes: +0

capital working prograss
written by Ganesan , February 09, 2010

How to implement in Oracle erp11i for capital working prograss. we have to implement oracle(Finance)

report abuse

vote down

vote up

Votes: +1

Nice Document
written by Muzaffar Ali M S , June 01, 2010

Hi Ranu and Anil,
Thank you both very much oganized and useful document ! Thanks a lot once again!
As i am going to impliment oracle 11i treasury module afresh i appreciate if you can provide me setup steps and case studies
thanks for your time
Muzaffar Ali M.S

report abuse

vote down

vote up

Votes: +0

Some FAQ on GL
written by David Haimes , June 07, 2010

You can check out this blog for GL info.

Start with the GL R12 FAQ if you are new to R12

http://davidhaimes.wordpress.com/2009/12/31/a-few-gl-r12-ledger-faq/

http://intercompanyfinancials.blogspot.com/

report abuse

vote down

vote up

Votes: +0

Request
written by Rajesh Singam , May 12, 2011

Hi Sir,
My name is Rajesh, Greetings for the day.
Present am Technical consultant in one of the company in Hyderabad, For my growth i need to change my position,
So I was selected one of the company in HYD as SSE, But present my project is FINANCIAL Support project.

Can u Please tell me the environment in Finance supporting projects and Please Tell me which material would helpfull to me.

Thanking You sir,
From
Rajesh S

report abuse

vote down

vote up

Votes: +0

Need Suggestion..
written by parvaz ahmed , June 27, 2011

God day Sir,
I am Parvaz present am Technical consultant in one of the company at Hyderabad,I was selected one of the company in Mumbai as SE, But present my project is FINANCIAL(General Ledger) Enhancement project..

Can u Please tell me the environment in Finance Enhancement projects and Please Tell me which material would helpfull to me.

report abuse

vote down

vote up

Votes: +1

Great Info
written by Sameer Alapaty , October 18, 2011

Thanks a ton for both of you

report abuse

vote down

vote up

Votes: +0

...
written by Baha Ghanim , July 07, 2012

Thanks for sharing such valuable information...

I would to know if this tutorial is applicable for Oracle eBusiness Suite 12.1.1?

Cheers,
Baha