Extract Totals and Rules (sa_rules_total_extract)
|
Module Name |
sa_rules_total_extract.ksh |
|
Description |
Extracts totals and rules, along with their related information from a source environment. |
|
Functional Area |
Oracle Retail Sales Audit |
|
Module Type |
Admin - Ad hoc |
|
Module Technology |
ksh |
|
Catalog ID |
|
|
Wrapper Script |
rmswrap_shell_out.ksh |
Design Overview
This program is one of a set of processes, along with Rules and Totals Upload, 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 these programs 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 first step in the two-step process: The latest version of all totals and rules will be extracted from the source environment and written out to flat files.
The following information is extracted from the source environment:
-
Parm Type
-
Realm Type
-
Location Traits
-
Parm with the highest sequence number
-
Realm with the highest sequence number
-
VR Head
-
VR Realm
-
VR Parms
-
VR Links
-
Total Header - latest revision for the total
-
Total Header Translation - latest revision for the total
-
Total Location Traits - latest revision for the total
-
Total Restrictions - latest revision for the total
-
Total Usage - latest revision for the total
-
Rule Header - latest revision for the rule
-
Rule Header Translation - latest revision for the rule
-
Rule Location Trait - latest revision for the rule
-
Rule Components - latest revision for the rule
-
Rule Component Restrictions - latest revision for the rule
-
Rule Errors - latest revision for the rule