Oracle General Ledger (GL) Interview Preparation Guide
Optimize your Oracle GL interview preparation with our curated set of 45 questions. Our questions cover a wide range of topics in Oracle GL to ensure youre well-prepared. Whether youre new to the field or have years of experience, these questions are designed to help you succeed. Secure the free PDF to access all 45 questions and guarantee your preparation for your Oracle GL interview. This guide is crucial for enhancing your readiness and self-assurance.45 Oracle GL Questions and Answers:
1 :: What is the difference between discounts and adjustments?
Discount refers to the payment terms or on quantity(bulk oreder discount)oredered.In the invoice received from supplier,discounts term is sepcificaly stated.E.G. If paid with in 15 days discount @ 2%,what you need to do is pay 2% less then the original invoice amount,however caution should be taken that the freight amount should not be considered while calculating the discount.Adjusment could be for various reasons.Over priced invoice,short delivery of quantity as per goods received note,poor quality etc.Agreed upon amount will be deducted from the invice, while making the payments.
2 :: What are cycles of GL, AP, and AR?
GL Accounting cycle can be further elaborated like this...
1.Open Period.
2.Create Functional and foreign journal entries.(including the journal import from legacy systems and subledgers).
3.Reverse journal entries.
4.Post the journals.
5.Review and correct the balances.
6.Revalue foreign currency balances.
7.Translate foreign currency balances.
8.Consolidate set of books.
9.Run accounting reports.
10.Close the accounting periods.
AP cycle
--------
Purchase Order --> Receipt --> AP voucher --> Payment made
AR Cycle
--------
Sales Order --> Shipment --> Invoice --> Payment receipt
GL cycle
--------
Direct GL JE / Transfer subledger data to GL --> Post
1.Open Period.
2.Create Functional and foreign journal entries.(including the journal import from legacy systems and subledgers).
3.Reverse journal entries.
4.Post the journals.
5.Review and correct the balances.
6.Revalue foreign currency balances.
7.Translate foreign currency balances.
8.Consolidate set of books.
9.Run accounting reports.
10.Close the accounting periods.
AP cycle
--------
Purchase Order --> Receipt --> AP voucher --> Payment made
AR Cycle
--------
Sales Order --> Shipment --> Invoice --> Payment receipt
GL cycle
--------
Direct GL JE / Transfer subledger data to GL --> Post
3 :: What are Summary Accounts and Rollup groups?
Summary Account is an account whose balance represents the sum of other account balances. You can use summary accounts for faster reporting and inquiry as well as in formulas and allocations.
Rollup group is a collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.
Rollup group is a collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.
4 :: Get the following message on Drilldown - Function not available to this responsibility. Change responsibility or contact your system administrator?
All the setups(Form, form function, form function attaching to menu, menu to responsibility) are fine. But even I am getting the error Function is not available to this responsibiltiy, please contact the system administrator.
This error we are getting for all custom developed forms. Same things are working fine in other instances.
This error we are getting for all custom developed forms. Same things are working fine in other instances.
5 :: Differences between VB.Net and C#, related to OOPS concepts?
VB.NET is a windows application
Where as C# is a console
vb.net is supported multiple inheritance c# does not supported multiple inheritances
Where as C# is a console
vb.net is supported multiple inheritance c# does not supported multiple inheritances
6 :: What is Set of Books? What are the four conditions when you change your SOBs?
set of book is a combination of currency,calendar,chart of accounts. Four conditions when u change ur sob is:
1.check your currency
2.check your calendar
3.check your chart of accounts
4.You have to assign your sob to your responsibility
1.check your currency
2.check your calendar
3.check your chart of accounts
4.You have to assign your sob to your responsibility
7 :: What are different period types?
If it is accounting period types, then there are three pre-defined types, namely month, quarter and year. User can also add period types.
If it is period status, then there are 5 period status, namely Never opened, Open, Future Enterable, closed and Permanently closed.
If it is period status, then there are 5 period status, namely Never opened, Open, Future Enterable, closed and Permanently closed.
8 :: Explain types of invoices are there in AP and AR?
Types of invoices:
Invoice
Credit Memo
Debit Memo
Gaurantee
Charge Back
Deposite
Invoice
Credit Memo
Debit Memo
Gaurantee
Charge Back
Deposite
9 :: What is the difference between cross-validation rules and security-rules?
Cross Validation Rule:Rules that define valid combinations of segment values a user can enter in an account. Cross-validation rules restrict users from entering invalid combinations of account segment values.
Security Rule:It determines the accounting transaction user can view at differenty levels of hierarchy, such as at Site Level -->Application Level --> Responsibility Level --> User level.
Security Rule:It determines the accounting transaction user can view at differenty levels of hierarchy, such as at Site Level -->Application Level --> Responsibility Level --> User level.
10 :: In how many ways can you enter a journal in GL?
1. Manual entry
2. Subledger Entry
3. Spreadsheet Entry
4. Recurring Entry
5. Mass Allocation
2. Subledger Entry
3. Spreadsheet Entry
4. Recurring Entry
5. Mass Allocation