1. In GL there is no org id. So how do we differentiate the data from different operating units?
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.
2. At what stage is the subledger data posted to GL?
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.
3. What is the difference between GL date and GL posted 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.
4. Can we change the profile value? How?
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.
7. Expain ADI and its features?
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).
9. Can anyone please say me what is EDI and its functions?
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
10. What is planing budget in GL?
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.
11. What is Consolidation in GL?
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
12. How to import data to General Ledger by Feeder System?
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).
13. What are the journal entries in Procure to Pay Cycle?
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
14. What is the difference between gl_date, gl_posted?
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.
15. How can we integrate AR or AP to GL?
we integrate AR or AP to GL through Set of Books
16. Can you disable budgetary control for a 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.
17. Is there a limit to the number of periods in a budget year or how many years a budget can span?
One can define budgetary control for n number of years however, one year can have maximum of 60 fiscal periods.
18. I was able to post a budget journal to a closed period, why?
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.
19. How many Current budgets can you have?
For each set of books you can have only one current budget at a time.
20. Why do not my budget amounts appear on FSGs?
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.
22. Can I update/adjust an existing account range in my budget organization?
Yes you can update an existing account range in Budget Organization.
No can not delete a budget
24. Can anyone tell me about MRC and Multi-Org?
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.
26. What are the setup steps for AP, AR, and GL?
For GL:
1. Set of Books(Chart of Accounts)
2.Calander
3.Currency
For AP:
1.Suppliers(Creditors)
2.Invoice
3.Look up codes
4.Selection of Set of Books
5.Payment Terms
6.Financial & Payable Option
7.Define Banks
For AR:
1.Flexifiled
2System option
3.Payment Terms
4.Open period
5.Auto Accounting
6.Transcation Type
7.Transcation Source
27. How do we integrate AP or AR to GL?
GL is like AR->GL<-AP
AR and AP both transfer the data in GL .
AR Contains all Invoices/Receipts /CM/DM and same way AP also have AP Vouchers.
28. What is the difference between GL date and GL posted date in GL?
GL date is the date used to determine the correct accounting period for your transactions where as the GL posting date is the date when the journal entry is posted th GL.
HR data is at business group level.
GL Data is differentiated based on set of books id.
AP and AR data is mostly at operating unit level.
Inventory, BOM, WIP data is at inventory organizaiton level.
Overview of the Financial Statement Generator
Financial Statement Generator (FSG) is a powerful report building tool for Oracle General Ledger. With FSG, you can:
► Generate financial reports, such as income statements and balance
sheets, based upon data in your general ledger.
Note: If you have average balance processing enabled in your
set of books, you can report on functional, foreign?entered, or
translated average balances.
► Define segment value security rules to restrict financial
information contained in FSG report output generated by specific users and responsibilities.
Note: To apply segment value security rules, the profile option
FSG: Enforce Segment Value Security must be enabled. See: FSG:
Enforce Segment Value Security: page B ? 9
► Define your reports with reusable report objects, making it easy to create new reports from the components of reports you?ve already defined.
► Design custom financial reports to meet specific business needs.
► Print as many reports as you need, simultaneously.
► Print the same report for multiple companies, cost centers,
departments, or any other segment of your account structure, in the same report request.
► Schedule reports to run automatically.
► Produce ad hoc reports whenever you need them.
► Print reports to tab?delimited files for easy import into
client?based spreadsheet programs.In addition, you can use the Report Wizard feature of Applications Desktop Integrator to design and submit your financial repor
31. What is an Invoice? How man?
AR invoice is a document sent to the customer with details like, Bill-to customer code, product code, qty sent, price, currency, credit terms, tax details,etc. Based on this invoice, customer will make payment to the company and the same is applied against the invoice.
AP invoice is the document received from the supplier and contains informations such supplier details, product code, qty, price and tax details. This invoice is entered in the AP module and payment is made to the supplier against this invoice.
32. What are different types of Journal entries?
There are 4 types of journal entries.
1. Basic Journal Entry - Used for most of the accounting transactions
2. Reversing JE - Created by reversing the existing journal entry
3. Recurring JE - Defined once and then generated for subsequent
accounting period
4. Mass Allocation - Created to allocate the revenues and assets to a
group of resources(cost centers, depts, divisions,etc) from a single
Journal.
33. What Subledgers does Oracle General Ledger 11i Drilldown support?
Drilldown from Oracle General Ledger 11i is supported for Oracle Payables, Oracle Receivables, Oracle Assets (except depreciation), Projects, Purchasing, Inventory, and Work in Process (WIP).
34. What id recurring invoices?What are AP setup steps?
Some times suppliers would not be sending any invoices.But still the payment have to made to him.ex: rent,lease rentels. In this situvation we have to create invoice every period wise.For that purpose we have to create one recurring invoice template. Template means with one master copy creating the multiple invoices is called template.here we are creating the one invoice master copy is formally known as arecurring invoice or recurring inavoice tempalate. SET UP:
1) we have to create one special calender
2) we have to create one full distribution set
3) we have to enter payment terms in the recurring invoice window
4) enter the template no,first invoice amount,special invoice amounts
35. What are different types of invoices and what is a recurring invoice?
Types of Invoice :Standard,CM,DM,Expense,Pre-Payment
Recurring Invoice is a type of invoice which occurs at definite intervals of time. The best example for a recurring invoice is Rent paid to the Owner.
