Mostly Asked Oracle General Ledger (GL) Interview Preparation Guide

Download PDF

In GL you will have Set of Books Id defined for each set of books you define for the organizations. Using SOB's ID you will distinguish the Books or Organizations.

Basically after entering the transactions, report will be taken to verify the transactions. In case, if approval is needed, it is approved after verifying the transactions. Once you are sure that the transactions are correct, the same can be posted to GL. Once it is posted, most of the informations for the posted transaction can not be modified in the subledger. In case of any wrong entry, you need to follow the reversal procedure.

Practically, the verification of transactions are done only during the initial stages after implementation. Once the system becomes stable, it is not followed strictly.

Note : Make sure that GL period is open for the transaction GL date.

GL Posted Date : It is the defaultly current date, but you can change it.

GL Date : Beginning and ending GL dates that will be picked up when interface is executed.

nd_profile API can sbe used to set the profile value

fnd_profile.put(name in varchar2,value in varchar2)

MD50 is a Functional design document used in AIM methodology.

mainly used for Application Extensions and Interface functional design.

Terms and conditions differ with each supplier.

Broadly following are the feature / elements of ADI

1.Journal Wizard.

2.Budget Wizard.

3.Report Wizard.

4.Account Hierarchy Editor.

5.Analysis Wizard.

6.Request Center.

ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows users take advantage of many of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, dragging and dropping ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

EDi - Electronic Data Interchange, to send the data to another server/destination via EDI server.,edi is a toll where in whenever the customer is sending the PO it gets saved in this toll, again when the supplier after supplying the material will send an invoice through EDI ,wherein the EDI of the customer will match the PO with the invoice and the invoice will get processed automatically, in case if it is not matching it will be in the error sheet

The plan for the future expenses is planning budget. It is a paper work. There is no funds rerequirement. It does not require journals. There is no restrictions for estimating of funds.

When we have multiple setup and combine primary and secondary books getting the financial reports is called consolidation.

We will use consolidation reports at the time of period end closing

Can upload Journal Entries using ADI (Application Desktop Integrator) functionality.

ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows users take advantage of many of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, dragging and dropping ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

when we receive the material after approve of purchase order 1 . when the Material Received at the Gate Receiving A/C Dr Material AP accrual A/C Cr2. When the Material delivered to The Inv Org Material A/c Dr Purchase Price Variance A/c Dr Receiving A/c Cr3. When the Invoice Is enterd into the Payable with Matching Of PO Material Ap Accrual A/c Dr Invoice Price Variance A/c Dr AP Liability A/c Cr

GL_POSTED_DATE :-Date on which transaction is posted to the GL accountGL_DATE :=GL Date to default to invoices during invocie creationFor more details you can look into the e-TRM of GL.

we integrate AR or AP to GL through Set of Books

Yes, you can disable budgetary control for a set of book by unchecking the 'Enable Budgetary Control' check box in the Budgetary control tab page of the define set of books window.

One can define budgetary control for n number of years however, one year can have maximum of 60 fiscal periods.

Yes you can do so, reason being budget journal is not linked with your accounting period. Once you have open the budget period then you can book budget journal for that whole period.

For each set of books you can have only one current budget at a time.

In Coulum we have to mention the no. for control and also in report set we have put the budget defined in control field

A budget against which accounting transactions are checked for available funds when budgetary control is enable for your set of books.

Yes you can update an existing account range in Budget Organization.

No can not delete a budget

Let me brief you about both MRC and Multi Org. MRC stands for Multi reporting currency . which means you should have different SOBs, One must be primary and others are reporting. (max. 8).

Where as Multi Org concept is we will set up a organisation where we will have a Business group then SOBS then Legal entities then Operating units then Inventory organisations and lastly sub Inventory catagerory.. This set up will help to avoid multiple installations and have only one installation. We will attach all sub ledgers like AP, AR etc at Operating level and GL and FA at SOB level..

HR at Business group level.. There is a lot to discuss on this topic. please refer any avilable oracle material for more details.

Option 1 is the correct one.If we enable it then we can post unbalanced intercompany journals i.e debit <> credit for a balancing entity. For this we have to define intercompany accounts in setup-->Accounts-->Intercompany accounts, which will post the unbalance part to this intercompany account.

And if you disable it you cannot post the journals which are out of balance.