Get Oracle 1Z0-1054-23 Exam Dumps

Answer : B

To view high-level profit and loss results for each ledger in the Close Monitor, you need to associate a Financial Reporting Web Studio report with the ledger set. This report should be based on the General Ledger Balances cube and should include the Income Statement account group as a row dimension. The report should also have the ledger set as a point of view dimension and the period and currency as user prompts. This way, you can select the ledger set, period, and currency when you run the report from the Close Monitor and see the aggregated income statement results for each ledger and consolidation node in the ledger set hierarchy.Reference:Overview of Close Monitor,Using General Ledger,Close Monitor Issue

Answer : D

Answer : A

When integrating with Oracle Hyperion Financial Management, you can use the following dimensions for consolidation: Entity, Scenario, Year, Period, Value, Account, Intercompany, Custom1 to Custom4, and View. You can map one to one, or concatenate segments from your source General Ledger to a single Hyperion Financial Management dimension. For example, you can map Company to Entity, Department to Department, and Account to Account. However, if you have segments in your source General Ledger that cannot be mapped to any Hyperion Financial Management dimension, such as Program, then the data is summarized across those segments. This means that the data is aggregated to the highest level of the unmapped segments, and the detail information is lost. For example, if you have Program as a segment in your source General Ledger, and you do not map it to any Hyperion Financial Management dimension, then the data is summarized by Program, and you cannot see the data by individual Program values in Hyperion Financial Management.Reference:

Example of Mapping Segments to Financial Management Dimensions

Overview of the Chart of Accounts Mapping Page

Answer : C

According to Oracle's documentation, if you enter and post additional journal entries in your ledger currency after you run translation, you should rerun translation for the entire ledger or ledger set to ensure that all balances are translated using the same exchange rates. Then, you should reconsolidate your results to reflect the updated translated balances.Reference:

Using General Ledger, page 9-7: ''If you enter and post additional journal entries in your ledger currency after you run translation, you should rerun translation for the entire ledger or ledger set.''

Using General Ledger, page 9-8: ''After you run translation, you can consolidate your results to create a consolidated balance sheet and income statement.''

Implement General Ledger, page 2-10: ''You can translate and consolidate balances as part of the period close process.''

Answer : D

If you use insert in the spreadsheet to load the monthly historical rates by using FBDI, the existing historical rate for a specific ledger, currency, account combination, and accounting period will be replaced by the new rate. This is because the insert action will overwrite the existing rate with the new rate in the GL_HISTORICAL_RATES_INT table. If you want to preserve the existing rate, you should use update or delete actions instead.Reference:

How Historical Rates Import Data Is Processed, Section: Use the Historical Rates Import file-based data import (FBDI) template to import historical rates from external and legacy sources to Oracle General Ledger

Import Historical Rates, Section: Details

Entering Historical Rates, Section: Entering Historical Rates