Oracle Oracle Financials Cloud 1Z0-1054-22 Questions & Answers

• Question 21:

  Your customer has three legal entities, 50 departments, and 10,000 natural accounts. They use intercompany entries. What is Oracle's recommended practice when implementing a new chart of accounts? How many segments and what segment qualifiers should be used?

  A. Define three segments for the company, department, and natural account. The qualifiers for the first segment should be primary balancing segment and intercompany segment, cost center segment, and natural account segment, respectively.

  B. Define four segments for the company, department, natural account, and intercompany segment. The qualifiers should be primary balancing segment, cost center segment, and natural account segment, and intercompany segment, respectively.

  C. Define three segments for the company, department, and natural account. The qualifiers should be primary balancing segment, cost center segment, and natural account segment, respectively.

  D. Define five segments for the company, department, natural account, intercompany, and future use segment. The qualifiers should be primary balancing segment, cost center segment, natural account segment, intercompany segment, and no qualifier, respectively.

  Correct Answer: B

  "A chart of accounts segment is a component of the account combination. Each segment has a value set attached to it to provide formatting and validation of the set of values used with that segment." The qualifiers are used to identify the segments for reporting and processing purposes2. In this case, the company segment should be the primary balancing segment, which is used to balance journal entries and create trial balances. The department segment should be the cost center segment, which is used to track costs by organizational units. The natural account segment should be the natural account segment, which is used to classify transactions by account type. The intercompany segment should be the intercompany segment, which is used to identify transactions between different legal entities or business units.

• Question 22:

  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.

  Correct Answer: BD

  According to Oracle documentation3, the following statements are true regarding the Intercompany Reconciliation Report: This report can be run using an additional currency and conversion rate that converts all amounts into a common currency for comparison, and 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. The Intercompany Reconciliation Report enables you to reconcile your intercompany receivables and payables accounts, and identify any missing transactions. This report is automatically generated when you run the Prepare Intercompany Reconciliation Information process. Therefore, options B and D are correct. Option A is incorrect because you can drill down to the general ledger journal, subledger accounting entry, and source receivables or payables transaction. Option C is incorrect because this report displays both the reconciled and unreconciled transactions. You can use automatic reconciliation or manual reconciliation to reconcile the unreconciled transactions.

• Question 23:

  You want to define an allocation rule where segment values are constants for rules and formulas. What should you do?

  A. Never use the Outer Point of View (POV)

  B. Always use the Outer Point of View (POV)

  C. Specify Run Time Prompts (RTP)

  D. Only specify segment values in formulas

  Correct Answer: A

  "The outer point of view is used to specify segment values that are constant for rules and formulas. If you use a parent value in the outer point of view, it must have a Constant segment type." Therefore, if you want to define an allocation rule where segment values are constants for rules and formulas, you should never use the outer POV.

• Question 24:

  You entered the following information in the Companies and Legal Entities tab of the Rapid Implementation Spreadsheet:

  

  Assuming currency is left blank in the Ledger worksheet, how many Ledgers will the process create?

  A. 6

  B. 3

  C. 4

  D. 5

  Correct Answer: B

  The process will create 3 ledgers based on the information entered in the Companies and Legal Entities tab of the Rapid Implementation Spreadsheet. The process will create one ledger for each unique combination of chart of accounts, accounting calendar, and currency. Since currency is left blank in the Ledger worksheet, the process will use the currency specified in the Companies and Legal Entities tab. The process will create one ledger for US1 with chart of accounts COA1, accounting calendar CAL1, and currency USD. The process will create another ledger for UK1 with chart of accounts COA2, accounting calendar CAL2, and currency GBP. The process will create a third ledger for FR1 and FR2 with chart of accounts COA2, accounting calendar CAL2, and currency EUR. The process will not create separate ledgers for FR1 and FR2 because they share the same chart of accounts, accounting calendar, and currency.

  Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional Objectives-Define Chart of Accounts 12

• Question 25:

  You have redesigned your chart of accounts and need to update your existing cross-validation rules. There is a requirement for new rules; some simply need to be updated and others need to be deleted. What is the most efficient way to achieve this?

  A. by using the Manage General Ledger Security page.

  B. by creating Cross-Validation Rules desktop-integrated spreadsheet.

  C. by using Cross-Validation Rules Import file-based data import (FBDI).

  D. by using the Manage Cross-Validation Rules page.

  Correct Answer: C

  According to Oracle documentation1, the most efficient way to update your existing cross-validation rules when you have redesigned your chart of accounts is to use Cross-Validation Rules Import file-based data import (FBDI). FBDI enables you to import cross-validation rules from a spreadsheet template into General Ledger. You can use FBDI to create new rules, update existing rules, or delete rules. Therefore, option C is correct. Option A is incorrect because using the Manage General Ledger Security page does not enable you to update cross-validation rules. Option B is incorrect because creating Cross-Validation Rules desktop-integrated spreadsheet does not enable you to update cross-validation rules. Option D is incorrect because using the Manage Cross-Validation Rules page does not enable you to update cross-validation rules efficiently.

• Question 26:

  You need to set up a calendar for the year Apr-XX to Mar-YY where YY is the following year, and you would like the periods to be named according to the year they fall in.

  What format should you choose?

  A. Fiscal Year

  B. Calendar Year

  C. Period

  D. Year

  Correct Answer: A

  According to Oracle documentation3, when you need to set up a calendar for the year Apr-XX to Mar-YY where YY is the following year, and you would like the periods to be named according to the year they fall in, you should choose Fiscal Year as the format. A Fiscal Year format enables you to define periods based on fiscal years that span two calendar years. Therefore, option A is correct. Option B is incorrect because a Calendar Year format defines periods based on calendar years that start on January 1st and end on December 31st. Option C is incorrect because a Period format defines periods based on any number of days or weeks. Option D is incorrect because a Year format defines periods based on calendar years that start on any month other than January and end on any month other than December.

• Question 27:

  You are defining an income statement report. You want to allow viewers of the report to be able to drill down from report balances to the underlying transactions. What so you need to enable?

  A. Drill Through in Grid Properties

  B. Nothing. All report balances are drillable in all FR Studio reports

  C. Allow Expansion

  D. Report Functions

  Correct Answer: A

  Drill Through is a feature in Financial Reporting Studio that allows viewers of a report to drill down from report balances to the underlying transactions. To enable Drill Through, you need to select the Drill Through option in the Grid Properties dialog box and specify a data source connection and a drill-through definition3.

• Question 28:

  You can run predefined reports to reconcile subledger application balances to General Ledger balances.

  Which attribute needs to be set up on the Manage Values page for chart of accounts segment values so that you can run the Payables to General Ledger Reconciliation Report or Receivables to General Ledger Reconciliation Report?

  A. Financial Category

  B. Third Party Control Account

  C. End Date

  D. Start Date

  E. Reconcile

  Correct Answer: B

  According to Oracle documentation3, the attribute that needs to be set up on the Manage Values page for chart of accounts segment values so that you can run the Payables to General Ledger Reconciliation Report or Receivables to General Ledger Reconciliation Report is Third Party Control Account. The Third Party Control Account attribute enables you to maintain detailed balances by third party for an account combination. Valid third-party information must be associated with the journal line if the account is a third party control account. General Ledger prevents manual journal entries from posting to third party control accounts. Therefore, option B is correct. Option A is incorrect because Financial Category is not an attribute that affects the reconciliation reports. Option C is incorrect because End Date is not an attribute that affects the reconciliation reports. Option D is incorrect because Start Date is not an attribute that affects the reconciliation reports. Option E is incorrect because Reconcile is not an attribute that affects the reconciliation reports.

• Question 29:

  Which two allow access to the BI Catalog for creating an Oracle Transactional Business Intelligence analysis? (Choose two.)

  A. Universal Content Management Workspace

  B. Reports and Analytics

  C. Business Process Management Workspace

  D. Enterprise Performance Management Workspace

  E. Scheduled Processes

  Correct Answer: BD

  The two options that allow access to the BI Catalog for creating an Oracle Transactional Business Intelligence analysis are Reports and Analytics and Enterprise Performance Management Workspace. Reports and Analytics is a tool that

  allows users to access, create, edit, and share reports and analyses using data from various sources, including Oracle Transactional Business Intelligence. Users can access Reports and Analytics from various pages in Oracle Fusion

  Applications or from Oracle Fusion Cloud Service Console. Enterprise Performance Management Workspace is a tool that allows users to access, create, edit, and share reports and analyses using data from various sources, including Oracle

  Transactional Business Intelligence. Users can access Enterprise Performance Management Workspace from Oracle Fusion Cloud Service Console or from a web browser. Universal Content Management Workspace is not an option that

  allows access to the BI Catalog for creating an Oracle Transactional Business Intelligence analysis, as this is a tool that allows users to manage documents and other digital content in Oracle Fusion Applications. Business Process

  Management Workspace is not an option that allows access to the BI Catalog for creating an Oracle Transactional Business Intelligence analysis, as this is a tool that allows users to monitor and manage business processes in Oracle Fusion

  Applications. Scheduled Processes is not an option that allows access to the BI Catalog for creating an Oracle Transactional Business Intelligence analysis, as this is a tool that allows users to submit, monitor, and manage scheduled

  processes in Oracle Fusion Applications.

  Reference: Oracle Financials Cloud:

  General Ledger 2022 Implementation Professional Objectives-Use Oracle Transactional Business Intelligence (OTBI) 12

• Question 30:

  You entered a cross validation rule to prevent the balance sheet cost center (000) being used with Profit and Loss Accounts (4000-ZZZZ).

  The following combinations exist in the Code Combination table:

  01-000-4110-00, 01-000-5299-000, 01-000-5105-000 and 01-000-7640-00

  Which two statements are true regarding cross-validation rules? (Choose two.)

  A. The rules validate and apply to new accounts only

  B. You need to run the Cross-Validation Rules process to list and optionally disable combinations that violate rules

  C. You need to run the Cross-Validation Rule Violations process to allow rules to apply to existing combinations that violate rules

  D. There is no need to create cross-validation rules if Dynamic Combination Creation Allowed is not enabled for your chart of accounts instance

  E. The rules will validate and apply to new and existing accounts

  Correct Answer: BE

  The two true statements regarding cross-validation rules are that you need to run the Cross-Validation Rules process to list and optionally disable combinations that violate rules, and that the rules will validate and apply to new and existing accounts. The Cross-Validation Rules process is a scheduled process that identifies existing account combinations that violate cross-validation rules and optionally disables them. You can run this process after defining or modifying cross-validation rules to ensure data integrity. The cross-validation rules will validate and apply to new and existing accounts, as they are enforced whenever an account combination is created or updated. The rules do not apply to new accounts only, as they also apply to existing accounts. There is no need to run the Cross-Validation Rule Violations process, as this is not a supported option. There is no need to create cross-validation rules if Dynamic Combination Creation Allowed is not enabled for your chart of accounts instance, as this is not a relevant factor. Dynamic Combination Creation Allowed is an option that determines whether users can create new account combinations on the fly or only use predefined combinations.

  Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional Objectives-Define Chart of Accounts 12