Question 1

Which client requirement aligns with using a custom BSO plan type along with or in place of the Workforce module?

Accepted Answer

E

Explanation: The pre-built Workforce module in Oracle EPM Planning is designed with a specific, fixed dimensionality, which includes a limited number of custom dimensions (typically two). A primary driver for creating a custom BSO (Block Storage Option) plan type is when a client's business requirements for workforce planning exceed these structural limitations. If a client needs to plan and analyze workforce data by more than the available custom dimensions (for example, by Project, Skill Set, and a custom Geography dimension), the standard Workforce module cannot be configured to accommodate this. A custom BSO plan type provides the necessary flexibility to design a cube with any number of required dimensions.

Question 2

You want to create dashboards with Dashboards 2.0. Which two statements are true about designing in Dashboards 2.0?

Accepted Answer

A, D

Explanation: Dashboards 2.0 in Oracle Planning enhances visualization capabilities. It supports a wide array of advanced chart types, including Waterfall, Pyramid, and Geomap, along with new sub-types for Radar, Combination, and Gauge charts, providing more sophisticated data representation options. When designing a dashboard, there is a structural limit allowing for a maximum of 12 components, which can be a mix of charts, forms, or other elements. These two facts are key design considerations for building effective dashboards in the platform.

Question 3

A company would like to configure Financials, Workforce, and Projects. They would like to plan and
forecast the Project dimension in Financials, as well as track employee utilization in Projects.
Which two actions must they take to ensure that the Project dimension is shared and the data
integrated correctly across all three modules? (Choose two.)

Accepted Answer

B, C

Explanation: To achieve the goal of tracking employee utilization in Projects, data must be integrated from the Workforce module. This requires two fundamental configurations within Workforce. First, the Workforce module must be configured at the 'Employee' or 'Employee and Job' granularity (C) to capture the necessary level of detail for individual employee costs. Second, to associate these costs with specific projects, the Project dimension must be shared with the Workforce module. This is accomplished by enabling a custom dimension in Workforce and renaming it to "Project" (B). These two actions are co-requisites for enabling the data flow from Workforce to Projects for utilization tracking.

Question 4

Your administrator creates a Pipeline definition to manage metadata, and data for your Planning application. Which statement about pipelines is true?

Accepted Answer

C

Explanation: Pipelines in Oracle EPM Cloud Planning are a feature designed for process automation. They allow administrators to define and coordinate a sequence of jobs, such as data loads, metadata updates, and business rule executions, to run as a single, cohesive process. This enables the automation of complex, multi-step tasks, ensuring that jobs are executed in the correct order without manual intervention. A pipeline consists of stages, and each stage contains one or more jobs that can be run sequentially or in parallel, streamlining administrative workflows.

Question 5

Which two are use cases for Smart Push?

Accepted Answer

A, C

Explanation: Smart Push is a feature in Oracle Planning that facilitates the real-time movement of data between cubes. Its primary use case is to push data from a source Block Storage Option (BSO) cube, where users input data via a web form, to a target cube, which is often an Aggregate Storage Option (ASO) cube used for reporting. This process can be configured to run automatically when a user saves data in a form, ensuring the reporting cube is immediately updated (A). Alternatively, it can be configured to run on-demand, allowing users to trigger the data push manually from the form's action menu when they are ready (C).

Question 6

Which statement is true about configuring Projects with Capital?

Accepted Answer

A

Explanation: When configuring the Projects business process in Oracle Planning, you can enable different project types. If you choose to enable capital project planning, there is a direct dependency on the Capital business process. The Capital module provides the necessary framework for managing capital assets, calculating depreciation, and handling other capital-expenditure-related logic. Therefore, to plan for capital projects within the Projects module, the Capital module must also be enabled and configured to support these functionalities.

Question 7

A company has enabled Financials and would now like to make changes to the initial configuration. Which three changes can be made?

Accepted Answer

A, B, F

Explanation: After the initial configuration of the Oracle EPM Cloud Financials business process, administrators retain the flexibility to make several key changes to adapt to evolving business needs. It is possible to add new custom dimensions to the application to allow for more granular planning and analysis. Existing custom dimensions can also be renamed to improve clarity or align with updated business terminology. Additionally, forecasting capabilities can be enhanced by enabling features like a rolling forecast, which was not part of the initial setup.

Question 8

Which two types of Groovy Rules are supported by Oracle?

Accepted Answer

B, C

Explanation: Oracle EPM Cloud Planning officially supports two primary types of Groovy business rules. The first type (B) involves using Groovy to dynamically generate and execute a targeted Essbase calculation script at runtime. This is powerful for creating highly efficient calculations based on the current context, such as runtime prompts (RTPs), the user's point-of-view (POV), or the specific data cells being modified in a form. The second type (C) involves using Groovy's programming capabilities to perform complex data validations, manipulations, or to orchestrate multi-step processes. These rules can run before or after a data form save, check the entered data against business policies, and cancel the operation with an error message if validation fails.

Question 9

Which two statements are true about approval units?

Accepted Answer

B, C

Explanation: An approval unit is the fundamental component of the Oracle Planning approvals process. Its definition is a specific combination of a scenario, a version, and a member from a primary dimension, which is typically the Entity dimension. This combination creates a unique data slice for review and sign-off. To allow for more granular control over the budget or forecast review, the approval unit hierarchy can be further refined by including members from other, secondary dimensions. This enables approvals at a more detailed level, such as by department within an entity.

Question 10

Which three features would you need to enable in order to perform indirect cash flow statement planning?

Accepted Answer

A, B, D

Explanation: To perform indirect cash flow statement planning within Oracle's Financials module, you must enable the Income Statement, Balance Sheet, and the Cash Flow Statement features. The indirect method for calculating cash flow begins with Net Income, which is derived from the Income Statement. It then adjusts for non-cash items and changes in working capital (e.g., accounts receivable, inventory, accounts payable), which are tracked on the Balance Sheet. Enabling the Cash Flow Statement feature itself is necessary to perform the consolidation and view the resulting statement. The system enforces this dependency by automatically selecting the Income Statement and Balance Sheet when the Cash Flow Statement is enabled.

Question 11

In Strategic Modeling, you set up the Change in Inventory due to Non-Cash Activity account and
provide more detailed accounts below that account. The account number is v2040.35:010. The main
account is 2040. Which two statements about setting up accounts in Strategic Modeling are true?

Accepted Answer

C, D

Explanation: In Strategic Modeling, the chart of accounts is customizable. You can add new accounts as siblings to existing main accounts to expand the financial model's structure. This is a standard method for tailoring the model to specific business needs. Furthermore, the model uses a hierarchical structure where subaccounts inherit the properties and attributes (such as account type, data type, and calculation logic) of their parent main account. This inheritance is fundamental for maintaining consistency and simplifying configuration, and it applies across all time periods, including both historical and forecast data.

Question 12

In Capital, which three statements are true when performing lease asset planning using the IFRS 16 and ASC 842 standards?

Accepted Answer

A, B, E

Explanation: According to Oracle's documentation for the Capital module, the system determines if a lease asset qualifies as low value using a specific process. First, it calculates a value by multiplying the 'Lease Payment' by the 'Payment Frequency' (A). This calculated value is then compared against a pre-configured threshold, the 'Low Value Lease Amount'. If the calculated value is less than or equal to this threshold, the asset is classified as a low value lease asset (B). Furthermore, the documentation confirms that planners have the ability to manually override the system's classification by setting the 'Low Value Lease property', thereby forcing an asset to be treated as a low value lease, which is the functionality described in (E).

Question 13

You want to create a dashboard to provide an overview at the beginning of the planning and forecasting process. You create a dashboard with Dashboard 1.0. Which three statements are true about Dashboard 1.0?

Accepted Answer

B, C, D

Explanation: Dashboards 1.0 in Oracle Planning provide a flexible interface for creating interactive overviews. They allow designers to easily toggle between the design and runtime environments to build and test the user experience. A key feature is the ability to integrate up to six forms and six charts, where the charts can be linked to forms and update dynamically as data changes. To personalize the user's view, Dashboards 1.0 support the use of user variables in both the global Point of View (POV) bar, which affects the entire dashboard, and the local POV for individual forms or charts.

Question 14

You are preparing to design a report in Cloud EPM Planning using Report Designer. Which two statements are true about data sources in reports?

Accepted Answer

B, C

Explanation: In the Oracle EPM Cloud Report Designer, a chart's data is derived from a grid. A key feature is the ability to display the chart visualization while hiding the underlying data grid from the report output, which is useful for creating dashboards and visual summaries. Additionally, the designer provides granular control over the layout and positioning of all report objects. You can set an object's position relative to the page or to other objects, ensuring a precise and professional report layout for both screen viewing and printing.

Question 15

Which two are true regarding rent-free periods with IFRS 16 enabled?

Accepted Answer

B, D

Explanation: Under IFRS 16 within Oracle Lease Accounting, a rent-free period is configured by creating a payment schedule line for the specific interval and setting the payment amount to zero. The system's core calculation engine for the Right-of-Use asset and Lease Liability amortization is fundamentally driven by the defined lease periods (e.g., monthly, quarterly) and the payment frequency. The rent-free period is simply one or more periods within this structure where the payment is zero, while interest accretion and asset amortization calculations continue as normal over the entire lease term.

Free Oracle 1Z0-1080-25 Actual Exam Questions