Balances cubes are multidimensional databases that store financial balances for interactive reporting and analysis. A balances cube is created for each unique combination of ledger and currency, and it contains dimensions such as chart of accounts segments, periods, scenarios, and other user-defined attributes. New dimensions can be added to a balances cube by using the Manage Balances Cube Dimensions task in General Ledger. Balances cubes are updated automatically when journals are posted in General Ledger, and they can also be refreshed manually by using the Refresh Balances Cube task. Balances cubes are not affected by the Translation or Revaluation processes, as these processes only update the balances tables in General Ledger. References:

Overview of Oracle General Ledger Balances Cubes1

Considerations for General Ledger Balances Cubes2

Overview of Oracle Essbase Balances Cubes3

The adjustment only level is the data conversion level that ensures only manual journals will be entered in the secondary ledger. This level means that no data is copied from the primary ledger to the secondary ledger automatically. Instead, the user can enter manual adjustments in the secondary ledger to reflect the differences between the two accounting standards. This level is suitable for scenarios where the accounting methods or charts of accounts are very close between the primary and secondary ledgers, and there is no need to maintain detailed journals or subledger transactions in the secondary ledger. References: Primary Ledgers, Secondary Ledgers, and Reporting Currencies, High Volume Data Migration Considerations for General Ledger, Reporting Currencies - Conversion Level Balance

Data access sets are collections of ledgers that define the data security for users who access General Ledger. Users can only access the ledgers that are assigned to them through data access sets. To allow users with the General Accountant job role to access the UK Ledger, you need to create a data access set that includes the UK Ledger and assign it to the user/role combination. You also need to specify the access privilege for the data access set, which can be Full Ledger, Both Read and Write, or Read Only. In this case, you need to select Both Read and Write to allow read/write access to the full ledger. References:

Implement General Ledger

GL_ACCESS_SET_LEDGERS

The Default Data Access Set

Overview of General Ledger Security

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 FinancialsCloud: General Ledger 2022 Implementation Professional Objectives - Use Oracle Transactional Business Intelligence (OTBI) 12

Infotiles and infolets are graphical components that display key information and metrics on the General Accounting dashboard. They help users access many sources of information across the enterprise in an efficient, timely, and engaging manner. Infolets can be refreshed to see up-to-date data by clicking the Refresh icon on the infolet. Infotiles have three views: Front view, which shows a summary of the most important information; Back view, which shows additional details and actions; and Expanded view, which shows a full-screen view of the infotile content. References:

Oracle Financials Cloud: Using General Ledger, Chapter 6: Financial Reporting and Analysis, Section: General Accounting Infolets

Oracle Financials Cloud: Implement General Ledger, Chapter 1: Overview of Oracle Financials Cloud, Section: Overview of Using Infolets to Identify Issues and Prioritize Tasks

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.

According to Oracle documentation2, you should create a Data Access Set that allows access to the UK Ledger to allow users with the General Accountant job role to access the UK Ledger. A Data Access Set is a security feature that defines the ledgers and balancing segment values that a user can access. You can assign Data Access Sets to users or roles using the Manage Data Access for Users page. Therefore, option B is correct. Option A is incorrect because assigning the security context value of UK Ledger to the user/role combination does not enable access to the ledger. Option C is incorrect because assigning the General Accounting Manager role to those users does not enable access to the ledger. Option D is incorrect because assigning the UK reference set to the user/role combination does not enable access to the ledger.

A primary ledger is the main ledger for a legal entity or business unit that records all accounting transactions and maintains the accounting balances. A secondary ledger is an optional ledger that is associated with a primary ledger and maintains accounting balances in a different accounting representation. A reporting currency is an optional currency that is associated with a primary ledger and maintains accounting balances in a different currency. In this scenario, the subsidiary company needs to produce fiscal reports under local GAAP and local currency, as well as report to the parent company using IFRS and not local currency. Therefore, the subsidiary company should configure a primary ledger with the local accounting convention and local currency, and a secondary ledger with the IFRS accounting convention and not local currency. A reporting currency with the local accounting convention or the IFRS accounting convention would not meet the requirement, as it would only maintain balances in a different currency, not a different accounting representation. A primary ledger with the IFRS accounting convention would not meet the requirement, as it would not comply with the local GAAP. References:

Oracle Financials Cloud Implementing Enterprise Structures and General Ledger, Chapter 2: Ledgers, Primary Ledgers, Secondary Ledgers, and Reporting Currencies

Oracle Financials Cloud Using General Ledger, Chapter 1: Introduction, Ledgers and Subledgers, Primary Ledgers, Secondary Ledgers, and Reporting Currencies

The revaluation process is used to adjust account balances denominated in a foreign currency. Revaluation adjustments represent the difference in account balances due to changes in conversion rates between the date of the original journal and the revaluation date. These adjustments are posted through journal entries to the underlying account with the offset posted to an unrealized gain or loss account. The two statements that are true about the resulting revaluation run are:

You have an unrealized exchange loss recorded: Since the ledger currency (USD) has depreciated against the foreign currency (Euro) from the date of the original journal to the revaluation date, the account balance in USD has increased. This means that you have a loss on the

To create an Income Statement using Smart View, you should use Ad Hoc Analysis. Ad Hoc Analysis is a Smart View tool that allows users to view and analyze financial data from General Ledger Cloud using Essbase cubes. Users can create reports such as Income Statements or Balance Sheets by selecting dimensions and members from Essbase cubes and retrieving data into Excel worksheets. Users can also perform actions such as drilling down, pivoting, zooming in or out, or expanding or collapsing members

Here are the steps you need to follow:

Navigate to the Setup and Maintenance work area and search for the task Manage Chart of Accounts Structures.

Click on the Create icon to create a new Chart of Accounts Structure. Enter the following information:

Structure Code: 07COA

Structure Name: 07 Chart of Accounts

Description: Chart of Accounts for candidate 07

Number of Segments: 5

Click on the Next button to define the segments. Enter the following information for each segment:

Segment Number: 1

Segment Name: Company

Value Set Code: 07Corporate Company

Value Set Name: 07 Corporate Company

Maximum Size: 3

Balancing: Yes

Segment Label: Company

Segment Number: 2

Segment Name: Cost Center

Value Set Code: 07Corporate Cost Center

Value Set Name: 07 Corporate Cost Center

Maximum Size: 4

Balancing: No

Segment Label: Cost Center

Segment Number: 3

Segment Name: Account

Value Set Code: 07Corporate Account

Value Set Name: 07 Corporate Account

Maximum Size: 8

Balancing: No

Segment Label: Natural Account

Segment Number: 4

Segment Name: Product

Value Set Code: 07Corporate Product

Value Set Name: 07 Corporate Product

Maximum Size: 3

Balancing: No

Segment Label: Product

Segment Number: 5

Segment Name: Intercompany

Value Set Code: 07Corporate Company

Value Set Name: 07 Corporate Company

Maximum Size: 3

Balancing: No

Segment Label: Intercompany

Click on the Next button to review the summary and click on the Save and Close button to save the Chart of Accounts Structure.

Navigate to the Setup and Maintenance work area and search for the task Manage Chart of Accounts Structure Instances.

Click on the Create icon to create a new Chart of Accounts Structure Instance. Enter the following information:

Structure Code: 07COA

Structure Name: 07 Chart of Accounts

Description: Chart of Accounts for candidate 07

Chart of Accounts Structure: 07COA

Enabled: Yes

Allow Dynamic Inserts: Yes

Click on the Next button to review the summary and click on the Save and Close button to save the Chart of Accounts Structure Instance.

You have successfully created a Chart of Accounts Structure and Instance for the given scenario. For more information, you can refer to the following resources:

Chart of Accounts Structures and Instances

Chart of Accounts Components

Minimum Steps For Financial Enterprise Structures Configuration

Overview of Creating and Configuring Chart of Accounts Structure and Instances