Merch API Delta Processing Wrapper Script (merchapiwrap)
Module Name |
merchapiwrap.ksh |
Description |
Wrapper shell script to pre-process the Delta records for Merch integration API publishing. |
Functional Area |
Foundation and Inventory Tracking. |
Module Type |
Business Processing |
Module Technology |
Ksh |
Catalog ID |
TBD |
Runtime Parameters |
N/A |
Design Overview
This wrapper batch program is used to populate/merge the delta changes that were made to the base Merchandising tables into respective MERCHAPI cache tables based on the ICL entries. Each API has a separate cache table and respective API package to refresh the table. Based on the Job name, it retrieves all the Job parameters from the MERCH_BATCH_PARAM table and calls the Delta PLSQL dynamically to process all the changes that were logged in the respective ICL table. All the ICL records which are in “N” status and consumer configured for that particular API are picked up for processing. First, it updates all the “N” records to “I” (In-Progress) and deletes all the “I” records once these are processed successfully.