Pre/Post Helper Processes for ReSA Batch Programs (saprepost)

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

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

The Sales Audit pre/post module facilitates multi-threading by allowing general system administration functions (such as table deletions or mass updates) to be completed after all threads of a particular Sales Audit program have been processed.

This program will take three parameters: username/password to log in to Oracle, a program before or after which this script must run, and an indicator of whether the script is a pre or post function. It will act as a shell script for running all pre-program and post-program updates and purges.

saprepost contains the following helper functions, which are should be individually scheduled with the related main programs.

Table 19-22 Helper Functions

Catalog ID Saprepost Job Related Main Program

RSA47

saprepost saexprms post

saexprms

RSA48

saprepost saexpdw post

saexpdw

RSA39

saprepost saordinvexp post

saordinvexp

RSA51

saprepost saexpsim post

saexpsim

saprepost sapreexp post

sapreexp

Restart/Recovery

NA

Design Assumptions

N/A