Append Stock Ledger Information to History Tables (salapnd)

Module Name

salapnd.pc

Description

Append Stock Ledger Information to History Tables

Functional Area

Stock Ledger

Module Type

Admin

Module Technology

ProC

Catalog ID

RMS335

Wrapper Script

rmswrap_multi.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

The purpose of this program is to move data from the staging table for transaction data into the historical transaction data table. This requires placing a lock on the staging table to ensure that no new data will be added to it while the movement is occurring (to handle trickling or real-time processing), moving the data to the historical table, and finally truncating the data from the staging table.

Restart/Recovery

N/A

Design Assumptions

N/A