Free Oracle 1z1-960 Exam Dumps Questions & Answers

Which reporting tool is best suited for submitting high-volume transactional reports, such as Invoice Registers or Trial Balance reports, that can be configured to extract the data in Rich Text Format or XML?

• A.Financial Reporting Center
• B.Oracle Data Visualization Cloud Service
• C.Business Intelligence Publisher (BI Publisher).
• D.Smart View
• E.Oracle Transactional Business Intelligence (OTBI)

You want to define a tree or hierarchy for use in reports and allocations.
What three aspects should you remember when creating the tree?

• A.You need to flatten the rows to be able to use drilldown in Smart View and you must publish tree to view the hierarchy in Essbase cubes.
• B.The tree should have at least two tree versions to reduce report and allocation maintenance.
• C.It is fine to have the same child value roll up to two or more different parent values.
• D.You only need to flatten the columns if you plan to use the hierarchy in Oracle Transactional Business Intelligence (OTBI).
• E.You must flatten the columns and publish the tree to view the hierarchy in Essbase cubes.

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.Submit the requisition for approval
• B.Requisition rejected by the buyer
• C.Checkout and Save the requisition
• D.Funds check
• E.Create change request on the requisition after submitting requisition for approval
• F.Requisition approved

You just submitted the Accounting Configuration. Which two statements are correct? (Choose two.)

• A.You must define a Data Access Set to obtain full read/write access to the ledgers in the Accounting Configuration.
• B.A Data Access Set with full read/write access to the ledger is automatically created.
• C.Open the ledger's period to begin entering transactions.
• D.Verify the data roles created and assign them to the General Ledger users.

You are required to change today's daily rates for converting GBP to USD. What are three ways in which you can update existing daily rates?

• A.Import daily rates through the Daily Rates open interface table.
• B.Update rates manually using the Currency Rates Manager, which can be accessed from the Functional Setup Manager or the General Ledger's Period Close work area.
• C.Update rates manually using the Currency Rates Manager, which can be accessed only from the Functional Setup Manager.
• D.Edit existing transactions and update the rates manually.
• E.Use the spreadsheet loader from the Currency Rates Manager.