EPBCS Series: Configuring Frameworks

Today let’s look at the basics of configuring frameworks in EPBCS.

To recap, there are currently 4 frameworks that come out of the box with EPBCS when you enable the Enterprise application type:

  1. Financial Statement Planning (“Financials”)
  2. Workforce Planning (“Workforce”)
  3. Capital Asset Planning (“Capital”)
  4. Project Financial Planning (“Projects”)

Taken directly from the Oracle EPM cloud Enterprise Planning Cloud website:

  • Financial Statement Planning will give customers the ability to plan and forecast revenue and expenses, as well as map to an Income Statement, Balance Sheet, and Cash Flow.
  • Workforce Planning allows for compensation planning as well as strategic workforce planning.
  • Capital Asset Planning allows customers to manage new capital investments and existing assets, as well as intangibles.
  • Project Financial Planning allows for streamlined and detailed project planning, in addition to the ability to monitor project performance.

Each framework has it’s own set of pre-configured objects, including dimensions, forms, calculations, dashboards, navigation flows, etc. However, customers can also build in their own metadata and customize copies of the pre-configured components so that they’re not completely forced into using what comes out of the box. These frameworks can be ignored completely, enabled one at a time, all at the same time (but in queue), or several at a time (but in queue). This flexibility allows customers to choose what they want and when they want it.

So how do you enable and configure a framework? Within the Console card you’ll find a tab called “Configure” which is purpose built for enabling frameworks, adding on options, and maintaining other items necessary for frameworks. Configurations must occur after an application has been created, and they must be completed in queue.

Within the Configure area, you’ll notice that there’s a drop-down at the top where you can choose one of the 4 frameworks to enable. Highlight one and then press the Enable Features button at the bottom.

Configuring Frameworks 10

Each framework has its own set of configuration options.  Here are the options for the Financials framework:

Configuring Frameworks 11 Configuring Frameworks 12

Note that I’m randomly picking options for the screenshots in this blog post without putting much thought into them. However, I did change the default Product dimension to a different name, “Project”. This would be important if you were planning to configure the Projects framework and wanted to reuse the Project dimension in your Financials planning process. It’s a good idea to learn all of the default dimensions up front so that you keep your names congruent throughout the application.

Most framework options do not require enablement up front – they can wait until later if you’re not sure. However, you can’t disable something that you’ve already enabled. So you’ll need to understand your options up front and decide carefully. Note that this area is for creating additional custom dimensions and/or renaming the default dimension names that come with the framework.

Due to the project I’m supporting, I’ve been playing with the Financials framework for weeks and have enabled this one at least a dozen times in the many iterations of the application I’ve created and blown away. I know that it takes 5-7 minutes to enable. I also know that if you don’t make sub-selections for each option up front, you can corrupt your application (and without warning). For instance, if I select the “Revenue/Gross Margin” option but then don’t select one of the categories, I won’t get an error. I can even choose to enable the framework without error. However, it won’t complete successfully. The application becomes unstable when the application doesn’t complete successfully multiple times. I hope Oracle puts in some better and proactive warnings for users. It seems like an easy feature that they can add to the interface.

Once you’ve fully enabled a framework, you should receive a successful notification. You are also asked to log out and log back in to see all of the new application features.

If you go back into the Application area within the Console card you’ll see a new cube called “OEP_FS” added to the list as a result of enabling the Financials framework:

Configuring Frameworks 12b

This cube has a reserved name that cannot be changed. There are many reserved names within the frameworks, in fact. The name of each framework’s cube is important because many predefined framework member names (and other components) are prefixed with the same name. Since they’re all housed together, this is key for keeping it organized in your head.

Let’s pause now for a moment and take a deeper look into the Financials framework. I’ll do this for this framework (especially since I’m partial to this one), but then cover the 3 remaining frameworks at a high level.

When you go back into Configure and look at the Financials screen, here’s what you can configure now after the initial enablement:

Configuring Frameworks 13

If you want to go back and configure options that you didn’t enable the first time around, you would press the “Enable Features” button in the upper right-hand corner. Note that you can continually enable new features until you run out. However, there are objects that get created with each option (metadata, forms, etc.) that you’re not allowed to delete once they’re enabled. Since you can’t disable features, it’s better to be conservative up front.

The Configure area will become familiar to you as you will perform regular maintenance here (especially in “Planning and Forecast Preparation”). The Revenue Accounts, Expense Accounts, Entities, and Project options allow you to configure metadata. These screens are not to be confused with the dimension administration area, however, although they seem similar. For instance, here’s the Revenue Accounts window:

Financials - Revenue Accounts

Here, you can see the predefined members for certain sections of the Account hierarchy and can change their aliases (but no other properties).

And here’s what that same cross-section of accounts looks like in the Account dimension administration area:

Financials - Revenue Accounts Dim Maintenance

Continuing on with the detailed look, here’s an overview slide show of the predefined dimension members that were added to this cube. Some of the dimension members (e.g. Account) will change based on the framework options that I selected for enablement:

This slideshow requires JavaScript.

And here’s a slide show of the different Planning components that were generated upon enabling the Financials framework:

This slideshow requires JavaScript.

Next, let’s configure the Workforce framework:

Configure Workforce

Note that I’m choosing to configure these frameworks in the drop-down order. You can go in any order you want. However, there are some framework options that depend on the configuration of the other frameworks. Therefore, you can save some time by following the drop-down sequence. Here are the options for the Workforce framework:

Configuring Frameworks 18

This framework took over 8 minutes to enable. After enablement, I can see 3 new cubes (plus many other components) added to the application:

Cube list - after Fin and Wkfrce

Next, let’s enable the Capital framework:

Configure Capital

Here are the options for this one:

Configuring Frameworks 20

This one took almost 9 minutes to configure. One new cube was added to the application list:

Cube list - after Fin and Wkfrce and Capital

Finally, let’s configure the last framework, Projects:

Configuring Frameworks 14b

Here are the options for this framework:

Configuring Frameworks 21Configuring Frameworks 22

This one took over 15 minutes to configure. It’s taking longer and longer to configure each new framework.

When I’m done enabling all 4 frameworks, here is what my final cube list looks like with the new cube for Projects added:

Cube list - after all 4 frameworks

In the end, it took me over 45 minutes to enable all 4 frameworks. I would expect this process to take more time in the real world, as each option would be evaluated in detail first.

Tomorrow we’ll examine the concept of rolling forecasts in EPBCS.

10 thoughts on “EPBCS Series: Configuring Frameworks

  1. MD says:

    Which cube should you use for Financials the Planlnp you created or the OEP_FS ? Do you use your created cube for the default cube for accounts, data forms etc or the delivered OEP_FS. Thanks .


    • OpaL says:

      I’m not sure I fully understand the question. EPBCS has the flexibility to use both the out of the box frameworks or your own custom plan types. It depends on which architecture design you’re going for. If you intend to use the out of the box framework for Financials then your design would primarily use OEP_FS, which is what it is tied to. The out of the box objects (forms, calculations, etc.) are also integrated with this cube.


      • MD says:

        Ok. I am just confused why you created another plan type and what it could be used for? So if i wanted to utilize the business process, i should make sure that i use OEP_FS. Also how do you link the reporting cubes with either plan type?Thanks for your feedback.


        • OpaL says:

          Ah, I see. The creation of those other cubes was a forced option back when I wrote this post. The initial application creation required at least two cubes be created immediately, regardless if they were going to be used: 1 BSO and 1 ASO. Now, depending on which application type you create in EPBCS only one reporting cube (ASO) must be generated at application creation time or two (both BSO and ASO). Human Capital types required one. Finance types require two.

          When you enable and configure any framework, the cubes tied to those will be auto-generated behind the scenes. You can tie the data flow between cubes using data management, XRef, data maps, etc. – there are multiple options for moving data between them.

          Thank you for asking the question! I can see why that screenshot would be confusing.


    • OpaL says:

      It’s a dimension that is mainly used for calculations and is a key for data seeding to drive calculations. It is recommended not to be modified. Examples of members: taxable compensation, gross earnings, etc.


  2. David Corredera says:

    Do you know what are the “location aliases” for each predefined cube? (Financials, Capital Expenditure, Human Resources, etc.)
    Thanks in advance.


    • OpaL says:

      You can see them from Calculation Manager | Actions | Database Properties | (right click any cube) | Location Aliases. The entire list will show and note that you will not be able to rename them. You can even export the list.


Let it out here

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.