Thursday, November 3, 2016

How to schedule Business Rule to launch through the Planning Utility

Say you have to schedule a Business rule to run nightly in version 11.1.2.3.700

It being version 11.1.2.3, we have Calc Manager to handle the Business Rules - remember no EAS BRs.

In this version there is a utility - "CalcMgrCmdLineLauncher.cmd" in the Planning1 folder (D:\oracle\Middleware\user_projects\epmsystem2\Planning\planning1)

So, in order to run the Business Rules, we can go to the Planning1 folder and run "CalcMgrCmdLineLauncher.cmd /A:AppName /U:admin /D:DatabaseName /R:BusinessRuleName /Validate"
Validate if optional for validation.
In this case, we will be prompted for a password.
We can also use Password encripted file with "-f" syntax, which would look something like this
CalcMgrCmdLineLauncher.cmd -f:D:\oracle\Middleware\user_projects\epmsystem2\Planning\planning1\passwordFile /A:AppName /U:admin /D:DatabaseName /R:BusinessRuleName

This script can be scheduled by including the lines in a batch script.
Create a batch file and include the lines ---
call D:\oracle\Middleware\user_projects\epmsystem2\Planning\planning1\CalcMgrCmdLineLauncher.cmd -f:D:\oracle\Middleware\user_projects\epmsystem2\Planning\planning1\passwordFile /A:AppName /U:admin /D:DatabaseName /R:BusinessRuleName