[Intro Music] Welcome to this step-by-step tutorial on managing rules in Oracle Profitability and Cost Management Cloud. Calculations control how costs and revenues are assigned from a source to a destination as the funds flow through the application. You set up calculations for a POV by creating rule sets and then adding rules.
In this tutorial, we’ll create rules. You can see how to create rule sets in our Managing Rule Sets tutorial. For more information on how calculations work, please see our Calculation Overview video.
I’ll open the Manage Rules screen. I want to perform a series of calculations to reassign occupancy expenses from corporate, where the expenses are paid, to the cost centers that use the facilities. I’ve already created a rule set to group those calculations together.
Let’s see how to define rules. I’ll add an allocation rule to the Occupancy Expense Allocations rule set. Allocation rules determine how allocated data flows and how to determine the allocation amount.
I’ll add a name and description, and enable the rule. This rule will allocate rent and utility expenses from the Corporate cost center to business function cost centers, based on the square footage used by each cost center. Notice that Use Rule Set Context is selected by default.
To simplify rule creation, you can set dimensional context at the rule set level, so that it applies to every rule in the rule set. For example, only the Entity and Account dimensions are relevant to the rules in this rule set, so the rule set context sets the other dimensions to no member. Next, let’s define the source for the allocation.
I’ll use member selection to define the source as the intersection of the Facilities account and the Corporate cost center. Next, let’s define the destinations for the allocation. Instead of selecting an account, I’ll select Same As Source to use the Facilities Expenses account again.
When I select entities, I’ll select the business function cost centers, like Facilities, Sales, Manufacturing, and so on. Notice that the system shows an estimated destination count, which is a useful crosscheck against writing rules that are too expansive. The more destinations, the longer your calculation takes.
Next, let’s define the allocation driver basis. You can specify a driver, or allocate the source evenly to the destinations. In this example, the allocation is based on the value in the Occupancy Square Feet account for each cost center, as a percentage of the total for all the destination cost centers.
On the Offset tab, you can control where the offsetting, or balancing, entry is logged. And on the Rule Context tab, you can see the dimensional context derived from using the rule set context and global context. I’ll save the rule.
In addition to allocations, you can also create custom calculations. Custom calculation rules enable you to define calculations to be performed in a certain region of the database. They are used primarily to create what-if scenarios by adjusting existing data, create custom driver values for use in allocation rules, or to accommodate specific reporting requirements.
For this example, I’ll create a custom calculation to increase corporate utilities expenses by 15%. Next, let’s specify the target for the calculation. The target defines the range over which the formula is executed.
The Balance dimension is the system dimension where allocation results are stored, and is also the default selection for storing custom calculations. I’ll specify the Utilities account and the Corporate entity. Notice that Utilities is a subaccount of the Facilities Expenses account we used in the allocation rule earlier.
Next, let’s define the formula. In this example, the formula uses members from the system dimension, Balance, to record an adjustment. I’ll validate the formula, and save the rule.
Notice that both rules in this set have the same sequence. I want to adjust the utilities expenses before I allocate, so I’ll change the sequence for the allocation rule to 2. Finally, I’ll save and resort my rules to see them in sequential order.
When you run your calculations, the system assigns rule numbers to your rules, for tracking purposes. In this tutorial, you saw how to manage rules in Oracle Profitability and Cost Management Cloud. To learn more, visit cloud.
oracle. com.