Update OTB After Deal Discounts (discotbapply)

Module Name

discotbapply.pc

Description

Update OTB After Deal Discounts

Functional Area

Deals

Module Type

Business Processing

Module Technology

ProC

Catalog ID

RMS215

Wrapper Script

rmswrap_multi.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

Deals processing can change the cost on purchase orders. When this occurs (in the batch program orddscnt.pc), Open To Buy (OTB) must also be updated to ensure that budgets reflect reality. This program updates these OTB buckets.

Restart/Recovery

This program has inherent restart ability, because records are deleted from DISC_OTB_APPLY as they are processed. Array processing is used. Records are array fetched from DISC_OTB_APPLY table, processed and committed to the database.

Schedule

Oracle Retail Merchandising Batch Schedule