Oracle Fusion Financials: General Ledger 2014 Essentials Sample Questions:
1. You want to display OTBI reports and graphs in PowerPoint to show general ledger or subledger data.
How do you accomplish this?
A) Use SmartView to create reports and charts using general ledger and subledger subject areas embed the charts/reports into PowerPoint
B) Download OTBI reports and charts to a spreadsheet and then copy and paste the spreadsheet to PowerPoint
C) Use Account Inspector and then export to Excel and copy and paste into PowerPoint.
D) Use Smart View and Oracle BI EE View Designer to create reports in PowerPoint, Word, and Excel.
2. You want to automatically post journal batches imported from subledger source to prevent accidental edits of deletions of the subledger sources journals, which could cause an out -ofbalance situation between your sub ledgers and general ledger.
Which two aspects should you consider when defining your AutoPost Criteria?
A) Use the Alloption for category and accounting period to reduce maintenance and ensure that all imported journals are included in the posting process.
B) Schedule your AutoPost Criteria set to run during off-peak hours only
C) Include all of your sub ledger sources in the AutoPost Criteria. Divide up criteria sets by subledger source only if you need to schedule different posting times.
D) Create your AutoPost criteria using minimal source and categories.
3. Which two types of journals can be automatically routed through the journal approval process?
A) Journals imported from third-party systems
B) Manual journals
C) Allocation journals
D) Sub ledger journals
E) Revaluation journals
4. What process must be followed to propagate a chart of accounts hierarchy to the Essbase cube?
A) Define the hierarchy and make sure the tree is active. The hierarchy will be system generated for
B) Define the hierarchy, make sure the tree is active, and the Publish check box is selected for the hierarchy.
C) Define the hierarchy, make sure the tree version is active, and then run the publish account Hierarchies program or the Publish Chart of Accounts Dimension Members and Hierarchies
D) Define the hierarchy, then deploy the chart of accounts. The chart of accounts hierarchies will be generated automatically.
5. You already ran Translation, but a last-minute adjusting journal entry in your ledger currency was entered after you consolidated your results.
What does Oracle consider best practice when this occurs?
A) Translate only the adjusting journal entry.
B) Enter another adjusting journal entry in the currency to true up the balances.
C) Rerun Revaluation and then rerun Translation
D) Rerun Translation and then reconsolidate your result
Solutions:
Question # 1 Answer: D | Question # 2 Answer: C | Question # 3 Answer: A,B | Question # 4 Answer: C | Question # 5 Answer: A |