I am happy to present you the Document on "Flow of Accounting in Oracle Applications" for
the benefit of the members of the Oracle Community.
My advise to members is to first read the document as follows
a) Read the Basics of Accounting from Oracle Perspective if you are Non-accounting Background
http://www.google.com/search?q=site:apps2fusion.com+basics-of-accounting-in-oracle-erp-ebs-3
b) Next Read the Accounting Overview Document as per the below Link
http://www.google.com/search?q=site:apps2fusion.com+basics-of-accounting-in-oracle-erp-ebs-part-ii-case-study-and-powerpoint-present-3
c) Then read the below pdf Document and attached output files which will show with the Opening Balance sheet,
Transactions from Subledgers,Closing Trial Balance, Profit and Loss Account and Balance Sheet.
I hope this Document will be helpful for all readers of Oracle Community irrespective of their
level in oracle as Preliminary, Intermediate, Skilled, Advanced and Expert level.
I have not covered much about the Set up here and placed more concentration only on the Accounting from a Business Perspective.
Your comments and feedback are most welcome.
Below Document is to make the readers to understand the flow of accounting in Oracle applications,
in Purchasing, Manufacturing, Inventory, Order Management and Financial Modules Payables, Receivables,
Cash management and General ledger. It also contains step by step screenshots to explain the flow.
Flow Of Accounting Entries In Oracle Applications [MS-WORD - Screenshots are clearer in MS-WORD]
Flow Of Accounting Entries In Oracle Applications [PDF]
Overview PowerPoint Presentation
Flow_of_Accounting_Entries_in_Oracle_Applications.ppt
Following are the various report outputs for this training exercise
Financial_Statement_Generator_131107_BS.txt
Financial_Statement_Generator_131107_PandL.txt
Trial_Balance_Detail_131107.txt
Material_account_distribution__141107.txt
Payables_Account_Analysis_Repo_141107.txt
Receiving_Account_Distribution_141107.txt
Account_Analysis_Subledger_D_151107.txt
Trial_Balance__Detail.txt
Thanks and Regards
Sivakumar
Comments
Thanks a lot. I am a techno-function al without any accounting background(exce pt the Accountancy paper in MCA syllubus). Now the accounting flow is very clear... Hope to get more from you. All the very best
Can i get your contact details and email id, i need to talk to you on certain issues.
Can you plaese add adetailed document on Consolidation? All the documents provided are excellent.
Than k you,
Best regards,
Binoy
Abraham C.I.
Your article is very nice. Thanks for all your efforts.
Could you please explain the hierarchy of financial structure in oracle appliations (ie Business Group, Legal Entity, SOB...) with some real examples.
Than ks a lot,
Gupta
Great article and excellent blog for oracle EBS.
Thanks for Articles.I have one reuest ...do you have by any chance Documents on KITS handling in Oracle.I can send you the details scenario...if reuired...
Vin ay
If you have any doc on interconpany kindly share it with me.
Thanks in advance,
John Pasha Shaik
Perfect Document.
Thank s
Mahmoud Ashry
Tha nks for sharing this doc , hope u continue so begginer like myself can clear most of doubt..once again thank you very much.
Ashish D
Thanks a lot for your informative article. I have a doubt :
In any Transaction, One of the Account is debited and another one is credited (Assuming Dual accounting system).
Now any of these 2 accounts can be :
a) One of Asset/Revenue/L iability/Expens e/Owners' Equity account.
b) One of Balance Sheet or P/L Account
c) One of Real,Personal or Nominal Account.
Obviou sbly it's one out of a,b,c simultaneously. Now my Question is specific to Oracle Apps. In the transactions happening in any of the modules Like Payables( Invoice Creation), Purchasing (Receipting), Receibles (Receipt Entry) etc, Is there any system followed regarding the categories of accounts getting debited or credited. For eg. In Typical AP Invoice creation step, the accounting enteries are :-
Expense A/c Dr to Liability A/C Cr
My question is ...can it have any of the cross combinations out of above (a,b,c).
Like Expense against revenue ...or asset against liability etc...
If so, what kind of control mechanism is followed while consolidating these accounting enteries...ie Is it possible that sum of individual sub-categories have mismatch in their debits/credits. .like Sum of all Assets Enteries Sum of Debit enteries.
If i have knowledge of this concept, i can guess the other account if i am aware of one of the account getting debited or credited in a transaction.
W ith Regards
Ravi.
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 '''''''''''
he lp me
thanks
Can you share some documents showing Oracle Projects (Accounting Flows) and projects integration with other modules like payables, receivables, assets and GL in accounting perspective?
T hanks
Imran :)
I am working in Apps from last 5 years. I am Tech consultant and know GL working completly. Could you please guide on gaining expertize knowledge (both Technical and Func) on AP, AR and OM. From where to start ?
Thanks,
KK CHOPRA
Appreciat e if you please share me the latest AIM tool to download BR100s
Regards
Srikanth
Thanks for posting very good informative documents here.
Iam looking for Payroll Accounting Entries details, if you can provide the same will be great.
Thanks a lot
Shiva
RSS feed for comments to this post