Oracle Oracle Certifications 1Z0-508 Questions & Answers

• Question 121:

  Select the key performance indicator (KPI) that provides a trend of the cost of an item as part of Gross Margin Analysis A. Item Cost KPI

  B. Value Trends KPI

  C. Gross Margins KPI

  D. Inventory Value KPI

  Correct Answer: A

  Note:

  * Overhead Costs Expensed or Capitalized

  On inbound transactions and inventory transfer transactions, overhead expenses can be absorbed and capitalized into inventory value, or the absorption can be redirected to an expense account: a credit to an absorption account and a debit to either an inventory or expense account. On outbound transactions, overhead absorption is redirected to an expense account, and will be included in the gross margin calculation.

  For example, consider a receipt of inventory items that cost $10 each to purchase, and you would like to absorb overhead cost of $2 each on the inbound transaction. When the item is sold, you would like to absorb additional overhead of $3 each on the outbound transaction. The total cost of goods sold is $15 each.

  *Fusion Costing analytics include support for Gross Margin Analysis, Item Cost Trend and Item Value trend, embedded in the Fusion Cost Accountant's dashboard

  Reference: Oracle Fusion Applications Cost Accounting and Receipt Accounting Implementation Guide 11g, Overhead Costs Expensed or Capitalized

• Question 122:

  Where do actions that are configured for execution in the Action Framework appear in Oracle Business intelligence Enterprise Edition?

  A. In the Oracle BI EE Global Header section

  B. In the Analysis, Dashboards, Agents, KPIs, and scorecard objectives sections (standard and mobile)

  C. In theMY Favorite region

  D. through OBIEE Mobile

  Correct Answer: B

  Reference: OBIEE 11gR1 : Action Framework and Conditions

• Question 123:

  The Receivables and Payables accounts that are automatically generated by intercompany transactions use rules and attributes in what order?

  A. Primary Balancing Segment Rules; Ledger Entity Level Rules; Ledger Level Rules;Chart of Account Rules

  B. Ledger entity Level Rules; ledger Level Rules; Chart of Account Rules; Primary Balancing Segment Rules

  C. Chart of Account Rules; Primary Balancing Segment Rules; Ledger Entity Level Rules; Ledger Level Rules

  D. Ledger Level Rules;Primary Balancing Segment Rules;Ledger Entity Level Rules; Chart of Accounts Rules

  E. Chart of Account Rules; Ledger Entity Level Rules, Primary Balancing Segment Rules; Ledger Level Rules

  Correct Answer: A

  Defining Intercompany Balancing Rules You can define intercompany balancing rules at the following rule levels: 1.Primary balancing segment

  2.Legal entity 3.Ledger 4.Chart of accounts

  The rules are evaluated in the order shown above.

  Reference: Oracle Fusion Accounting Hub Implementation Guide, Intercompany Balancing Rules: Explained

• Question 124:

  What is the primary source of data that is used for the Financial Reporting Center?

  A. data from the balances cubes and dimensions contained in the chart of account segments

  B. transaction tables

  C. defined dimensions for journals

  D. the Code Combinations table

  Correct Answer: A

  Administrators need to create database connections from Workspace so users can access the cubes from either Workspace or Financial Reporting Studio. Reference: Oracle Fusion Applications Financials Implementation Guide 11g, Setting up Your Financial Reporting Center: Critical Choices

• Question 125:

  Transactions may involve multiple currencies that require a common currency to make the reports meaningful. What are the amounts Oracle Business Analytics Warehouse uses to store currency?

  A. Global Currency (two common currencies), Document Currency,Local Currency

  B. Currency Code, Currency Name

  C. Currency Symbol, Currency Name

  D. Report Currency

  Correct Answer: A

  Currency lookups are required because your business may have transactions involving multiple currencies. To create a meaningful report, you have to use a common currency.

  The Oracle Business Analytics Warehouse provides a means for converting a variety of currencies, as well as prepackaging the following three currency types for each amount stored in the Oracle Business Analytics Warehouse:

  *Document currency. The currency of the transaction. For example, if you purchase a chair from a supplier in Mexico, the document currency is probably the Mexican peso.

  *Local currency. The currency in which the financial books, including the transaction, are closed.

  For example, if your business organization is located in France and orders a part from a supplier in Britain, it may pay in British pounds, but it closes its books in French francs. In this case the local currency for the transaction is French francs

  and the document currency for the transaction is

  British pounds. The local currency is useful when each business unit of the enterprise creates its own internal reports. For example, your Japanese site may produce internal reports using Japanese yen, while your United States site may

  produce internal reports using United States dollars.

  *Global currencies. Out of the box, Oracle BI Applications provides three global currencies, which are the standard currencies used by your entire enterprise. For example, if a multinational enterprise has its headquarters in the United States,

  its group currency is probably U.S. dollars.

  The global currency is useful when creating enterprise-wide reports. For example, a user might want to view enterprise-wide data in other currencies

  Reference: Oracle Business Intelligence Applications Installation and Configuration Guide >Configuring Common Components of the Oracle Business Analytics Warehouse > About Document, Local, and Global Currencies

• Question 126:

  In Oracle Fusion Applications, a calendar can only have .

  A. Oneperiod frequency and period type

  B. Multiple period frequencies

  C. Multiple period types

  D. Multiple period frequencies and period types

  Correct Answer: A

  In Oracle Fusion applications a calendar can only have one period frequency and period type. Therefore, if you have an existing calendar with more than one period type associated with it, during the upgrade from Oracle E-Business Suite,

  separate calendars are created based

  on each calendar name and period type combination.

  Reference: Fusion Applications Help, Defining Accounting Calendars: Critical Choice

• Question 127:

  Yon have entered a journal and your supervisor is asking for the current account balance and what the future account balance will be after the journal is approved and posted. How will you get this information?

  A. Run Trial Balance.

  B. Run the Journals- (132 Char) Report.

  C. View the Projected Balances Region on the Create Journal page

  D. View the Account Inquiry window

  Correct Answer: C

  Use the projected balances feature to view the impact on account balances for selected subledger journal entry lines.

  The projected balances flow has the following business benefits:

  Creation and validation of unposted manual journal entries by providing knowledge users with immediate and relevant information about the account balances for the selected journal lines.

  Validation and reconciliation of posted journal entries by providing immediate and relevant information about the account balances for the selected journal lines.

  Reference: Fusion Applications Help, Viewing Projected Balances: Points to Consider