1. Can you post unbalanced monitory journal in Oracle GL ?
· Yes,always
· Only if suspense posting has been enabled
· Only if monitory posting has been enabled
· No,never
2. What are the different levels of Budgetory control ?
· Open-Close-Current
· Absolute-Current-Open
· Active-Current-Frozen
· Absolute-Advisory-None
3. ------Rates are used for Translate Revenue and Expense Accounts ?
· PJTD Rates
· PTD Rates
· Period Average Rates
· QTD Rates
4. What are the different methods available for Consolidation ?
· Balances & Averages
· Balances & Transactions
· Both
· None
5. How many minimum segments should be there in GL ?
· 1
· 2
· 30
· None
6. Once a budget is defined first period is unchangeable ?
· False
· True
· Depends on the the Budget Type
· None
7. What does Allow Dynamic Insert does ?
· Creates Code Combination
· Creates Code Combination with the Segment seperator
· Freezes the Flex field definition
· None
8. The table associated with the Segment Qualifier is ?
a. Require Budget journal determines ?
b. Whether the Budget is a Planning Budget
c. Whether the Budget is a Funding Budget
d. Both (a) and (b)
e. None
9. What are the types of Boundry in Budgets available in GL?
a. Period-Quarter-Year
b. Period-Quarter if the amount type is PTD
c. Period-Quarter-Year if the amount type is YTD
d. both (b) and (c)
10. Revaluation is done for ?
a. Assets/Liabilities
b. Expenses Only
c. Both (a) and (b)
d. None
11. Which of the following is true in connection with Consolidation ?
· We should have minimum of two Setofbooks
· Translation is a pre-required step for Consolidation
· Consolidation puts datas of Translation into Parent Setofbook
· All
12. What are the types of Interfaces ?
· Open System Interface and Budget Upload
· Gl Import and Budget Upload
· Open System Interface and Feeder System Interface
· None
13. For what purpose is a transaction calendar used?
A. Translation
B. Depreciation
C. Average balance processing
D. Scheduling
14. Which option best describes the function of security rules?
A. they restrict access to a Set of Books
B. They restrict access to account combinations
C. They restrict access to segment values
D. They restrict access to forms
15. Which of the following are advantages of using the open interface tables supplied with Oracle Applications?
A. Tables are open for all users to access.
B. Invalid data is automatically cleaned.
C. Third-party data-export programs can easily populate the feeder tables, because the configuration of those tables is known.
D. None
16. If a journal with four different balancing entities is out of balance, what accounts will be used as balancing accounts?
A. Intercompany account
B. Suspense account
C. Offset account
D. Target account
17. Which of the following is Funds available equation
A. FAE=Budgeted +(Actual-Encumbrance).
B. FAE=Budgeted - (Actual+Encumbrance).
C. FAE=Budgeted + (Actual+Encumbrance).
D. FAE=Budgeted - (Actual-Encumbrance)
18. Why do we require the cross validation rules ?
A. It gives the account values for accross the segments.
B. It validate the data across segments of a flexifield.
C. It restrict the user to enter the values.
E. It allows the user to write the new cross validatin rules.
19. What type of journal entries can send for journal approval ?
A. Other.
B. Actual.
C. Manual.
D. Transfered.
20. Which one of the following MassAllocations options usually generates the most journal lines?
A. Constant
B. Looping
C. Summing
21. Unposted batched are stored in which table?
A.GL_JE_LINES_POST
B. GL_JE_LINES_UNPOSTED
C. GL_JE_UNPOST
D. GL_JE_LINES
22. Name any 4 reports associated with Trial-Balance?
23. In calendar definition what are the year types and what is the max period a calendar can have?
24. Which schema provides access to all Oracle Applications tables?
25. Which data element is not in Oracle General Ledger ?
a. Budgets
b. Journal entries
c. Customers
d. Accounts Master File
26. Which line number is used as balancing account in recurring journal?
e. The last line of the recurring journal
f. 1
g. 9999
h. 99999
27. By what entity is the authorization dollar limit for manual journal entry set?
i. Position
j. Journal source
k. Journal category
l. Employee
28. For which of the following conversion type can you override the exchange rate in a foreign journal?
m. Corporate
n. Reporting
o. User
p. Spot
29. To which account should revaluation adjustments be posted?
q. Unrealized gain/loss
r. Cumulative translation adjustments
s. Suspense
t. Intercompany
30. What are the tables which get populated when you run Journal Import?
31. Which is the Profile Option that has to be set to enter statistical journals?
32. Name the Segment Mapping rules used for defining consolidations.
33. In case both segment rules and account rules are defined which one overrides the other?
34. Write a select statement to get the default set of books id while defining report parameters.
35. How many calendars can be attached to a set of books
a. One
b. Two
c. Three
d. No Limit
36. What should be the value for the status_code column when journals are populated into the interface table for the first time?