Oracle Financials Cloud: General Ledger 2024 Implementation Professional - 1z0-1054-24 Exam Practice Test
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
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
Correct Answer:
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
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
What type ofusermust be defined before you can create anImplementation Project?
Correct Answer: D
Vote an answer
Which two allow access to the BI Catalog for creating an Oracle Transactional Business Intelligence analysis?
(Choose two.)
(Choose two.)
Correct Answer: B,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
On a primary ledger in Use system options close section, the following field has been selected:
'Prevent General Ledger Period Close When Open Subledger Periods Exist'.
What three exceptions will prevent closing of the accounting period?
'Prevent General Ledger Period Close When Open Subledger Periods Exist'.
What three exceptions will prevent closing of the accounting period?
Correct Answer: A,C,D
Vote an answer
Which two statements are true about the Intercompany Reconciliation report?
Correct Answer: B,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
An Oracle Fusion Cloud customer has a complex enterprise structure that includes multiple legal entities in multiple countries. To match the intercompany balancing requirements, all four levels of rules have been defined. In user testing, the business experts are asking which rule will be considered first when balancing an intercompany journal?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
In the implementation project, there is a requirement to add new transactional attributes to the journal approval notification.
Which two Business Intelligence catalog objects should you copy (or customize) and edit? (Choose two.)
Which two Business Intelligence catalog objects should you copy (or customize) and edit? (Choose two.)
Correct Answer: D,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A company implementing Oracle General Ledger has a business requirement to report under two accounting conventions and is considering setting up a primary and secondary ledger. The two accounting standards are very close.
Which data conversion level should you recommend to ensure only manual journals will be entered in the secondary ledger?
Which data conversion level should you recommend to ensure only manual journals will be entered in the secondary ledger?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Your customer has alarge number of legal entities. Thelegal entity valuesare defined in thecompany segment and the primary balancing segment.
They want to easily createeliminating entriesfor theintercompany activity.
What should you recommend?
They want to easily createeliminating entriesfor theintercompany activity.
What should you recommend?
Correct Answer: D
Vote an answer