Stage Regular Price Changes on Open Allocations and Transfers (distropcpub)

Module Name

distropcpub.pc

Description

Stage Regular Price Changes on Open Allocations/Transfers so Publishing Sends New Retail to Subscribing Applications

Functional Area

Transfers, Allocations, and RTV

Module Type

Integration

Module Technology

ProC

Catalog ID

RMS216

Wrapper Script

rmswrap_multi.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This program will look for any regular price change (transaction type 4 or 11 from the price history table) that is due to go into effect tomorrow. Then, for any open allocations or transfers where the ‘to' location and items that have price changes going into effect, it places a record on the allocation or transfer publishing queue tables, such that they can be picked up by the RIB and sent to the subscribing systems.

Restart/Recovery

The logical unit of work is store. The driving cursor retrieves all item/locations that have price changes in effect from the next day. It also gets all of the component items of the non-sellable packs that have price changes.

I/O Specification

Integration Type

Download from Merchandising

File Name

N/A

Integration Contract

IntCon000196

ALLOC_MFQUEUE table

Integration Type

Download from Merchandising

File Name

N/A

Integration Contract

IntCon000197

TSF_MFQUEUE table

Design Assumptions

N/A