Migrate Totals and Rules (sa_rules_total_upload)
Module Name |
saprepost.pc |
Description |
Pre/Post Helper Processes for Sales Audit Batch Programs |
Functional Area |
Oracle Retail Sales Audit |
Module Type |
Admin |
Module Technology |
ProC |
Catalog ID |
RSA26 |
Wrapper Script |
rmswrap.ksh |
Design Overview
This program is one of a set of processes, along with Rules and Totals Extract, that migrates customer-defined totals and rules from a source environment into the destination environment. For example, this may be used to extract totals and rules set up in a pre-production environment to production prior to final cutover. When the processes are run, existing totals and rules information are extracted from the source environment, and then uploaded into the destination environment, overlaying the totals and rules previously configured in the target environment.
This program is the second step in a two-step process: The latest version of all totals and rules will be uploaded into the destination environment.
The following information is uploaded into the destination environment:
-
Parm Type
-
Realm Type
-
Location Traits
-
Parm
-
Realm
-
VR Head
-
VR Realm
-
VR Parms
-
VR Links
-
Total Header
-
Total Header Translation
-
Total Location Traits
-
Total Restrictions
-
Total Usage
-
Rule Header
-
Rule Header Translations
-
Rule Location Trait
-
Rule Components
-
Rule Component Restrictions
-
Rule Errors
The tables that this information will be uploaded into will first be cleared out of any existing data, and then the statements in the files generated by the extract process will be run to upload the information from the source environment. After the upload, the sequences for realms, parms, and VR header will be updated to set the last value on the sequence to the maximum value of the ID fields.
When the rules and totals are uploaded, they will be rebuilt in the destination environment, using existing functions.