Process Pending Merchandise Hierarchy Changes from External Systems (cremhierdly)

Module Name

cremhierdly.pc

Description

Process Pending Merchandise Hierarchy Changes from External Systems

Functional Area

Foundation Data

Module Type

Business Processing

Module Technology

ProC

Catalog ID

RMS204

Runtime Parameters

rmswrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This batch program reads merchandise hierarchy records from the pending merchandise hierarchy table whose effective date is tomorrow or earlier. The pending merchandise hierarchy table is populated by the Merchandise Hierarchy Reclass Subscription API. Each record is then used to either insert or update existing merchandise hierarchy data in Merchandising based on the action and hierarchy types. The inserted/updated records are deleted from the pending merchandise hierarchy table after they have been successfully processed.

This program is only required if updates to the merchandise hierarchy in Merchandising are being managed outside the application.

Restart/Recovery

This program is setup for multithreading and restart/recovery.

Design Assumptions

N/A