Which three reporting tools are based on real-time data or balances?
A. Oracle Business Intelligence Applications (OBIA
B. Smart View
C. Business Intelligence Publisher (BI Publisher)
D. Oracle transactional Business Intelligence (OTBI)
E. Oracle Financial Reporting (FR)
What type of user must be defined before you can create an Implementation Project?
A. None. The Fusion Applications Superuser, FAADMIN, has full access to create an Implementation Project.
B. A full-time employee that has the FSM Superuser role assigned
C. None. The OIM system administrator user ID, XELSYSADM, which is assigned by the person provisioning the system, has full access.
D. Implementation Users
E. All roles that will be used throughout the implementation
You want to display OTBI reports and graphs in PowerPoint to show general ledger or subledger data.
How do you accomplish this?
A. Download OTBI reports and charts to a spreadsheet and then copy and paste the spreadsheet to PowerPoint
B. Use SmartView to create reports and charts using general ledger and subledger subject areas embed the charts/reports into PowerPoint
C. Use Smart View and Oracle BI EE View Designer to create reports in PowerPoint, Word, and Excel.
D. Use Account Inspector and then export to Excel and copy and paste into PowerPoint.
Your customer wants to create fully balanced balance sheets for the Company, Line of Business, and product segments for both financial and management reporting.
What is Oracle's suggested best practice for doing this?
A. Create a segment that acts as the primary balancing segment and create values that represent a concatenation of all three business dimensions.
B. Use account hierarchies to create different hierarchies for different purposes and use those hierarchies for reporting.
C. Create three segments and qualify them as the primary balancing segment, second, and third balancing segments, respectively.
D. Create two segments where the first segment represents the concatenation of Company and Line of Business, and then enable secondary tracking for the Product Segment.
Your customer wants to control spending against an annual budget but report balances on a monthly yearto-date basis. Encumbrance accounting is also in use.
What setup is required to achieve this requirement?
A. Create an annual budget with absolute control and so encumbrance accounting will work.
B. Create a summary budget annually with advisory control and control budget monthly with absolute control.
C. Create a Summary budget annually with absolute* control and monthly control budget with advisory or track control.
D. Create two detail control budgets: annually with absolute control and monthly with advisory or track control.
E. Create two detail control budgets: annually with advisory/track control and monthly with absolute control.
Journal approval uses Approvals Management Extension (AMX).
Which AMX builder method is most effective in routing the journals to the Accounting Manager when the General Ledger Accountant enters the journal?
A. Supervisory level based on HR Supervisors
B. Job level
C. Position
D. Approval Group
Your customer has enabled budgetary and encumbrance controls at the requisition level. You have a purchase order for $1,000 USD, which is fully reserved and has one invoice for $600 USD. When the purchase order is matched through the final match process, the purchase order is closed for further invoicing.
What happens to the remaining $400 USD?
A. Invoice type will have less funds available by $400 USD.
B. Manual encumbrance journal needs to be entered In General Ledger to release the budget amount of $400 USD.
C. Only obligation type will have $400 USD funds available.
D. $400 USD will be added back to available funds
E. $400USD will be expired and not available for use.
Your customer is expanding its operations. You defined a new ledger and several business units. However, you are unable to assign the newly generated data roles to existing Accounts Payables and Accounts Receivables users in the shared service center.
What should you do to correct the problem?
A. Open the Oracle Identity Management (OIM) and make sure the data roles were created.
B. Open the Manage Users page and make sure the employees at
C. Open Access Policy Manager (APM) and assign the roles manually
D. Make sure you run the Retrieve Latest LDAP Changes program to regenerate the data roles.
On which three occasions are Essbase balances updated?
A. Every time the tree version is published
B. Every time journals are posted to the general ledger
C. Every time you run the batch program called "Update Essbase Balances"
D. At report run-time
E. Every time you open a new period
You want to define a tree or hierarchy for use in reports and allocations. What three aspects should you remember when creating the tree?
A. You need to flatten the rows to be able to use drilldown in Smart View and you must publishtree to view the hierarchy in Essbase cubes.
B. You must flatten the columns and publish the tree to view the hierarchy in Essbase cubes.
C. The tree should have at least two tree versions to reduce report and allocation maintenance.
D. You only need to flatten the columns if you plan to use the hierarchy in Oracle Transactional Business Intelligence (OTBI).
E. It is fine to have the same child value roll up to two or more different parent values.
