1z0-1054-26 Questions and Answers

Intercompany System options are used to set up intercompany processing rules at the enterprise level, based on your specific business needs. They help you standardize and simplify transaction processing, minimize disputes, and reduce administrative costs. The three factors that you should consider while specifying Intercompany System options are:

Automatic or manual batch numbering and the minimum transaction amount: These options help you control the numbering and the size of intercompany transactions. You can choose to use system generated or manual batch numbering, and you can specify a minimum threshold amount for intercompany transactions to prevent immaterial transactions. To use the minimum transaction amount option, you must also select an Intercompany currency option.

Whether to enforce an enterprise-wide currency or allow intercompany transactions in local currencies: This option helps you manage the currency risk and the conversion rate fluctuations for intercompany transactions. You can choose to standardize transaction processing by selecting an Intercompany currency, which means that all intercompany transactions created in the Intercompany module are entered in this currency. Alternatively, you can choose to allow intercompany transactions in local currencies, which means that intercompany transactions can be entered in the ledger currency of the sender or the receiver.

Whether to allow receivers to reject intercompany transactions: This option helps you handle the approval and dispute resolution process for intercompany transactions. You can choose to allow receivers to reject intercompany transactions if they disagree with the sender’s information, such as the amount, the account, or the date. If you enable this option, you must also specify the rejection reason and the notification details for the sender.

Intercompany System Options

Implementing Enterprise Structures and General Ledger

Implement General Ledger

To achieve the requirement of only single currency journals being entered for this company, you should enable “Limit a Journal to a Single Currency” on both ledger options and journal sources. Ledger options are settings that apply to a specific ledger, such as journal processing options, currency options, and average balance processing options. Journal sources are identifiers that indicate where a journal originated, such as manual entry, subledger accounting, or import. You can enable “Limit a Journal to a Single Currency” on both ledger options and journal sources using the Specify Ledger Options and Manage Journal Sources tasks in Setup and Maintenance. This will enforce single currency journals for journals entered on the Create Journal page and for journals that are imported. You do not need to enable “Limit a Journal to a Single Currency” on journal lookup codes, as these are codes that indicate the status of a journal, such as Entered, Posted, or Reversed. You do not need to enable “Limit a Journal to a Single Currency” on journal category, as this is an attribute that classifies journals by purpose or function, such as Purchase Invoices or Allocations. You do not need to enable “Limit a Journal to a Single Currency” on profile option, as this is a setting that affects the behavior of an application or feature for a user or responsibility. Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional Objectives - Define Ledgers 12

 Here are the steps you need to follow:

In the Setup and Maintenance work area, go to the following:

Offering: Financials

Functional Area: Financial Reporting Structures

Task: Manage Chart of Accounts Mapping

Select the source chart of accounts (UK) and the target chart of accounts (CA) that you want to map.

Click on the Segment Rules tab to define the segment mapping rules. Enter the following information for each segment:

Segment Number: 1

Segment Name: Company

Mapping Type: Value

Source Value: *

Target Value: *

Segment Number: 2

Segment Name: LoB

Mapping Type: Value

Source Value: *

Target Value: *

Segment Number: 3

Segment Name: Account

Mapping Type: Range

Source From Value: 1000

Source To Value: 1999

Target Value: 11101

Mapping Type: Range

Source From Value: 2000

Source To Value: 2999

Target Value: 22100

Mapping Type: Range

Source From Value: 3000

Source To Value: 3999

Target Value: 34000

Mapping Type: Range

Source From Value: 4000

Source To Value: 4999

Target Value: 42000

Mapping Type: Range

Source From Value: 5000

Source To Value: 99999999

Target Value: 51100

Segment Number: 4

Segment Name: Cost Center

Mapping Type: Value

Source Value: 0

Target Value: Balance Sheet

Mapping Type: Value

Source Value: 000

Target Value: Balance Sheet

Mapping Type: Value

Source Value: *

Target Value: 610

Segment Number: 5

Segment Name: Product

Mapping Type: Value

Source Value: *

Target Value: *

Segment Number: 6

Segment Name: Intercompany

Mapping Type: Value

Source Value: *

Target Value: *

Click on the Save and Close button to save the segment mapping rules.

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

Overview of the Chart of Accounts Mapping Page

Chart of Accounts Structures and Instances

How To Create A Chart Of Accounts Mapping For A Secondary Ledger

How To Bulk Upload The Mapping Rules In “Manage Chart of Accounts Mapping”

Centralized Management of Chart of Accounts Configurations

Here are the steps you need to follow:

In the Setup and Maintenance work area, go to the following:

Offering: Financials

Functional Area: Financial Reporting Structures

Task: Manage Shorthand Aliases

Select the chart of accounts that you want to create the alias for. In this case, it is the Corporate chart of accounts.

Click on the Add Row icon to create a new alias. Enter the following information:

Alias Name: RevDom

Account Template: 101-2000-400000-000-000-000

Description: Revenue Domestic for Supremo Fitness, Line of Business 2, and US Operations Cost Center

Enabled: Yes

Start Date: Today’s date

End Date: Blank

Click on the Save and Close button to save the alias.

You have successfully created a shorthand alias for the US Chart of Accounts. For more information, you can refer to the following resources:

Account Aliases

Enter a GL Account Alias

Short Hand Alias in Fusion Financials Key Flexfield

How to Enable Account Shorthand Aliases

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

The ledger option alone does not enforce the single-currency restriction for every journal source automatically. Oracle General Ledger applies this restriction at the journal source level. Since users are creating journals manually through the Create Journal task, the relevant source is the Manual journal source. Therefore, to stop users from entering multiple currencies in a manually created journal, the Limit Journal to the Single Currency option must be enabled for the Manual source. The category is not the controlling setup point, and the restriction is not enabled by currency value. Oracle documentation explains that single-currency enforcement is configured by journal source, and applicable journal sources must have the option enabled for the restriction to apply.

To keep a thin secondary ledger, you should select the balance level as the data conversion level. This means that only the ending balances of the primary ledger are copied to the secondary ledger at the end of each period. This reduces the data volume and storage requirements of the secondary ledger, as well as the processing time and resources needed to copy the data. The balance level conversion is suitable for scenarios where the accounting methods or charts of accounts are similar 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, How Journals Are Copied from Primary to Secondary Ledgers When …, GL Secondary Ledger Conversion Level Change

According to the Oracle documentation12, the Intercompany Reconciliation Report can be run using an additional currency and conversion rate that converts all amounts into a common currency for comparison (option C). The report also includes ledger balancing lines generated when the primary balancing segment value is in balance, but either the second or third balancing segment values are not (option B). Option A is incorrect because you can drill down to the general ledger journal, subledger accounting entry, and source receivables or payables transaction2. Option D is incorrect because the report displays the intercompany receivables and intercompany payables balances in summary for a period, and any differences between them1. Option E is incorrect because the report does not display clearing company balancing lines2.

According to Oracle documentation3, Oracle’s recommended method to define a chart of accounts that includes an intercompany segment when your customer plans to use segment value security rules for the Company segment is to share the same value set for the company and intercompany segments. Sharing the same value set enables you to use segment value security rules for both segments and ensures that the values in both segments are consistent. Therefore, option B is correct. Option A is incorrect because defining the intercompany segment with a default value does not enable segment value security rules for the intercompany segment. Option C is incorrect because defining the company segment and assigning both the primary balancing segment and intercompany segment labels does not enable segment value security rules for the intercompany segment. Option D is incorrect because creating two different value sets for the company and intercompany segments does not ensure that the values in both segments are consistent.

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

Related Value Sets in Oracle Fusion Cloud are used to create a relationship between two value sets so that the valid values of one segment are restricted based on the value selected in a preceding segment. The important correction here is that the value sets used in related value set configuration must be Independent value sets, not Dependent value sets. A Dependent validation type is a different value-set mechanism and is not the correct setup for Related Value Sets in the Chart of Accounts. Oracle documentation explains that related value sets define dependencies where the values shown for a succeeding segment are filtered by the selected predecessor value, and both value sets must be independent.