General Ledger

Oracle Applications: Key Flex Field Structures & How to Retrieve Information.

Posted by Jiltin     Tags: , 18 May, 2009    5,876 views    (0) Comment

Here is some of quite commonly used AOL FND ( Foundation) tables and their usage. There are many other tables also in FND but here i am putting only few commonly used tables. for other table if needed we can dig further. FND_ID_FLEXS stores registration information about key flexfields. Each row includes the four–character code that identifies the key flexfield, the title of the flexfield (by which a user identifies theflexfield), the name of the combinations table that contains the key Read Full Article (Click here)...

Categories : 11i Scripts, General Ledger Tags : ,

Oracle Applications – General Ledger FAQ – My Notes Collection

Posted by Jiltin     Tags: , 7 May, 2009    2,962 views    (1) Comment

What is Journal Import? A) Journal import is an interface used to bring journal entries from legacy systems and other modules into the General Ledger.(Specifically Journal Import gets entries from legacy data into the GL base tables. The tables populated during journal Import are GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES, GL_IMPORT_REFERENCES What is the use of GL_Interface? A) Gl_Interface is the primary interface table of General ledger. It acts as an interface between data originating from Read Full Article (Click here)...

Categories : General Ledger, Oracle Applications Tags : ,

Oracle Applications – Order Management, Receivables and General Ledger Cross Flow

Posted by Jiltin     Tags: , , 20 April, 2009    4,140 views    (2) Comment

Order Management to Receivables Flow If you are using Oracle Order Entry, no accounting information is available until you run AutoInvoice. Order Management Transfers all the transactions to Oracle Receivables using the Receivables Interface. When you run AutoInvoice that creates the actual transactions and uses AutoAccounting to derive the segment values for the GL Accounts. Whether you are manually entering your receipts or processing them through AutoLockbox, the accounting information is Read Full Article (Click here)...

Categories : General Ledger, Oracle Applications, Order Management, Receivables Tags : , ,

General Ledger in Release 12 – New/changed features

Posted by Jiltin     Tags: , 16 March, 2009    647 views    (1) Comment

1.Multi Org In Release 11i, a user assigned to an Operating Unit (OU) would process data from the products deployed in that OU. To process data for another OU, a user would log out of the first and into the second. The data generated in that OU would be accounted for according to rules generated by various product accounting engines, and posted to general ledger in ways appropriate for the different products, some generating part of the detail at different times in the process. General Read Full Article (Click here)...

Categories : General Ledger, Oracle Applications Tags : ,

Oracle Application interview questions – Techno-functional areas.

Posted by Jiltin     Tags: 22 January, 2009    778 views    (0) Comment

Here are the set of questions normally asked in oracle applications interviews, mainly technical or techno-functional consultants/employees. They are mostly financial areas like AR, AP, GL etc. I do not have answers. Perhaps, you need to do your homework!! How to make dependent value set? How to you make dependent value set step by step? What are the types of value sets with examples? What is a pair value set? what are the Receipts tables? what are the transaction tables? what are the Read Full Article (Click here)...

Categories : General Ledger, Oracle Applications, Receivables Tags :