Your Financial Analyst needs to interactively analyze General Ledger balances with the ability to drill down to originating transactions. Which three features facilitate this? (Choose three.)
Correct Answer: C,D,E
The three features that facilitate interactive analysis of General Ledger balances with the ability to drill down to originating transactions are Account Inspector, Account Monitor, and Smart View. Account Inspector is a tool that allows you to select an account or an account group and view its balance and components, such as subledger details, journal lines, and supporting references. You can also drill down to the underlying transactions and subledger applications. Account Monitor is a tool that allows you to monitor key account balances in real time and compare them to predefined thresholds. You can also drill down to the underlying transactions and subledger details. Smart View is an Excel add-on that allows you to view and analyze financial data from General Ledger Cloud using Essbase cubes. You can also drill down from summary balances to journal details and subledger transactions. Sunburst reports are not a feature that facilitates interactive analysis of General Ledger balances with the ability to drill down to originating transactions, as they are graphical reports that show data distribution across different dimensions and hierarchies, but do not provide drill down capabilities. Online Transactional Business Intelligence (OTBI) is not a feature that facilitates interactive analysis of General Ledger balances with the ability to drill down to originating transactions, as it is a reporting tool that allows you to create custom reports using real-time transactional data from various sources, but does not provide drill down capabilities. Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional Objectives - Use Oracle Transactional Business Intelligence (OTBI) 12
1z0-1054-22 Exam Question 12
When creating financial reports which two tools use data from the General Ledger Balances Cube? (Choose two).
Correct Answer: A,B
According to Oracle documentation3, when creating financial reports, the two tools that use data from the General Ledger Balances Cube are Financial Reporting Studio and Smart View. Financial Reporting Studio is a graphical user interface that enables you to design and generate reports using data from various sources, including General Ledger Balances Cube. Smart View is an Excel add-in that enables you to access and analyze data from various sources, including General Ledger Balances Cube. Therefore, options A and B are correct. Option C is incorrect because Oracle Financial Statement Generator does not use data from the General Ledger Balances Cube. Option D is incorrect because Financial Reporting Center does not use data from the General Ledger Balances Cube.
1z0-1054-22 Exam Question 13
You need to create a boardroom ready month-end reporting package for an upcoming Audit Committee meeting. You have 10 Financial Reports that you want to share with executives and auditors that are nicely formatted. What are the two Oracle recommended ways to accomplish this? (Choose two.)
Correct Answer: B,D
According to Oracle documentation1, the two Oracle recommended ways to create a boardroom ready month-end reporting package for an upcoming Audit Committee meeting are using Workspace and using a report batch. Workspace enables you to assemble multiple reports into a book that can be printed and viewed individually or as an entire book. A report batch enables you to run reports at a specific time to create a set of snapshot reports. Therefore, options B and D are correct. Option A is incorrect because BI Publisher is not a tool to create financial reports. Option C is incorrect because Smartview is not a tool to create financial reports. Option E is incorrect because OTBI is not a tool to create financial reports.
1z0-1054-22 Exam Question 14
Account combinations can be created and/or modified using the Import Account Combinations file-based data import (FBDI). Which represents the appropriate upload steps?
Correct Answer: C
The Import Account Combinations process is used to create and/or modify account combinations using a file-based data import (FBDI). The appropriate upload steps are to insert rows into the GL_MULTI_COMBINATIONS_INT table using the FBDI template and then submit the Import Account Combinations process2.
1z0-1054-22 Exam Question 15
The Cloud Client wants to add a global branding logo and more predefined transactional attributes to the journal approval email notification. Which two Business Intelligence catalog objects should you copy (or customize) and edit? (Choose two.)
Correct Answer: B,C
To add a global branding logo and more predefined transactional attributes to the journal approval email notification, you should copy (or customize) and edit the layout template and the data model. The layout template is a file that defines the appearance and content of the notification, such as text, images, tables, or charts. The data model is a file that defines the data sources and queries that provide data for the notification, such as predefined transactional attributes. You can copy (or customize) and edit the layout template and the data model using Oracle Analytics Publisher reports. You do not need to copy (or customize) and edit the output type, as this is a setting that determines the format of the notification output, such as HTML or PDF. You do not need to copy (or customize) and edit the data source, as this is a component of the data model that specifies where data for the notification comes from, such as an SQL query or an XML file. You do not need to copy (or customize) and edit the sub template, as this is a file that contains reusable content or logic that can be referenced by multiple layout templates. Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional Objectives - Configure Workflow Approvals and Notifications 12
