Oracle Oracle Certifications 1Z0-508 Questions & Answers

• Question 11:

  Identify two correct behaviors of conditional suppression of rows and columns.

  A. If an entire row or column meets the criteria specified for conditional suppression, the entire row or column is hidden.

  B. When the Hide Always chock box is selected for a row or column, you can ignore the values and calculations in hidden rows and columns.

  C. If only some of the cells in a row or column meet the criteria specified for conditional suppression, the row or column is hidden.

  D. The calculation does NOT consider suppressed rows.

  Correct Answer: AB

  A: If an entire row or column meets the criteria specified for conditional suppression, the entire row or column is hidden.

  B: When evaluating suppression, you can include or ignore the values and calculations in hidden rows and columns. This option is enabled only when the Hide Always check box is selected for the row or column. Reference: Behavior of Conditional Suppression

• Question 12:

  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.

  Correct Answer: C

  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 13:

  You are required to enter the daily rates for currency conversion from British pound (GBP) to United States dollars (USD) each day. Which Excel add-in application do you use to load the daily rates?

  A. SmartVIew

  B. Web ADI

  C. Application Development Framework Integration

  D. Financial Reporting studio

  Correct Answer: C

  You are required to enter the daily rates for currency conversion from Great Britain pounds sterling (GBP) to United States dollars (USD) each day for your company InFusion America Inc.

  Oracle Application Development Framework (ADF) Desktop Integration is an Excel add-in that must be loaded onto each client. Because ADF Desktop Integration is an add-in to Microsoft Office products, you can use this feature only if they have Microsoft Excel 2007 or above, Internet Explorer 7 or above, and Microsoft Windows 7, XP Professional SP2, or Vista. Users must download the installation files from Navigator - Tools - Download Desktop Integrator Installer.

  Reference: Oracle Fusion Applications Financials Implementation Guide, Entering Daily Rates Manually: Worked Example

• Question 14:

  When reconciling transactions, accounted amounts in a reconciliation report may be different due to differences in the currency conversion rates used. To mitigate the differences in the account balances you should .

  A. Run the report using an additional common currency conversion rate

  B. Run additional reports using a number of varied currency conversion rates

  C. Add a ledger-balancing line in the intercompany Receivables account and rerun the report

  D. Add a ledger-balancing line in the intercompany Payables account and rerun the report

  Correct Answer: D

  Note:

  *Transaction Reconciliation Report

  Use this report to identify the General Ledger journal entry lines imported from particular transactions in Payables. Transactions that have not been transferred to General Ledger are marked with an indicator.

  This report is sorted by supplier, supplier site, and transaction number.

  * Transaction Reconciliation Report

  Use this report to identify the General Ledger journal entry lines imported from specific transactions in Receivables. Transactions that have not been transferred to General Ledger are marked with an indicator.

  This report totals the debits and credits for each transaction, customer, and customer site.

  Use either the Submit Request or the Print Accounting Reports window to submit this report.

• Question 15:

  You are required to enter the daily rates for currency conversion from British pound (GBP) to United States dollars (USD) each day. Which Excel add-in application do you use to load the daily rates?

  A. SmartView

  B. Web ADI

  C. Application Development Framework Integration

  D. Financial Reporting Studio

  Correct Answer: C

  You are required to enter the daily rates for currency conversion from Great Britain pounds sterling (GBP) to United States dollars (USD) each day for your company InFusion America Inc.

  Oracle Application Development Framework (ADF) Desktop Integration is an Excel add-in that must be loaded onto each client. Because ADF Desktop Integration is an add-in to Microsoft Office products, you can use this feature only if they have Microsoft Excel 2007 or above, Internet Explorer 7 or above, and Microsoft Windows 7, XP Professional SP2, or Vista. Users must download the installation files from Navigator - Tools - Download Desktop Integrator Installer.

  Reference: Oracle Fusion Applications Financials Implementation Guide, Entering Daily Rates Manually: Worked Example

• Question 16:

  Which three rule types are used to build an account rule?

  A. Account Combination

  B. Segment

  C. Value Set

  D. Mapping Set

  E. System Transaction Identifiers

  Correct Answer: BCD

  B: Account Rules by Segment

  Define segment rules to derive a specific segment of the general ledger account.

  C: Account Rules by Value Sets

  In the absence of a chart of accounts, you may define account rules based upon value sets. This enables you to share the same rule between more than one chart of accounts if the segments in these charts of accounts share the same value

  set.

  D: Account Rules and Mapping Sets Mapping sets can be used to associate a specific output value for an account or segment. You can use mapping sets in account rules to build the account. Reference: Fusion Applications Help, Account Rules: Explained

• Question 17:

  Oracle Business Intelligence Enterprise Edition available through iPhone and iPad devices. Which three BI EE object content are visible through a mobile device?

  A. Analysis, including analytic actions

  B. Tables, excluding drilling

  C. Action

  D. Scorecard, including analytic actions

  E. Briefing book, limited to alerts visible in the Alerts list

  Correct Answer: ACD

  Oracle Business Intelligence Mobile, part of Oracle Business Intelligence Foundation Suite, provides the ability to deliver analyses, dashboards, alerts, and other BI content directly to mobile devices, enabling users to view and then take action on BI insights wherever they are.

  Intelligence Mobile gives you the full spectrum of BI functionality on hoc query, OLAP analysis, dashboards and scorecards. You even have the ability to turn insight into action directly from your mobile reports and dashboards. Reference: Oracle Business Intelligence Mobile, Data Sheet

• Question 18:

  To update an intercompany calendar, the calendar status must be in a(n) .

  A. Open Period

  B. Pending Close Period

  C. Newer Open or Closed Period

  D. Final Closed Period

  Correct Answer: C

  In order to update the intercompany calendar to use a different general ledger accounting calendar, the intercompany period status for all intercompany transaction types must either be Never Opened or Closed. Reference: Oracle Fusion Applications Financials Implementation Guide, Intercompany Calendar and Period Type

• Question 19:

  A company has different methods of inventory valuation. What would be the best way of capturing this in the Fusion Accounting Hub?

  A. Secondary Valuation method

  B. Account Derivation Rules

  C. Journal Line Types

  D. Adjustments in the General Ledger

  Correct Answer: C

  Note: The Applied to Amount accounting attribute is used to calculate the accounted amount and gain or loss in cross-currency applications when business flows are implemented. This attribute value is used to calculate the accounted amount when a source is mapped to the Applied to Amount attribute on a journal line type and the entered currency is different than the original currency entered.

• Question 20:

  Where do you perform real-time, ad hoc queries from a data warehouse?

  A. General Accounting and Journals dashboards

  B. Oracle Transaction Business Intelligence

  C. Oracle Business Intelligence Analytics

  D. Account Monitory and Account Inspector

  Correct Answer: D

  Account Monitor is fully integrated with the online multidimensional analysis tool called the Account Inspector. With the Account Inspector, the user can:

  *

  Perform ad hoc multidimensional pivot table analysis

  *

  Review charts based on the Account Monitor data

  *

  Use drill down from the Account Monitor from any parent to the next parent or child level

  *

  Perform drill down from any child level to detail balances, journal lines, and subledger transactions Reference: Fusion Applications Help, Financial Reporting Center: Explained