Oracle 1Z0-1054-20 Online Practice Questions and Exam Preparation

Oracle 1Z0-1054-20 Online Questions & Answers

• Question 1:

  In which two ways can your users personalize the Springboards and Work Areas to suit their individual working styles? (Choose two.)

  A. They can format certain tables by hiding and showing columns, moving columns, and resizing columns
  B. Users have very little control configuring their Springboards and Work Areas; they can only resize columns
  C. They can have the System Administrator configuring pages for them using Page Composer
  D. They can use "+" under the Apps section of the News Feed homepage
  A. They can format certain tables by hiding and showing columns, moving columns, and resizing columns
  C. They can have the System Administrator configuring pages for them using Page Composer

• Question 2:

  What are the three differences between Oracle Transactional Business Intelligence (OTBI) and Oracle Business Intelligence Applications (OBIA)? (Choose three.)

  A. Both OBIA and OTBI provide a set of predefined reports and dashboards and a library of metrics that help to measure business performance
  B. OTBI allows you to create user-defined reports from real-time transactional data against the database directly
  C. OBIA is based on the universal data warehouse design with different prebuilt adapters that can connect to various source applications
  D. Cloud customers can use both OTBI and OBIA
  E. OBIA works for multiple sources including E-Business Suite, PeopleSoft, JD Edwards, SAP, and Cloud Applications
  B. OTBI allows you to create user-defined reports from real-time transactional data against the database directly
  C. OBIA is based on the universal data warehouse design with different prebuilt adapters that can connect to various source applications
  E. OBIA works for multiple sources including E-Business Suite, PeopleSoft, JD Edwards, SAP, and Cloud Applications

  ---

  explanation:

  Reference: https://blogs.oracle.com/prajkumar/otbi-vs-obia-v2

• Question 3:

  You are creating values for the chart of account value set that you are planning to use for the account segment within your Chart of Accounts. You are not able to assign an Account Type. What is the reason for this?

  A. You have not set the Allow Budgeting attribute for the value set
  B. The Account Type qualifier has not been enabled when defining the value set
  C. You are creating values before assigning the value set to the structure
  D. You have not set the Allow Posting attribute for the value set
  D. You have not set the Allow Posting attribute for the value set

• Question 4:

  You entered a journal and the client is asking for the following information: The current account balance The future account balance if the journal is approved and posted

  How will you get this information?

  A. Run a Trial Balance before and after posting
  B. Use Oracle Transactional Business Intelligence (OTBI) to query General Ledger balances
  C. View the Projected Balances region in the Create Journals page
  D. Query the account balance online
  C. View the Projected Balances region in the Create Journals page

• Question 5:

  Your company has complex consolidation requirements with multiple general ledger instances. You are using Oracle Hyperion Financial Management to consolidate the disparate General Ledgers. You can typically map segments between your general ledger segment to a Hyperion Financial Management segment, such as Company to Entity, Department to Department, and Account to Account.

  What happens to segments in your source general ledger, such as Program, that cannot be mapped to Hyperion Financial Management?

  A. Data is summarized across segments that are not mapped to Hyperion Financial Management
  B. Errors occur for unmapped segments. You must map multiple segments from source general ledgers to the target segment in Hyperion Financial Management
  C. No data is transferred
  D. The unmapped segments default to future use segments in Hyperion Financial Management
  B. Errors occur for unmapped segments. You must map multiple segments from source general ledgers to the target segment in Hyperion Financial Management

• Question 6:

  You need to define a chart of accounts that includes an intercompany segment. Your customer plans to use segment value security rules for the Company segment.

  What is Oracle's recommended method to define this chart of accounts?

  A. Define the company segment only and qualify it as both the primary balancing segment and intercompany segment.
  B. Use two different value sets for the company and intercompany segment because segment value security rules are at the value set level.
  C. Share the same value set for the company and intercompany segments to reduce chart of accounts maintenance.
  D. Define two different charts of accounts
  B. Use two different value sets for the company and intercompany segment because segment value security rules are at the value set level.

• Question 7:

  What are the two benefits of having the Essbase cube embedded in Oracle General Ledger (GL)? (Choose two.)

  A. You can access real-time results for reporting and analysis because the multidimensional balances are updated on journal posting
  B. You no longer need to create and maintain hierarchies because the Essbase cubes are created when you create your chart of accounts
  C. Integrating with third-party systems is easier because the Essbase cube provides chart of accounts mapping rules
  D. General ledger balances are multidimensional, allowing you to perform robust reporting and analysis
  A. You can access real-time results for reporting and analysis because the multidimensional balances are updated on journal posting
  D. General ledger balances are multidimensional, allowing you to perform robust reporting and analysis

• Question 8:

  All of your subsidiaries can share the same ledger with their parent company and all reside on the same application instance. They do perform intercompany accounting.

  What is Oracle's recommended approach to performing consolidations?

  A. Use General Ledger's Financial Reporting functionality to produce consolidated reports by balancing segment where each report represents a different subsidiary. Any eliminating entries can be entered in yet another separate balancing segment
  B. Use Oracle Hyperion Financial Management for this type of complex consolidation
  C. Use General Ledger's Balance Transfer programs to transfer subsidiary ledger balances to the parent ledger, and then enter eliminating entries as a separate balancing segment in the parent ledger
  D. Define multiple ledgers for consolidation and report on ledger set
  A. Use General Ledger's Financial Reporting functionality to produce consolidated reports by balancing segment where each report represents a different subsidiary. Any eliminating entries can be entered in yet another separate balancing segment

• Question 9:

  Which two statements are true regarding the Intercompany Reconciliation Report? (Choose two.)

  A. You can only drill down to the general ledger journal and then from there to the subledger journal entry.
  B. This report can be run using an additional currency and conversion rate that converts all amounts into a common currency for comparison.
  C. This report displays only the reconciled transactions. You need to further process automatic reconciliation to reconcile the unreconciled transactions.
  D. This report includes Ledger balancing lines generated when the primary balancing segment value (BSV) is in balance, but either the second or third BSVs are not.
  E. This report displays the intercompany receivables and intercompany payables balances in summary for a period.
  B. This report can be run using an additional currency and conversion rate that converts all amounts into a common currency for comparison.
  E. This report displays the intercompany receivables and intercompany payables balances in summary for a period.

  ---

  explanation:

  Reference: https://docs.oracle.com/en/cloud/saas/financials/20b/ocuar/oracle-fusion-intercompany-reports.html#OCUAR1573663

• Question 10:

  Your enterprise structure has one ledger and two business units. Business unit one wants to enable budgetary control for Requisitioning only in Procure-to-Pay Business Functions and business unit two wants to enable budgetary control for Payable Invoicing only in Procure-to-Pay Business Functions.

  Which two statements are correct? (Choose two.)

  A. Define budgetary control at ledger level and only encumbrance controls at the business units.
  B. While defining control for business unit two, enable control at Requisitioning and define the exceptions to only include invoicing.
  C. Define budgetary control at ledger level with Budgetary Control Exceptions for each business unit.
  D. While defining control for business unit one, disable control for Procurement, Expense Management, Payable Invoicing, and Receiving.
  E. While defining control for business unit one, enable control at purchasing and define the exceptions to only include requisitioning.
  F. Define control for business unit two to disable control for Requisitioning, Procurement, Expense Management, and Receiving.
  D. While defining control for business unit one, disable control for Procurement, Expense Management, Payable Invoicing, and Receiving.
  F. Define control for business unit two to disable control for Requisitioning, Procurement, Expense Management, and Receiving.