My Oracle Support Banner

Moving Rules Engine Data Between Databases (Doc ID 1623090.1)

Last updated on APRIL 23, 2021

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
PeopleSoft Enterprise CS Campus Community - Version 9 and later
PeopleSoft Enterprise CS Academic Advisement - Version 9 and later
Information in this document applies to any platform.


PeopleSoft Enterprise Campus Solutions Rules Engine enables you to create custom evaluation and calculation logic which can be applied to any data within the application without a customization to delivered codeline. 

Oracle delivers Rules Engine setup data for rules and related objects as System Data. This predefined system data is made available via DataMover scripts and data files (dat and dms files).

It is expected that customers will create their own rules and related objects in a test environment before migrating to production.  Because the setup is extensive, repeating it in each environment would be a daunting task.  The following set of instructions may be used to assist with the migration of Rules Engine setup data and related objects between environments


The process of migrating Rules Engine Data includes two steps:

1. Exporting Rules Engine Data: Create an export DataMover script that will create a DataMover .dat file to export data from the source database

2. Importing Rules Engine Data: Create an import DataMover script to import the data in the .dat file to the target database

After Rules Engine data is migrated, it is necessary to migrate the Entity Registry Items used by the Rules Engine.  For instructions on migrating Entity Registry Items please see the following KM article: Moving Entity Registry Data Between Databases [Doc ID 1623119.1]

These instructions are accurate as of Campus Solutions Bundle 9 #31, Patch 17212183.  Please consider setting this document as a Favorite and review the document after each new bundle application.  It will be updated accordingly if any changes occur in the record structures that require changes to the scripts.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Exporting Rules Engine Data
 Importing Rules Engine Data

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.