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.
What is the key functionality of Smart View in Oracle Cloud Financial Reporting?
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
Your customer isexpanding its operations. You defined a newledgerand severalbusiness units. However, you areunable to assignthe newly generateddata rolesto existingAccounts Payables and Accounts Receivablesusers in the shared service center.
What should you do to correct the problem?
Your organization would like to use the journal sequencing functionality in General Ledger. You want to include all journal sources but would like a different sequence assigned to journals originating in the Joint Venture application.
What should you create to achieve this?
When working with Essbase, versions of the tree hierarchy as defined in the Fusion are not available in the Essbase balances cube. What should you do to correct this situation?
You attempt to activate a tree version, but the audit process fails. In which two ways can you resolve this?
Budgetary control for accounts5020and5021has a budget of$90,000 USDeach for the year2012. The accounts also have balances onobligation of $10,000 USDfor each and anexpenditure of $20,000 USDfor each.
AFund of $50,000 USDis available for account5020only. You have run theEncumbrance Year End Carry Forward processfor obligation from the last period of the year2012to the first period of year2013.
Which statement is true?
You are trying to run a Financial Reporting Web Studio report from Financial Reporting Center. However, it is not appearing as a choice.
Which are two reasons for this? (Choose two.)
You are reviewing the Intercompany Reconciliation report for the current period and notice that there is a difference for the period as indicated.
What could be reason for this difference?