1Z0-960 Online Practice Questions and Answers

You entered a journal and the client is asking for the following information: ?The current account balance

?What the future account balance will be if the Journal is approved and posted

How will you get this information?

A. View the Projected Balance region in the Create Journals page.

B. Run a Trial Balance before and after posting.

C. Use Oracle Transactional Business Intelligence (OTBI) to query General Ledger balances

D. Query the account balance online.

You want to prevent intercompany transactions from being entered during the last day of the close. What should you do?

A. Close all subledger periods.

B. Close Intercompany periods in Fusion Intercompany.

C. Freeze the Intercompany Journal source in General Ledger.

D. Close the General Ledger period in the Manage Accounting Periods page.

Your foreign currency transactions need to be revalued every month. For balance sheet accounts, you reverse the revaluation journals in the next period. You are using the period- to-date (PTD) method of revaluation tor your income statement accounts.

When should you reverse revaluation journals, if at all required?

A. Reverse them in the same period as the revaluation run.

B. Both balance sheet and income statement revaluation journals should be reversed in the period.

C. Never, because each period's revaluation adjustment is just for that period.

D. The reversals must be done at the end of each quarter.

Your customer is having issues transferring intercompany transactions to General Ledger..

Identify three reasons for this.

A. The intercompany transaction is not approved.

B. The corresponding Payables and Receivables invoice have not been generated.

C. If they are different, then the exchange rate is missing between the intercompany and ledger currency.

D. The intercompany period is closed.

E. Both the intercompany and general ledger periods are open.

Your customer is using budgetary control and encumbrance. You have an open purchase order for $500 USD, which you decide to match to an invoice for $300 USD.

What will be the fund status of the purchase order and invoice?

A. The purchase order is Partially Liquidated and the invoice is Partially Reserved.

B. The purchase order is Partially Liquidated and the invoice will be reserved.

C. Both are reserved.

D. The purchase order is liquidated and the invoice is Partially Reserved. E. Both are Partially Reserved.

E. The purchase order is Open and the invoice is validated.

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

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.

Which two methods can your General Ledger accountants use to more easily view large amounts of contained in the tables in their work areas?

A. Detach the table to resize it to the maximum size of the monitor

B. Export the table to Excel.

C. Run a Business Intelligence Publisher report with Excel as the output format.

D. Use the Freeze feature on the tables to scroll through large amounts of data.

Your customer wants to prevent their department managers from viewing the results of other departments where they have no management authority.

What should be implemented for this type of security?

A. Data Access Sets

B. Cross-Validation Rules

C. Segment Value Security

D. Role-Based Access

Which two delivered roles can access the full functionality of Functional Setup Manager,

A. Application Implementation Manager

B. Functional Setup Manager Superuser

C. Application Implementation Consultant

D. Any functional user

E. IT Security Manager