Batch Scripts: Creating XML files for Runtime Prompts

, , ,

When automating Business Rules through batch scripts, an XML file is needed to state the runtime prompts. This is how the batch script will know which members to run the business rule for. Is there an easy way to create these files?

Luckily, it is fairly simple to create these XML files and reference them from the batch script. First, to create an XML file directly from a Planning application, go to Tools -> Business Rules:

Once the business rule page opens, use the 2 dropdown menus at the top of the page to narrow down the list of available business rules:

Select the relevant business rule, and click on the launch button on the right side of the window. In this example, I want to create an XML file for the business rule, “CurrConvAdmin”:

This rule has 3 runtime prompts (Scenario, Year, & Version). Select the 3 members for the prompts and click “Create runtime prompt values file” in the bottom right of the pop-up window:

The following screen will appear, confirming that the file was created successfully:

Now, we need to go and find where the XML file was saved so that we can reference it in our batch file. From the Foundation server (or the server that Planning is on), go to the following path:

D:\Oracle\Middleware\user_projects oundation1\Planning\planning1\RTP

All of the XML files will be created under your username within the RTP folder:

Right click to edit the file, and notice that all 3 runtime prompts are accounted for in the file:

In the batch command itself, the XML file is referenced as follows:

Here is the default syntax for referencing a business rule via batch scripts:

CalcMgrCmdLineLauncher.cmd [-f:passwordFile] /A:appname /U:username /D:database [/R:business rule name | /S:business ruleset name] /F:runtime prompts file [/validate]

And here is the full documentation on the business rule syntax from Oracle: http://docs.oracle.com/cd/E1723601/epm.1112/hpadmin/frameset.htm?ch06s09s05.html

I’ve noticed that it is best to create the XML files directly from Planning, rather than trying to create them manually. When manually created, the batch command won’t always recognize the format of the XML file, even if it looks the same to what is created via Planning. It only takes a couple of extra minutes, but will save you from some headaches down the line.

 
5 replies
  1. Karthiga Devi. R says:

    We want to assign a dynamic value for runtime prompt. Please suggest developing codes for picking the exact value dynamically without manual intervention.

     
    Reply
    • Kyle Goodfriend says:

      Without knowing how you want to pick them it would be difficult to suggest something meaningful. If you can detail out an example, it would help.

       
      Reply
  2. Prabakaran says:

    Hi,
    I am planning to automate EPM Workpsace login in EPM 11.1.2.4 On Premise.
    I have checked multiple oracle documents but all are mentioned EPM automate utility available only for 11.1.2.4 cloud.
    May I know EPM Automate Utility available or not for 11.1.2.4 on premise or How will i automate the EPM workspace login in 11.1.2.4 on premise?
    Could you please confirm and provide me any inputs or solution.
    Advance Thanks!!

     
    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply to Prabakaran Cancel reply

Your email address will not be published. Required fields are marked *

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