Monday, December 22, 2014

Business Rule Migration from One Server to Another using Export Import in EAS.


Business rule  Migration from one Server to Another using Export Import in EAS

When we export the Business Rules (BR's), EAS exports the BR's in a xml file format, this xml files contains all the BR's, Security (if you are not exporting for Calc Manager), locations etc. Now if we are trying to migrate the BR's from say Production to Development environment, we have to update the location of the BR's in the xml file because when we export our xml file, it have the location of BR's of Production Server and here we are trying to migrate the rules to Development, so we need to update the xml and modify the location of these BR's.

Here are the steps to export and import rules from one server to another:

1. Log into EAS console of Source Environment using an admin id.
2. Right Click on Business Rules Node.
3. Click on Export.
4. In the right hand pane you will get all the BR's listed. Click on Select All.
5. Uncheck For Calc Manager.
6. Click on Dependents.
7. Export the rules.
8. This will ask to save the BR's in a XML format, save the xml file.
9. Save As the xml file with a different name.
10.Edit the xml file and replace all the Old locations of BR's with the new one, the location is case sensitive and there will be two location we need to replace small case with the small one and Upper case with the Upper one, 
Ex: A part of exported .xml
Source .xml:
<Location>
<property class="int" method="setLocID" value="41"/>
<property class="int" method="setLocationID" value="41"/>
<property class="java.lang.String" method="setLocation" value="ProdClusterMXYZ"/>
<property class="java.lang.String" method="setUpperLocation" value="PRODCLUSTERMXYZ"/>
<property class="int" method="setCluster" value="-1"/>
</Location>

Say if our Destination Location is: "Planning/WDEPMR0543/PLAN/XYZ"

In this case in your source file replace All:

ProdClusterMXYZ with Planning/WDEPMR0543/PLAN/XYZ

PRODCLUSTERMXYZ with PLANNING/WDEPMR0543/PLAN/XYZ

12. Save the file.
13. Login to the destination EAS console.
14. Right click on Business Rule node.
15. Import the BR's using the modified .xml file.

Hope this Helps.

Greetings
SST!

No comments:

Post a Comment

Oracle Planning and Budgeting Cloud (PBCS) - August 2018 Updates

The following announcements and considerations are outlined in the upcoming  Oracle Planning and Budgeting Cloud (PBCS)  update: Oracl...