Reconcile Received Dummy Carton IDs with Expected Cartons (dummyctn)

Module Name

dummyctn.pc

Description

Reconcile Received Dummy Carton IDs with Expected Cartons

Functional Area

Transfers, Allocations and RTVs

Module Type

Business Processing

Module Technology

ProC

Catalog ID

RMS233

Wrapper Script

rmswrap.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

When stock orders are received, if a carton number or barcode cannot be read due to damage to the box or other factors, a dummy ID is assigned to it and its detail received at the store or warehouse. The dummy ID and the details of the carton received are then written to a staging table during the receiving process. This batch process scans stock orders to find transfers or allocations that contain cartons that were not received to see if any shipments contain un-received cartons that match the dummy carton receipt (both item and quantity). If a match is found, then the dummy carton is received against the matching carton. If a match is not found, an error is written to an error file and the record remains on the staging table. These unprocessed records are eventually purged from the staging table when the receipt transaction date is older than the current date minus Close Open Shipments After.

Restart/Recovery

This program deletes from the dummy carton staging table. The program will restart by processing the records that remain on the dummy carton staging table.

Design Assumptions

N/A