You are setting up Close Monitor and want to view high-level profit and loss results for each ledger.
What should you associate with the ledger set to achieve this?
A subsidiary company is about to configure their General Ledger in a highly regulated country where there is a legal requirement to produce fiscal reports under local GAAP. Subledgers transferring to General Ledger must use the local currency, and there is a requirement to report to the parent company (not local currency) using International Financial Reporting Standards (IFRS).
Which two ledger types should be configured to fulfill this reporting requirement?
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.Reference:
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
When will Intercompany processing balance a journal using the accounts identified here for the UK Ledger?
Manage Chart of Accounts Structure and Instance
Scenario
Your client is implementing Oracle Fusion Cloud Financials. The decision is to have a 5-segment Chart of Accounts: Company, Cost Center, Account, Product, and Intercompany. You are working in
the General Ledger team and will be responsible for creating the Chart of Accounts Structure and Instance for the Chart of Accounts.
Task 1
Create a Chart of Accounts Structure and Instance for the following Chart of Accounts:
Note:
* Prefix all your setups with 07, where 07 is your candidate ID
* There is one balancing segment.
* Choose the appropriate segment labels.
. For the purpose of this test there is no need to deploy the flexfield.
. Valid code combinations should be added to the Code Combination table automatically.
* Shorthand aliases will not be implemented.
. Accept the defaults for the instance segments.
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
Minimum Steps For Financial Enterprise Structures Configuration
Overview of Creating and Configuring Chart of Accounts Structure and Instances
You are planning to create an Income Statement using Smart View.
Which Smart View tool should you use for this?
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
