Oracle Oracle Certifications 1Z0-960 Questions & Answers

• Question 51:

  Identify three functions of Functional Setup Manager.

  A. Provide a central place to access and perform all of the setup steps across Fusion application product

  B. Automatically generate lists of setup tasks in the correct sequence with dependencies highlighted.

  C. Automatically mark the status of tasks as Completed after they have been completed.

  D. Assign setup tasks to individuals with due dates where users must manually update their completion status.

  E. Centrally manage the close processes across subledgers and ledgers.

  Correct Answer: ABE

• Question 52:

  You are creating financial statements and want to have charts, such as a bar graph, automatically inserted to improve the understanding of the financial results.

  What's the most efficient way to achieve this?

  A. When viewing the report, download to Excel and use Excel's Charting features to create your bar graph.

  B. When designing your financial statement using Financial Report (FR), embed a chart into your report

  C. Use Account Inspector that automatically creates graphs on financial balances.

  D. Use Smart View, which is and Excel Add-on

  Correct Answer: C

• Question 53:

  All of your subsidiaries reside on the same application instance, but some of them require a different chart of accounts and/or accounting calendar and currency. There is no minority interest or partial ownerships.

  What is Oracle's recommend approach to performing consolidations?

  A. Use Oracle Hyperion Financial Management for this type of complex consolidation.

  B. Translate balances to the corporate currency, create a chart of accounts mapping to the corporate Chart of accounts, then transfer balances to the corporate consolidation ledger using the balance transfer program.

  C. Translate balances to the corporate currency for ledgers not in the corporate currency, use General Ledger's Financial Reporting functionality to produce consolidated reports by balancing segment where each report represents a different subsidiary.

  D. Create separate ledgers for each subsidiary that shares the same chart of accounts, calendar, currency and accounting method. Create a separate elimination ledger to enter intercompany eliminations, then create a ledger set across all ledgers and report on the ledger set.

  Correct Answer: D

• Question 54:

  Your customer has three legal entities, 50 departments, and 10,000 natural accounts. They use intercompany entries.

  What is Oracle's recommended best practice when implementing; a new chart of accounts? How many segments and what segment qualifiers should be used?

  A. Define three segments for the company, department, and natural account. The qualifiers shouldbe primary balancing segment, cost center segment, and natural account segment, respectively

  B. Define four segments for the company, department, natur.il account, and intercompany segment. The qualifiers should be primary balancing segment, cost center segment, natural account segment, and intercompany segment, respectively.

  C. Define five segments for the company, department, natural account, intercompany, and future use segment. The qualifiers should be primary balancing segment, cost center segment, natural account segment, intercompany segment, and no qualifier, respectively.

  D. Define three segments tor the company, department, and natural account. The qualifiers for the first segment should be primary balancing segment and intercompany segment, cost center segment, and natural account segment, respectively.

  Correct Answer: C

• Question 55:

  You want to display OTBI reports and graphs in PowerPoint to show general ledger or subledger data.

  How do you accomplish this?

  A. Download OTBI reports and charts to a spreadsheet and then copy and paste the spreadsheet to PowerPoint

  B. Use SmartView to create reports and charts using general ledger and subledger subject areas embed the charts/reports into PowerPoint

  C. Use Smart View and Oracle BI EE View Designer to create reports in PowerPoint, Word, and Excel.

  D. Use Account Inspector and then export to Excel and copy and paste into PowerPoint.

  Correct Answer: C

• Question 56:

  While troubleshooting the encumbrance entries created for the requisition for your business unit, you noticed that only a few events are triggering the encumbrance journals when you submit he create accounting program.

  What are the two events?

  A. Funds check

  B. Requisition approved

  C. Requisition rejected by the buyer

  D. Submit the requisition for approval

  E. Checkout and Save the requisition

  F. Create change request on the requisition after submitting requisition for approval

  Correct Answer: BF

• Question 57:

  You want to process multiple allocations at the same time. What feature do you use?

  A. RuleSets

  B. Point of View (POV)

  C. Formulas

  D. General Ledger Journal entries

  Correct Answer: C

• Question 58:

  You customer is a financial Institution that needs to maintain overage daily balances (ADB).

  Which two statements are true regarding this functionality in Fusion Applications?

  A. ADB provides organizations with the ability to track average and end-of-day balances, reportaverage balance sheets, and create custom reports using both actual and average balances.

  B. Average balances are stored for both subledger balances and general ledger balances.

  C. Average balances are stored in the Essbase cube.

  D. Average balances are maintained for both actual and budget balances.

  E. When using ADB, you must define a daily calendar and assign it to your ADB ledger.

  Correct Answer: AD

• Question 59:

  Fusion Accounting Hub includes Hyperion Data Management. For which two tasks can Hyperion Data Management be used?

  A. chart of accounts hierarchy maintenance

  B. integration with transactions from external feeder systems

  C. chart of accounts master data maintenance

  D. data access and security

  E. cross-validation rules

  Correct Answer: AC

• Question 60:

  What Is Oracle Essbase?

  A. A robust reporting and analysis tool

  B. A relational database

  C. A data ware house

  D. A multidimensional Online Analytical Processing (OLAP) server that is embedded in Fusion GeneralLedger

  Correct Answer: B