Oracle 1Z0-508 Online Practice Questions and Exam Preparation

Oracle 1Z0-508 Online Questions & Answers

• Question 61:

  In the Essbase database source, how do you identify duplicate members?

  A. display qualified names instead of the member names
  B. use the member perspective
  C. use an alias name for a database member
  D. use member Information
  A. display qualified names instead of the member names

  ---

  After enabling an Essbase outline to accept duplicate member names, there are two methods you can use for loading data using a data file and data load rule: loading data using qualified member names and loading data using ancestor reference.

  Reference: Loading Data to Essbase 11.1.2 Outlines Containing Duplicate Member Names

• Question 62:

  If you change the status of a tree structure, the status of the trees and tree versions associated with structure also change. Which three statuses apply to the tree structure?

  A. Pending
  B. Draft
  C. Active
  D. Inactive
  E. Future
  B. Draft
  C. Active
  D. Inactive

  ---

  If you change the status of a tree structure, the status of the trees and tree versions associated with that tree structure also changes.

  The following table lists the different statuses of a tree structure.

  Status, Meaning

  *

  Draft

  Yet to be published or is in a modified state.

  *

  Active

  In use and based on which one or more trees or tree versions are created.

  *

  Inactive

  Not in use.

  Reference: Oracle?Fusion Applications Financials Implementation Guide, Setting Status

• Question 63:

  How do you identify errors in the accounting calendar?

  A. Run the Create Accounting Process.
  B. A calendar with errors can NOT be saved.
  C. Run the Transaction Calendar Concurrent Process.
  D. An error messageisdisplayed when you enter a new calendar or change data on an existing calendar
  B. A calendar with errors can NOT be saved.

• Question 64:

  Event classes are transaction types used to group .

  A. Event Types
  B. Process Categories
  C. Journal Rule Sets
  D. Event Models
  E. Event Entities
  A. Event Types

  ---

  Accounting event classes group accounting event types into distinct, user-oriented groups. They typically represent the actions possible on a particular transaction or transaction type. Use event classes to group similar event types for sharing accounting definitions.

  Reference: Oracle Financial Services Accounting Hub Implementation Guide, Event Classes

• Question 65:

  A database connection can be changed when moving from a development environment server to a production environment server. Identify the reason for the error message "1012: Report contains an Invalid grid. The following dimensions could not be found: Measures."

  A. Dimensions existed in the old database connection, but NOT in the new database connection
  B. Dimensions in the changed database connections do NOT match the previous dimensions
  C. Dimensions do NOT match a specific report in the book
  D. Opening or running the reports or books for an INVALID database connection
  A. Dimensions existed in the old database connection, but NOT in the new database connection

  ---

  When the dimensions in the changed database connections do not match the previous dimensions, an error message similar to the following is displayed:

  1012:Report contains an invalid grid. The following dimensions could not be found: Measures The following actions occur when you open and save a report that has mismatched dimensions:

  *

  Dimensions that existed in the old database connection but not in the new database connection are removed. The dimensions and its members that existed in the rows and or columns are removed from the grid. If, as a result of the removal, no dimension exists in the row or column, you need to add a valid dimension to the cleared row or column in order for the report to run.

  *

  Dimensions that exist in the new database connection but not in the old one, are added to the POV.

  Reference: Changing Financial Reporting Database Connections

• Question 66:

  After submitting the journal for approval, you realize the department value in journal is incorrect. How do you correct the value?

  A. Delete the journal and create a new journal.
  B. Update the journal through a workflow.
  C. Click the Withdraw Approval button on the journal page and edit the journal.
  D. Reverse the journal and create a new journal.
  C. Click the Withdraw Approval button on the journal page and edit the journal.

  ---

  The Withdraw Approval button on the Journals page is used at anytime in the approval process to withdraw journals from the process. Clicking this button allows you to edit to the journal. After your changes are made, submit the entry for approval again. When a journal is withdrawn, the completion status is set to Incomplete.

  Reference: Oracle Fusion Applications Financials Implementation Guide, Approving Journals: Points to Consider

• Question 67:

  Which view do you use to set parameters and define the data that is displayed in the SmartView report.

  A. SmartSlice
  B. SmrtView
  C. Point of View
  D. SmartCube
  A. SmartSlice

  ---

  Smart Slices are stored centrally and are available to users from the Smart View Panel. An entire report is associated with an Excel workbook, a Word document, or a PowerPoint presentation. One report is associated with an Excel worksheet, a Word page, or a PowerPoint slide. For PowerPoint presentations, Oracle recommends one report type per slide. You can create reports from entire Smart Slices or from subsets of data in a Smart Slice. Reports can then be displayed on an Excel spreadsheet, Word document, or PowerPoint slide. You can display as many reports from as many data sources as space will permit on one sheet

  Reference: Oracle Hyperion Smart View for Office, User's Guide

• Question 68:

  Which keyboard shortcut is used to navigate to Focus Annotations Area Control?

  A. Ctrl + G
  B. Ctrl + F
  C. Ctrl + Y
  D. Ctrl + B
  E. Ctrl+ L
  D. Ctrl + B

  ---

  Ctrl+B: Focus Annotations Area control. (for Financial Reporting only.)

  Reference: Oracle Hyperion Enterprise Performance Management Workspace, Using Global Navigation Shortcuts

• Question 69:

  During implementation, the consultant designated the cost center segment qualifier as the natural account segment qualifier. Select the process that enables you to change the qualifier back.

  A. Change and save the segment qualifier.
  B. Createa new Chart of Accounts.
  C. Run the Inheritance program after the change.
  D. Run the Move/Merge program.
  A. Change and save the segment qualifier.

  ---

  Note:

  *

  The Cost centre qualifier is used in FA for reporting purposes.

  1) One of the four predefined qualifiers in the Accounting Flexfield is the Cost Center qualifier. This qualifier is used exclusively for reporting in Oracle Assets and in the Account Generator for Oracle Assets.

  2) The Cost Center qualifier is designated for reporting purposes. Typically, a customer will use it to associate asset assignment at a department level, or some other organization level (ie qualifier) within the Accounting Flexfield structure.

  *

  Natural Account: This qualifier when attached to a segment enables the five nature of accounts Asset, Liability, Expense,Revenue, Owner's Equity. It also assigns the option of Reconciliation account and Third Party Control.

  *

  Define the natural account segment. A natural account segment contains values representing account types, such as cash, accounts receivable, product revenue and salary expense. Enter Yes or No to indicate whether the segment you are defining is your natural account segment. You define only one natural account segment in your account.

  *

  Define the Cost Center segment. Cost centers indicate functional areas of your organization, such as Accounting, Facilities, Shipping, and so on. Enter Yes or No to indicate whether the segment you are defining is a Cost Center segment.

  *

  You can change the Account Type segment qualifier by unfreezing all Accounting Flexfield structures that reference the natural account segment. Changing the account type only affects new accounts created with the reclassified natural account segment; it does not change the account type of existing accounts.

• Question 70:

  Identify the two INVALID output options for batch bursting.

  A. Snapshot Reports
  B. Output to Printer
  C. HTML and MHTML
  D. Books
  E. PDF files
  B. Output to Printer
  C. HTML and MHTML

  ---

  Batch Bursting only supports output to Snapshot Reports, Books and PDF files. Output to a printer, HTML and MHTML are not supported for Batch Bursting.

  Reference: Specifying the Batch Destination and Bursted Output Labels