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

Oracle 1Z0-1081-20 Online Questions & Answers

• Question 71:

  Which two data extract export file types are available within Financial Consolidation and Close (FCCS)? (Choose two.)

  A. DAT file type
  B. Excel XLS file type
  C. Comma delimited
  D. Tab delimited
  C. Comma delimited
  D. Tab delimited

• Question 72:

  You need to define a form that requires users to select the entity for which to view data from a list that includes USA, Canada, and South America, but no other entities. Where on the form do you place the Entity dimension?

  A. the Point of View
  B. rows
  C. columns
  D. the Page Axis
  A. the Point of View

  ---

  The point of view is displayed on the top of the form. Elements that can be changed are displayed as links in the point of view. For example, if the Entity dimension is displayed as a link, you can change the entity but not the other dimensions in the point of view. Reference: https://docs.oracle.com/cd/E57185_01/OHFMU/form_pov.htm#OHFMU- Webdataforms472213

• Question 73:

  P, Q, and R are children of a mid-level parent entity, AceCo. In February each entity has cash in the amounts of 10, 20, and 30, respectively, and AceCo has been consolidated and has cash of 60. A prior period adjustment to Q adjusts cash

  with a debit of 5.

  Which statement regarding consolidation is correct?

  A. There is no way to do a prior period entry like this.
  B. January and February should be consolidated.
  C. February should be consolidated, after which the cash at AceCo is now 65.
  D. January should be consolidated for the change and nothing needs to happen for February.
  B. January and February should be consolidated.

• Question 74:

  Which statement is true of the default FCCS_ members within an application?

  A. You can change the default FCCS_ member prefix at application creation.
  B. You can change the Alias.
  C. You can change the Data Storage property.
  D. You can change the Name.
  B. You can change the Alias.

  ---

  The member names of the seeded accounts cannot be changed, but the aliases can. Reference: https://www.google.com/search?sxsrf=ALeKk01vTIkJ0rm1WblV1PEXOSkSLx2BmA% 3A1613856380969andei=fH4xYLrqOoj4gQbWz7-oDwandq=default+FCCS_+members+within+an+application+can +change+the+Aliasandoq=default +FCCS_+members+within+an+application+can+change+the +Aliasandgs_lcp=Cgdnd3Mtd2l6EAM6BwgAEEcQsAM6BAgjECc6BwghEAoQoAE6BAghEBVQ97gEWOXA BGDQwQRoAXACeACAAaECiAHlCpIBAzItNZgBAKABAaoBB2d3cy13aXrIAQjAAQEandsclient=gwswizandved=0 ahUKEwi6mLnCs_nuAhUIfMAKHdbnD_UQ4dUDCA0anduact=5

• Question 75:

  What is the correct Currency dimension member to select when running an Intercompany Matching Report?

  A. Input Currency
  B. Reporting Currency
  C. Entity Currency
  D. Parent Currency
  B. Reporting Currency

  ---

  Currency (Must be a Reporting Currency)

  Reference: https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/usfcc/ setting_up_intercompany_matching_reports.html

• Question 76:

  For which scenario would an On-Demand rule be an appropriate solution?

  A. to perform a custom currency translation for a subset of accounts
  B. to add a column with a calculation to a report
  C. to copy data from one scenario to a different scenario
  D. to allocate data to base entities prior to consolidation
  C. to copy data from one scenario to a different scenario

  ---

  Copy data from one scenario to another one.

  Reference: https://neonn.com/alwayson/demand-rules-hfm/

• Question 77:

  A company is based in the United Kingdom and has an application currency set to GBP. The company collects data from a United States based subsidiary. The subsidiary's functional currency is USD. Which two items facilitate the reporting of the subsidiary's Common Stock balance at an historical rate in the GBP reporting currency? (Choose two.)

  A. Common Stock must have an Exchange Rate Type set to Historical Rate Override.
  B. The subsidiary must have a balance not equal to zero in Common Stock.
  C. Common Stock must have a Data Storage property set to Never Share.
  D. USD must be created as a reporting currency.
  E. The subsidiary must have a parent entity with a GBP currency.
  B. The subsidiary must have a balance not equal to zero in Common Stock.
  E. The subsidiary must have a parent entity with a GBP currency.

• Question 78:

  Which of the following is allowed for accounts with the data storage type of "Dynamic Calc"?

  A. Load data to this account.
  B. Create member formulas.
  C. Load data to this account and create member formulas.
  D. Enter data through a data form
  C. Load data to this account and create member formulas.

• Question 79:

  Which four statements are true about the members in the FCCS_Cash Flow hierarchy in the Movement dimension? (Choose four.)

  A. The Cash Change hierarchy cannot be modified.
  B. All primary Movement members under the FCCS_Mvmts_Subtotal member must be included in the FCCS_CashFlow hierarchy.
  C. The seeded member FCCS_Mvmts_AccountsPayable found within the FCCS_CashFlow hierarchy has a Subtraction operator.
  D. Input level members under the FCCS_Mvmts_Subtotal are Shared members in the FCCS_CashFlow hierarchy.
  E. Standard cash accounts are members of the FCCS_CashFlow_Operating hierarchy.
  F. Siblings can be added to the FCCS_CashFlow_Investing member.
  C. The seeded member FCCS_Mvmts_AccountsPayable found within the FCCS_CashFlow hierarchy has a Subtraction operator.
  D. Input level members under the FCCS_Mvmts_Subtotal are Shared members in the FCCS_CashFlow hierarchy.
  E. Standard cash accounts are members of the FCCS_CashFlow_Operating hierarchy.
  F. Siblings can be added to the FCCS_CashFlow_Investing member.

• Question 80:

  To show the Intercompany account and matching account balances on the Intercompany Matching Report, you make which selection?

  A. Intercompany Accounts
  B. Intercompany Partners
  C. Intercompany Plug Accounts
  D. Elimination Consolidation Dimension member
  B. Intercompany Partners

  ---

  Intercompany Partner (ICP) Matching reports list the intercompany transactions that are eliminated during consolidation. Intercompany transactions are managed across the Intercompany Partner dimension. Reference: https://docs.oracle.com/cd/E57185_01/HFMAG/ch09s02.html