Oracle Financials Cloud: General Ledger 2025 Implementation Professional Questions and Answers
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
Challenge 2
Manage Shorthand Aliases
Scenario
Your client intends to utilize the Shorthand Alias feature and would like to see how the aliases will appear when entering transactions.
Task 2
Create a shorthand alias for the US Chart of Accounts to record Revenue Domestic for Supremo Fitness, Line of Business 2, and US Operations Cost Center.
Note:
. Prefix your alias name with 07, where 07 is
your exam ID.
. There is no Product or Intercompany
impact.
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.
You have a requirement to have invoices generated for certain Intercompany transactions.
Where do you enable invoicing?
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?
Your company wants to change theCumulative Translation Adjustment (CTA) accountto record gains/losses from varying currency rates.
What steps must you perform to achieve this objective without causing data corruption?
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 two statements are true regarding the Intercompany Reconciliation Report? (Choose two.)
What are two uses of theColumn FlatteningandRow Flatteningfeatures?
Which delivered role can access the full functionality of Functional Setup Manager?
You need to set up a calendar for the year Apr-XX to Mar-YY where YY is the following year, and you would like the periods to be named according to the year they fall in.
What format should you choose?
You have just been hired to add a new subsidiary to the corporate enterprise structure in the customer's Oracle Fusion Cloud.
The subsidiary will capture transaction information from subledgers in the local currency and under International Financial Reporting standards (IFRS) and local GAAP for corporate reporting requirements, which will report via the use of a secondary ledger.
The secondary ledger is used only at period end; there is no need to have real-time transaction or Journal details. It is noted that most of the accounting between IFRS and Corporate GAAP is similar.
Which conversion level would you recommend to keep a thin secondary ledger?
You notice that a lot of erroneous address data is being saved. How do you ensure that only valid addresses are entered in the system?