Oracle Oracle Certifications 1Z0-508 Questions & Answers

• Question 101:

  Choose four applications for which SmartView provides a common Microsoft Office interface.

  A. Oracle Hyperion Financial Management, Fusion Edition

  B. Oracle Hyperion Planning, Fusion Edition

  C. Oracle E-Business Suite Release 11g

  D. Oracle Enterprise Performance Management Workspace, Fusion Edition

  E. Oracle Business Intelligence Enterprise Edition

  F. Oracle Essbase

  Correct Answer: ABDE

  A, B: SmartView provides anOffice-based interface for leveraging Hyperion Planning, Hyperion Financial Management, and Hyperion Workforce Planning data entry forms D, E:Oracle Hyperion Smart View for Office, Fusion Edition (Smart View) provides a common MicrosoftOffice interface for the OracleEnterprise Performance Management (EPM) suite of products along with Oracle Business Intelligence (BI) data sources

  Note: Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.

• Question 102:

  Which three actions can you perform on subledger journal entities?

  A. Finish

  B. Duplicate

  C. Reverse

  D. Close

  E. Complete

  F. Incomplete

  Correct Answer: CDE

  C: If a payment is voided after the payment has been confirmed, you must submit the Disbursement in Transit Voided Checks process to create accounting for the voided payments. Oracle Subledger Accounting reverses all journal entries for payments that have been voided.

  E: When a subledger journal entry is completed, the reference date must be in an open or future open accounting period. Note:A subledger journal entry can have a status of Draft, Final, Incomplete, Invalid or Invalid Related Entry.

• Question 103:

  Which components are used to perform ETL and prebuilt ETL logic while setting up Oracle Business Intelligence Enterprise Edition?

  A. Functional Setup Manager and Configuration Manager

  B. Information PowerCenter Servicer, and Informatics Repository

  C. Metadata Repository and BI Presentation Services Catalog

  D. Oracle Business Analytics Warehouse and Oracle BI Presentation Services

  E. Oracle BI Server and OLIP data source

  Correct Answer: D

  The Extract Transform and Load (ETL) process must be run by a user with appropriate data security privileges granted on the Fusion Application tables from which data is extracted into Oracle Business Analytics Warehouse.

  For this purpose, the Group named FUSION_APPS_OBIA_BIEE_APPID is provisioned during install with the appropriate ETL security privileges (by default, this Group is mapped to the Duty Role named OBIA_EXTRACT_TRANSFORM_LOAD_DUTY).

• Question 104:

  A company has three divisions: a U.S. division that covers the U.S. locations, a European division that covers U.K. and France, and a Middle East division that covers Saudi Arabia and U.A.E. All the divisions have their own employees. Choose how many Ledgers and Legal Entities the company Needs.

  A. One ledger and one Legal Entity

  B. Two ledger and two Legal Entities

  C. Three Ledger and three Legal Entities

  D. One Ledger and three Legal Entities

  Correct Answer: C

• Question 105:

  In Oracle Fusion, the intercompany transactions are used to generate the accounts needed to balance .

  A. By legal entity only

  B. By primary balancing segment values only

  C. By both legal and balancing segments values

  D. By account values

  Correct Answer: B

  Intercompany journals involve balancing segment values that map to different legal entities. These journals are balanced for each legal entity by using their intercompany accounts.

  Intracompany balancing rules are used to create balancing lines on journals between balancing segment values either within the same legal entity, or where there is no legal entity context.

  Reference: Oracle Financials Implementation Guide, Intercompany Balancing

• Question 106:

  How can data from a Chart of Accounts instance be viewed in Oracle Business Intelligence?

  A. Data is automatically available in Oracle Business intelligence through the transaction tables and cubes.

  B. Select the Business Intelligence check box for the Chart of AccountsInstance.

  C. Use the Migrate Oracle Fusion Financials function within the Setup and Maintenance work area.

  D. Enable the offerings in the Manage BI Applications dialog box.

  E. Select the Enable for Implementation check box.

  Correct Answer: A

  Note:At the time users create their chart of accounts, the balances cube is created automatically.

• Question 107:

  Identify the option that needs to be selected at the header level when assigning a header level subledger Journal Rule Set.

  A. Accounting Date

  B. Description

  C. Supporting Reference

  D. Ledger

  E. Currency

  Correct Answer: A

  Assignment at Header Level

  Header assignments define subledger journal header information and line assignments define journal line accounting treatment.

  A header assignment includes the following:

  Accounting date (required)

  Accrual reversal accounting date (optional)

  Description rule (optional)

  Supporting references (optional)

  Assignment at Line Level

  Reference: Oracle Fusion Applications Financials Implementation Guide, Define Subledger Accounting Rules

• Question 108:

  To set up the intercompany transaction using the Chart of Account rule, you will have to .

  A. specify the Chart of account intercompany receivables accounts, intercompany payables account the source and the category

  B. specify the chart of account intercompany receivables only

  C. specify the chart of accounts intercompany payables only

  D. specify the chart of account intercompany receivables and intercompany payables accounts

  Correct Answer: D

  Defining intercompany Receivables and Payables accounts is required before using the intercompany feature.

  Note:

  *

  You must define Intracompany balancing rules if you want to balance journals automatically. You may define as many or as few balancing rules as you choose, and each balancing rule may have one or many accounting rules.

  *

  Intracompany balancing allows you to define rules according to the business needs of your company. When there are many balancing rules defined, the Balancing API uses an evaluation order to pick the appropriate rule. Once the balancing rule is selected, there may also be several accounting rules that must be evaluated on the balancing rule. The Balancing API uses the same order for evaluating accounting rules, and understanding this evaluation order will help you define your balancing rules and accounting rules.

  Reference: Oracle Financials Implementation Guide, Intercompany and Intracompany Balancing

• Question 109:

  To set up the intercompany transaction using the Chart of Account rule, you will have to .

  A. specify the chart of account Intercompany receivables accounts, Intercompany payables accounts, the source and the category

  B. specify the account of account intercompany receivables only

  C. specify the chart of accounts intercompany payables only

  D. specify the chart of account intercompany receivables and intercompany payables accounts

  Correct Answer: D

  Defining intercompany Receivables and Payables accounts is required before using the intercompany feature.

  Note:

  *

  You must define Intracompany balancing rules if you want to balance journals automatically. You may define as many or as few balancing rules as you choose, and each balancing rule may have one or many accounting rules.

  *

  Intracompany balancing allows you to define rules according to the business needs of your company. When there are many balancing rules defined, the Balancing API uses an evaluation order to pick the appropriate rule. Once the balancing rule is selected, there may also be several accounting rules that must be evaluated on the balancing rule. The Balancing API uses the sameorder for evaluating accounting rules, and understanding this evaluation order will help you define your balancing rules and accounting rules.

  Reference: Oracle Financials Implementation Guide, Intercompany and Intracompany Balancing

• Question 110:

  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

  Correct Answer: A

  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