Oracle 1Z0-1004 Online Practice Questions and Exam Preparation

Oracle 1Z0-1004 Online Questions & Answers

• Question 1:

  How do Cross Validation Rules (CVRs) handle existing violations in the Code Combinations Identification (CCID) table?

  A. Nothing has changed. If you have an invalid account combination existing in the table, you must deactivate it to prevent further usage
  B. CVRs are assigned to the end user role; therefore controlling what account code combination individuals can leverage in the General Ledger and the subledgers
  C. CVRs only test new account combinations being inserted into the table. They ignore any invalid account combinations already existing in the table
  D. If CVR determines that an invalid combination exists in the CCID table, it will automatically disable that account code combination.
  C. CVRs only test new account combinations being inserted into the table. They ignore any invalid account combinations already existing in the table

• Question 2:

  The Delete Translated Balances process provides the ability to completely reset translations in the event that significant changes are made to the accounting configuration. Once the deletion process completes, what additional process must you run?

  A. Submit the Update General Ledger Balances Cube process to ensure that the balances cube maintains translated balances that are consistent with future translations.
  B. Submit the Create General Ledger Balances Cube process to ensure that the balances cube maintains translated balances that are consistent with future translations.
  C. Submit the Create Currency Dimension Members process to ensure that the balances cube maintains translated balances that are consistent with future translations.
  D. Submit the Create Scenario Dimension Members process to ensure that the balances cube maintains translated balances that are consistent with future translations.
  B. Submit the Create General Ledger Balances Cube process to ensure that the balances cube maintains translated balances that are consistent with future translations.

• Question 3:

  You are implementing Segment Value Security rules. Which two statements are true? (Choose two.)

  A. When you enable Segment Value Security on a segment, users will not be able to access any values until you grant access to users and products
  B. You can use hierarchies to define rules
  C. When you enable or disable Segment Value Security, you do not need to redeploy your chart of accounts
  D. The Segment Value Security rules do not take effect until you assign the rules to users and products
  A. When you enable Segment Value Security on a segment, users will not be able to access any values until you grant access to users and products
  B. You can use hierarchies to define rules

• Question 4:

  When working with Essbase, versions of the tree hierarchy as defined in the General Ledger Cloud are not available in the Essbase balances cube. What should you do to correct this situation?

  A. Make sure to flatten the rows of the tree version
  B. Make sure the tree is active
  C. Make sure the tree version was published successfully
  D. Redeploy the chart of accounts
  C. Make sure the tree version was published successfully

• Question 5:

  You are creating financial statements and want to have charts, such as a bar graph, automatically inserted to improve the understanding financial results. How would you achieve this?

  A. Use Smart View, which is an Excel Add-on
  B. Use Account Inspector that automatically creates graphs on financial balances
  C. When viewing the report, download to Excel and use Excel's Charting features to create your bar graph
  D. When designing your financial statement using Financial Report (FR), embed a chart into your report
  D. When designing your financial statement using Financial Report (FR), embed a chart into your report

• Question 6:

  You are using budgetary control. You have an open purchase order for $500 USD, and an invoice for $300 is matched to the purchase order. What will be the funds status of the purchase order and the invoice?

  A. Both are Partially Reserved
  B. The purchase order is Liquidated and the invoice is Partially Reserved
  C. The purchase order is Partially Liquidated and the invoice is Partially Reserved
  D. The purchase order is Partially Liquidated and the invoice will be Reserved
  E. Both are reserved
  F. The purchase order is Open and the invoice is Validated
  C. The purchase order is Partially Liquidated and the invoice is Partially Reserved

• Question 7:

  Your customer has many eliminating entries to eliminate intercompany balances. The General Ledger does not include a purpose-built Consolidation feature. How would you automate the process of creating eliminating entries, assuming your customer is not using Oracle Hyperion Financial Close Management?

  A. Use the General Ledger's Calculation Manager to define an allocation definition to eliminate entries that you can generate every period
  B. Use the spreadsheet template that is accessed from the "Create Journal in Spreadsheet" task and import the spreadsheet with the eliminating entries every period
  C. There is no way to automate this process if the customer is not using Oracle Hyperion Financial Close Management
  D. Create a manual journal that includes the eliminating entries, and then create a copy of the journal batch every period
  A. Use the General Ledger's Calculation Manager to define an allocation definition to eliminate entries that you can generate every period

• Question 8:

  Before implementing Financials Cloud, your customer used to manually reconcile their intercompany payables and receivables accounts. What is a more automated approach to do this?

  A. Use Oracle Hyperion Close Manager to automatically reconcile intercompany account balances
  B. In Financials Cloud, you must manually reconcile your intercompany account balances
  C. Run the BI Publisher reports called Intercompany Transaction Summary and Account Details to automatically reconcile intercompany balances
  D. Run the Intercompany Reconciliation report, which shows pairs of intercompany receivables and payables accounts that are out of balance
  E. Create a query using Oracle Transactional Business Intelligence (OTBI) that will match the intercompany payables and receivables balances
  D. Run the Intercompany Reconciliation report, which shows pairs of intercompany receivables and payables accounts that are out of balance

• Question 9:

  The expense account of airfare was erroneously assigned to the account type "Liability". Which method should you choose to fix the problem?

  A. Deactivate the value
  B. Run the "Segment Value Inheritance" program
  C. Run the "Correct Misclassified Account" program
  D. Run the "Update Balance Cube Chart of the Accounting Dimension" program
  C. Run the "Correct Misclassified Account" program

• Question 10:

  During implementation, a consultant accidentally designated the cost center segment as the natural account. Values have already been assigned and journals have been posted. Select the process that allows you to change the qualifier back to cost center qualifier.

  A. Create a new chart of accounts.
  B. Delete the segment and create a new segment with the correct qualifier.
  C. Change and save the segment qualifier.
  D. Delete the chart of accounts and create a new one.
  D. Delete the chart of accounts and create a new one.