Oracle 1Z0-508 Online Practice Questions and Exam Preparation

Oracle 1Z0-508 Online Questions & Answers

• Question 51:

  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
  C. Three Ledger and three Legal Entities

• Question 52:

  To update the intercompany calendar to use a different general ledger accounting calendar, the intercompany period status for all intercompany transaction types must be .

  A. Open
  B. Closed
  C. Either Open or Closed
  D. Never Opened or Closed
  D. Never Opened or Closed

  ---

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

  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
  D. Oracle Business Analytics Warehouse and Oracle BI Presentation Services

  ---

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

  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
  D. Account Monitory and Account Inspector

  ---

  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

• Question 55:

  Oracle Business Intelligence Enterprise Edition is available through the iPhone and iPad devices. Which BI object content is NOT visible through a mobile device?

  A. Analysis, including analytic actions
  B. Dashboard Page, including analytic actions
  C. Action
  D. Scorecard, including analytic actions
  E. Briefing Book, limited to alert visible in the Alerts list
  E. Briefing Book, limited to alert visible in the Alerts list

  ---

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

  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
  D. specify the chart of account intercompany receivables and intercompany payables accounts

  ---

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

  You have added a cost center to the chart of accounts from Fusion General Ledger. Identify the process that you need to run to sync the cube in Essbase.

  A. Run the import Chart of Account Segment Values.
  B. Automatically create or modify the cube in Essbase.
  C. Run the chart of Accounts ?Account Hierarchy.
  D. Run the Program ?Optimizer.
  C. Run the chart of Accounts ?Account Hierarchy.

  ---

  Synchronization of chart of accounts values between the Oracle General Ledgers and Fusion Accounting Hub

  Oracle Hyperion Data Relationship Management (DRM) propagates any updates to chart of accounts values from the Oracle E-Business Suite General Ledger to Fusion Accounting Hub.

  DRM is a change management platform built specifically to support complex financial reference data. With DRM's robust security and rich hierarchy management features, you can enforce highlevel standards and controls over chart of

  accounts synchronization between Oracle General Ledgers and Fusion Accounting Hub.

  For the PeopleSoft General Ledger, a one-time chart of accounts load will synchronize the charts of accounts from the PeopleSoft General Ledger and Fusion General Ledger.

  Note: Integration between Oracle General Ledgers (E-Business Suite and PeopleSoft) and the Oracle Fusion

  Accounting Hub has three main components:

  1.

  Synchronization of charts of accounts, calendars, and ledgers.

  2.

  Transfer of data and financial results from the Oracle General Ledgers to Fusion Accounting Hub's Fusion General Ledger.

  3.

  Drilldown from Fusion Accounting Hub to the Oracle General Ledgers

  Reference: Oracle Fusion Accounting Hub: Integration with Oracle Financial Solutions.

• Question 58:

  A company has the second and third balancing segment enabled for its chart of accounts, and the journal is balanced by the primary balancing segment but is out of balance by the second and third balancing segment. This is an example of .

  A. Chart Account Balancing Rule
  B. Balancing Segment Rule
  C. Chart of Account Rule
  D. Segment qualifier
  D. Segment qualifier

  ---

  Example:

  Ledger balancing options are defined for the ledger to balance the second balancing segment and/or the third balancing segment, when a transaction is unbalanced by one of these segments.

  Simple ledger balancing option with no clearing company options

  In this scenario the enterprise has the second balancing segment and the third balancing segment enabled for its chart of accounts.

  Setup

  InFusion USA Chart of Accounts

  

  Note: 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. For example, you can define a Primary Balancing Segment rule and a Legal Entity level rule. If both rules are used to balance a particular journal, the Primary Balancing Segment rule is used, as it has a higher precedence.

  You have flexibility in defining your intercompany balancing rules. You can have a simple setup in which you define one rule for your chart of accounts. This rule is used for all intercompany balancing for all ledgers that use this chart of accounts. Alternatively, you can have a more granular set of rules. For example, you can define a different rule for each legal entity and onechart of accounts rule to cover any gaps in your rule definitions. You can gain even more granularity by defining rules for specific journal and/or category combinations or intercompany transaction types.

  Reference:Oracle Fusion Accounting Hub Implementation Guide,Manage Ledger Balancing Options

• Question 59:

  Choose the two Oracle Hyperion Reporting and Analysis products and artifacts, that can be imported into financial Reporting.

  A. Dynamic Report (* .des)
  B. Impact Manage Transformation Scripts (*. Js)
  C. Snapshot Reports (*.rpt)
  D. Books. (*.kbk)
  C. Snapshot Reports (*.rpt)
  D. Books. (*.kbk)

  ---

  Oracle Hyperion Reporting and Analysis products and artifacts that you can import into Financial Reporting:

  Dynamic report (*.des)

  Snapshot reports (*.rpt)

  Books (*.kbk)

  Snapshot Books (*.kbt)

  Batch files (*.bch)

  Reference: Oracle Hyperion Financial Reporting, User's Guide, Importing

• Question 60:

  What is the best view or tool to use it you need to quickly perform an ad hoc ledger query that drill down to in a web view?

  A. Account Monitoring
  B. Oracle Hyperion Smart View
  C. Oracle Hyperion Financial Reporting Studio
  D. Account Inspector
  D. Account Inspector

  ---

  Account Inspector allows financial analysts and accountants to quickly perform ad hoc ledger queries, multi-dimensional analysis, pivoting, and drill down--all within a web page. Because it works off the same multi-dimensional balances that stores pre-aggregated balances at all levels, slicing and dicing data is extremely fast. Any changes you make to your query criteria are instantaneously refreshed to ensure you are working with the most up-to-date information to make the most informed decisions.