Oracle Planning Certification Flashcards
Which three are benefits of using EPM Enterprise Cloud Service over EPM Standard Cloud Service? (Choose three.)
A. enable pre-seeded configurable content including dimensions, models, forms, rules, dashboards, infolets, and reports for Strategic Modeling
B. with Free Form Planning, deploy Planning business processes with no dimension requirements and create business processes using Essbase outline files
C. Custom Planning, which allows a high degree of business process customization to support business requirements
D. use of the Groovy scripting language to create or customize business rules
E. deploy more than one supported business process in the same instance
B. with Free Form Planning, deploy Planning business processes with no dimension requirements and create business processes using Essbase outline files
C. Custom Planning, which allows a high degree of business process customization to support business requirements
D. use of the Groovy scripting language to create or customize business rules
What is the difference between Financials and Strategic Modeling? (Choose the best answer.)
A. There is not a technical difference, both do essentially the same thing
B. Ownership Contributions and Consolidations are out of the box in Financials
C. Strategic Modeling is broader in focus and used for long range planning
D. Financials is more summarized than Strategic Modeling
C. Strategic Modeling is broader in focus and used for long range planning
Which two client requirements align with using an ASO plan type alongside the module-based plan types? (Choose two.)
A. The client would like to plan revenue by Product and Services dimensions.
B. The client would like to report the results of the allocation process by Entity.
C. The client would like to store 10 years of actuals history for reporting purposes but only requires prior year history for planning purposes.
D. Due to sparse dimensionality, aggregation times are slow in the application.
E. The client has 10 dimensions in the application and needs to report at each intersection.
D. Due to sparse dimensionality, aggregation times are slow in the application.
E. The client has 10 dimensions in the application and needs to report at each intersection.
What would be the recommended module-based cube architecture for a company wanting to enable Financials and Capital, as well as create a Detailed Sales Forecasting cube with complex allocations and calculations, corresponding sales reporting cube, and consolidated reporting cube? (Choose the best answer.)
A. 3 BSO cubes (1 required for the modules + 2 custom BSO cubes),2 ASO cubes
B. 2 BSO cubes(1 required for the modules + 1 custom BSO cubes), 2 ASO cubes
C. 3 custom BSO cubes, 2 ASO cubes
D. 3 BSO cubes(2 required for the modules + 1 custom BSO cube), 2 ASO cubes
D. 3 BSO cubes(2 required for the modules + 1 custom BSO cube), 2 ASO cubes
For importing data from a BSO plan type to an ASO plan type, which method cannot be utilized? Choose the best answer.
A. Smart Push
B. Data Maps
C. XWRITE business rule
D. Export/Import Capabilities
C. XWRITE business rule
What does a navigation flow allow you to do? Choose the best answer.
A. Promote a plan to your supervisor
B. Display report variances by geography
C. Run multiple business rules in a predetermined sequence
D. Customize the clusters and cards that a user can access
D. Customize the clusters and cards that a user can access
Which two clients or command line tools can you download from Planning? (Choose two.)
A. Data Management
B. EPM Automate
C. Strategic Modeling Smart View add-on
D. Calculation Manager
B. EPM Automate
C. Strategic Modeling Smart View add-on
Which card allows you to enable modules? (Choose the best answer.)
Valid Intersections Data Maps Overview Settings Configure
Configure
What is the correct sequence of steps for enabling each Planning module? Choose the best answer.
Enable the module, refresh the database
Run pre-configuration tasks, enable the module, configure the module
Configure the module, refresh the database
Enable the module, configure the module, run post configuration tasks
Enable the module, configure the module, run post configuration tasks
Which three describe the supported rolling forecast time periods in Financials? (Choose three.)
4, 6, or 8 quarters 4, 12, 36 weeks 1, 2, 4, 5 years 13, 26, or 52 weeks 12, 18, 24, 30, 36, 48, or 60 months
4, 6, or 8 quarters
13, 26, or 52 weeks
12, 18, 24, 30, 36, 48, or 60 months
How do you add custom dimensions when you enable features?
(Choose the best answer.)
By adding a new dimension with Data Management
By adding a new dimension to the cube in Create and Manage Dimensions
By renaming a dimension in Map/Rename Dimensions
By creating a new dimension in Application Overview
By renaming a dimension in Map/Rename Dimensions
In order to set up weekly planning for a continuous 18 months, which three options would need to be selected when initially configuring Financials? (Choose three.)
Rolling Forecast Custom Periods Weeks to months mapping Plan Element dimension Weekly Planning
Rolling Forecast
Weeks to months mapping
Weekly Planning
Which three do you need to enable in order to perform indirect cash flow statement planning? (Choose three.)
Expense Cash Flow Statement Income Statement Balance Sheet Revenue
Cash Flow Statement
Income Statement
Balance Sheet
After enabling Financials, which three are recommended configuration tasks? (Choose three.)
Setting up exchange rates (for multicurrency applications)
Removing custom dimensions
Adding custom expense driver categories
Adding custom dimensions
Completing Planning and Forecast Preparation
Setting up exchange rates (for multicurrency applications)
Adding custom expense driver categories
Completing Planning and Forecast Preparation
A company has enabled and configured Financials. Which are three recommended post configuration tasks? (Choose three.)
Entering exchange rates
Defining and managing the accounts and drivers
Specifying days in period for driver-based Balance Sheet
Running Financials rules to aggregate and calculate the data
Setting Up Planning and Forecast Preparation
Modifying account signage for alternate reporting methods
Specifying days in period for driver-based Balance Sheet
Running Financials rules to aggregate and calculate the data
Modifying account signage for alternate reporting method
A company has enabled Financials and now would like to make changes to the initial configuration. Which three changes can be made?
(Choose three.)
Enabling Expense Enabling Income Statement Disabling already enabled features Adding custom dimensions Enabling Rolling Forecast Removing custom dimensions
Enabling Expense
Enabling Income Statement
Enabling Rolling Forecast
If you choose to create your own chart of accounts in Financials, which four statements are TRUE? (Choose four.)
Predefined drivers and the chart of accounts you brought in can co-exist within the Account dimension member outline.
You enable base or parent features to create an account structure with key members for you to add your own chart of accounts.
You cannot reuse existing integrated financial statements and must design your own financial statements that include the accounts you imported.
You do not need to enable base or parent features, and instead import the metadata directly into the Financials cube.
You can perform calculations using existing rules, and plan using existing forms and dashboards.
You input or import your own accounts for each enabled feature.
Predefined drivers and the chart of accounts you brought in can co-exist within the Account dimension member outline.
You enable base or parent features to create an account structure with key members for you to add your own chart of accounts.
You can perform calculations using existing rules, and plan using existing forms and dashboards.
You input or import your own accounts for each enabled feature.
Which three Financials members within the Plan Element dimension allow for forecast and plan data entry? (Choose three.)
OFS_Trend OFS_Form Entry OFS_% Increase/(Decrease) OFS_Input OFS_Direct Input
OFS_Trend
OFS_% Increase/(Decrease)
OFS_Direct Input
Which three metadata artifacts can be exported to a flat file?
(Choose three.)
A. Exchange Rate Tables B. Dimensions C. Smart Lists D. Linked Reporting Objects E. Data Entry Forms
A. Exchange Rate Tables
B. Dimensions
C. Smart Lists
Which two delimiters are supported when creating a metadata import file? (Choose two.)
A. Percent sign
B. Forward slash
C. Tab
D. Comma
C. Tab
D. Comma
Dimensions can be added by which of the following actions? (Choose 3)
Renaming a dimension in the Map/Rename Dimensions section during enablement of a framework
Creating a new dimension through Application Overview for custom cubes
Adding a new dimension by loading it in Data Management
Adding a new dimension to the cube through Create and Manage Dimensions for custom cubes
Renaming a dimension in the Map/Rename Dimensions section during enablement of a framework
Creating a new dimension through Application Overview for custom cubes
Adding a new dimension to the cube through Create and Manage Dimensions for custom cubes
To assign Workforce resources to initiatives, which default custom dimension is required in the Map/Rename Dimensions section? (Choose the best answer.)
A. Project
B. Program
C. Elective
D. Measure
Project
In order to be able to configure Additional Earnings in the Benefits and Taxes wizard, into which dimension do you have to import members? Choose the best answer.
A. Pay Type
B. Property
C. Component
D. Account
C. Component
When calculating a tiered type of tax, what should be the selected ‘Maximum Value Type’? (Choose the best answer.)
A. Threshold Amount B. Percentage of Overall Earnings C. Percentage of Salary D. Percentage of Taxable Earnings E. Flat Amount
A. Threshold Amount
When loading Salaries into Workforce, which Property should the values be loaded to? (Choose the best answer.)
A. OWP_Gross Earnings
B. OWP_Salary Basis
C. OWP_Value
D. OWP_Expense Amount
B. OWP_Salary Basis
Which three are predefined Workforce business rules? (Choose three.)
A. Transfer B. Plan Departure C. Promote Employee D. Change Job E. Remove Existing Employee
A. Transfer
B. Plan Departure
D. Change Job
When loading Employee data into Workforce Business Process, which month should the data be loaded into?
A. &OEP_FcstMnth
B. &OEP_CurMnth
C. &OEP_StartMnth
D. &OEP_EndMnth
B. &OEP_CurMnth
What step is NOT required to calculate Merit dollars for each Employee within the Workforce framework?
A. Enter or Load a Merit Override Rate.
B. Enter or Load a Merit Month by employee.
C. Enter or Load a Performance Metric by employee.
D. Ensure there is a Merit Rate for each Performance Metric and component definitions have been updated
E. Execute the calculate Compensation Business Rule
A. Enter or Load a Merit Override Rate.
After loading Workforce data from external systems, which two statements describe actions you can take to process Workforce data? (Choose two.)
If an existing employee was omitted from the load file, you can add that existing employee in Workforce. Then assign properties and compensation options for that employee.
To calculate updated compensation data after changing benefit options and rates from the loaded file, first change the benefit options and rates in Workforce and then run the Calculate Compensation business rule.
If an existing employee was not loaded from the load file, you won’t be able to add their compensation information before first adding them to the source system and reloading the file.
Because you cannot override loaded default assignments in Workforce, change the defaults in the load file and reload it.
To override loaded default assignments, change them in Workforce. After saving your changes, updated compensation data is calculated.
To calculate updated compensation data after changing benefit options and rates from the loaded file, first change the benefit options and rates in Workforce and then run the Calculate Compensation business rule.
Because you cannot override loaded default assignments in Workforce, change the defaults in the load file and reload it.
Which two methods can be used to push data between cubes?
(Choose two.)
A. Data Management
B. Import Data
C. Data Maps
D. Copy Data
Data Management
Data Maps
Which three items would be in appropriate use case for “Data Management” in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose three.)
An organization requires the ability to provide “Drill-back” capabilities.
An organization requires the ability to load data to their application via flat files.
An organization requires the ability to build dimension hierarchies
An organization requires the ability to process data from multiple chart of accounts
An organization requires the ability to build custom calculations
An organization requires the ability to provide “Drill-back” capabilities.
An organization requires the ability to load data to their application via flat files.
An organization requires the ability to process data from multiple chart of accounts
An organization adds a dimension to their ePBCS Planning application. Assuming that Data Management is being utilized, which step would need to be executed?
Navigate to the Import Format screen in Data Management. Select the Import Format for the EPBCS application. Run the “Refresh Members and Metadata” action to update dimensions.
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Members and Metadata” action to update dimensions.
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Metadata” action to update dimensions.
Navigate to the Application Dimensions screen in Data Management. Refresh dimensions using “Update Application” action.
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Metadata” action to update dimensions.
Where would you navigate in Data Management to map source data to target scenarios?
A. Category Mapping
B. Target Application
C. Import Format
D. Data Flow Mapping
A. Category Mapping
