Pre/Post Helper Processes for Batch Programs (prepost)

Module Name

prepost.pc

Description

Pre/Post Helper Processes for Batch Programs

Functional Area

Administration

Module Type

Business Processing

Module Technology

ProC

Catalog ID

N/A

Individual pre/post jobs have Catalog IDs

Wrapper Script

rmswrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

The 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 program have been processed.

This program will take three parameters: username/password to log on to Oracle, a program before or after which this script must run and an indicator telling 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 (the logic was removed from the programs themselves to enable multi-threading and restart/recovery).

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

Table 2-2 Pre/Post Helper Functions

Catalog ID Prepost Job Related Main Program Catalog ID Related Main Program

RMS400

prepost rpl pre

RMS315

rplext

RMS401

prepost salweek post

RMS346

salweek

RMS402

prepost salmth post

RMS343

salmth

RMS403

prepost rplapprv pre

RMS300

rplapprv

RMS404

prepost rplatupd pre

RMS313

rplatupd

RMS405

prepost rplatupd post

RMS313

rplatupd

RMS406

prepost rilmaint pre

RMS311

rilmaint

RMS407

prepost rilmaint post

RMS311

rilmaint

RMS408

prepost supmth post

RMS369

supmth

RMS409

prepost sccext post

RMS355

sccext

RMS410

prepost hstbld pre

RMS239

hstbld

RMS411

prepost hstbld post

RMS239

hstbld

RMS413

prepost edidlprd post

RMS47

edidlprd

RMS414

prepost edidlprd pre

RMS47

edidlprd

RMS417

prepost cntrordb post

RMS232

cntrordb

RMS418

prepost fsadnld post

N/A

N/A

RMS419

prepost btchcycl

N/A

No related main process. Is used to enable DB policies that might have been disabled in order to run batch.

RMS421

prepost poscdnld post

N/A

poscdnld

RMS423

prepost htsupld pre

N/A

htsupld

RMS425

prepost reclsdly pre

RMS302

reclsdly

RMS426

prepost reclsdly post

RMS302

reclsdly

RMS427

prepost ibcalc pre

RMS249

ibcalc

RMS428

prepost fcstprg pre

RMS227

fcstprg

RMS429

prepost fcstprg post

RMS249

fcstprg

RMS430

prepost reqext pre

RMS310

reqext

RMS431

prepost reqext post

RMS310

reqext

RMS432

prepost stkupd pre

N/A

Stkupd

RMS433

prepost replroq pre

RMS308

Replroq

RMS434

prepost rplext post

RMS315

Rplext

RMS438

prepost saleoh pre

RMS337

Saleoh

RMS440

prepost salweek pre

RMS346

salweek

RMS441

prepost dealinc pre

RMS211

Dealinc

RMS442

prepost dealday pre

RMS208

dealday

RMS443

prepost dealday post

RMS208

dealday

RMS444

prepost dealact_nor pre

RMS206

Dealact

RMS445

prepost dealact_po pre

RMS206

Dealact

RMS446

prepost dealact_sales pre

RMS206

Dealact

RMS447

prepost dealfct pre

RMS209

Dealfct

RMS448

prepost dealcls post

RMS209

Dealcls

RMS449

prepost hstbldmth post

RMS241

hstbldmth

RMS450

prepost vendinvc pre

N/A

vendinvc

RMS451

prepost vendinvf pre

N/A

vendinvf

RMS452

prepost vendinvc post

N/A

vendinvc

RMS453

prepost vendinvf post

N/A

vendinvf

RMS454

prepost docclose pre

RMS219

docclose

RMS455

prepost stkprg post

RMS360

stkprg

RMS456

prepost wfordupld pre

RMS392

wfordupld

RMS457

prepost wfretupld pre

N/A

wfretupld

RMS458

prepost replsizeprofile pre

RMS309

replsizeprofile

RMS459

prepost supsplit pre

RMS370

supsplit

RMS461

prepost batch_ordcostcompupd pre

RMS190

batch_ordcostcompupd

RMS462

prepost batch_ordcostcompupd post

RMS190

batch_ordcostcompupd

RMS463

prepost batch_costcompupd post

RMS190

batch_ordcostcompupd

RMS465

prepost dlyprg post

RMS218

dlyprg

RMS466

prepost tsfprg pre

RMS380

tsfprg

RMS467

prepost tsfprg post

RMS380

tsfprg

RMS468

prepost fcexec pre

RMS223

fcexec

RMS469

prepost start_batch pre

N/A

Sets the batch running ind to ‘Y' to limit front end use of the system.

RMS470

prepost end_batch post

N/A

Sets the batch running ind to ‘N' to reenable all front end use of the system.

This should be the last job in the batch cycle.

RMS488

prepost btchcycl post

N/A

This job reenables all policies in the Merchandising owning schema.

RMS489

prepost dealfct post

RMS209

dealfct

Restart/Recovery

N/A