
In this chapter, you will learn about the capabilities of Oracle Fusion Calculation Manager. You
Before defining any allocation rules, you should understand the requirement clearly. Without having clear understanding of the requirement, it will be difficult for you to define the rule correctly. In this chapter, we share with you the business need which we want to accomplish using the allocation rule. Based the business need, we will show you what setups you need to configure prior to defining the allocation rule.
After completing the required setups in previous chapter, we will show you some more setups to be completed/reviewed before defining allocation rule. Once all the setups are completed then we will define an allocation rule using allocation wizard. After defining, we will execute it and review the journal created by the allocation rule.
We have defined and successfully executed the allocation rule in last chapter. We have used accounting period as hard-coded value in the rule. In real life, user will be executing the rule on monthly basis. In that case, you would have to change the value in the rule every month which is not ideal. What if we had the option to parameterize the accounting period so that user could give the accounting period at the run time. In this chapter, you will learn about defining a parameter and using it at run time.
We also have a business challenge in this chapter which is very common. We will share the issue and also show you how to overcome that.
One of the common requirement is the reclass accounts. This is a routine monthly exercise which Accountants do for identified accounts. In this chapter, you will learn how to define the rules to do the reclass.
You will also learn how to define a rule set which can help you execute multiple rules in one go.
Oracle Fusion Calculation Manager tool is used to define allocation rules to meet various business needs to allocate balances. There are two options available in the tool to define the rules
Using Allocation Wizard
Using Formula
You can define rule using either of these options or you can use both inside a single rule. There are variety of ways you can use these combinations to achieve the required result. We have shared few commonly used requirements and necessary setups required before defining the allocation rules.
You will also learn how to define generic rules and user parameters so that same rule can be run for multiple periods without making any changes to the rule definition. Once you have many rules defined then you can define a rule set where you can combine all the rules and execute the rule set. It will internally execute all the child rules and generate allocation journals.
Based on the knowledge learnt from this training, you can start experimenting various scenarios and learn how to build rules to meet user requirements. You will also learn various problems which you will face while defining rules and also how to overcome those problems. Your level of expertise will grow based on the rules defined by you.