Task 3
Manage Chart of Accounts Mappings
Scenario
Your client needs to consolidate their UK Ledger to the Canadian parent ledger. Each Chart of Accounts has the following segments:
Company-LoB-Account-Cost Center-Product-Intercompany
Know that the Company, LoB, Product, and Intercompany segments share the same value sets.
Create a Chart of Accounts mappings to map UK Chart of Accounts to CA Chart of Accounts that meets the following specifications:
Cost Center Mapping
. Balance Sheet (0 and 000) should be mapped to
Balance Sheet
. All other cost centers should be mapped to 610
Account Mapping
. Asset accounts (in the 1000 range) should be
mapped to account 11101
. Liability accounts (in the 2000 range) should be
mapped to account 22100
. Equity accounts (in the 3000 range) should be
mapped to account 34000
. Revenue accounts (in the 4000 range) should be
mapped to account 42000
. Expense accounts (from 5000 onwards) should be
mapped to account 51100
Note:
Do not use conditions based on parents.
. Treat any account after the 5000 range as an expense.
Ensure all maps are numeric only.
When creating your mapping rules for each segment
please allow for existing and future segment values

See the Explanation for the complete Solution.
Explanation:
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

You want toprevent intercompany transactionsfrom being entered during thelast day of the close. What should you do?

• A. Close all subledger periods.
• B. Close Intercompany periods in Fusion Intercompany.
• C. Freeze the Intercompany Journal source in General Ledger.
• D. Close the General Ledger period in the Manage Accounting Periods page.

Which two infolets are used for monitoring day-to-day operations?

• A. Close Monitor
• B. Account Monitor
• C. Open Subledgers
• D. Unallocated
• E. IC Transactions

Explanation: Only visible for ActualTestsIT members. You can sign-up / login (it's free).

The intercompany accountants on the cloud project are trying to reconcile intercompany balances using the latest intercompany reconciliation report.
However, they have some concerns about the information presented in the report and want you to clarify the content in the standard reconciliation report.
What is included in the intercompany reconciliation report?

• A. It displays all clearing company balances for the period.
• B. It displays the intercompany receivables and intercompany payables lines generated for the provider and receiver of each intercompany transaction.
• C. It displays ledger balancing lines generated when the primary balancing segment (BSV) is in balance but not the second or third BSVs.

Which three Oracle Transactional Business Intelligence (OTBI) objects can be created by using the tools in the Oracle Business Intelligence (BI) catalog?

• A. Analyses
• B. Infotiles
• C. Infolets
• D. Reports
• E. Dashboards