Merch API Data Rebuild Request Wrapper Script (merchapidatarebuildrequest)

Module Name

merchapidatarebuildrequest.ksh

Description

Wrapper shell script to submit data refresh requests.

Functional Area

Foundation and Inventory tracking.

Module Type

Business Processing

Module Technology

Ksh

Catalog ID

TBD

Runtime Parameters

N/A

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This wrapper batch program is used to make an entry in the MERCHAPI_ASYNC_REQUEST table for data refresh requests. There are two data refresh types: one is TRUNCATE_AND_LOAD and the other one is REBUILD.

  • TRUNCATE_AND_LOAD will be used for severe data corruption.

  • REBUILD is used to build the JSON message for all the records.

The LAST_UPDATE_DATETIME update is dependent on the value of REFRESH_UPDATE_TIMESTAMP_IND. The silent update (REBUILD with no timestamp update) is applicable when a new field is added or removing the deprecated fields and don’t want to force-publish these changes. REBUILD with timestamp update is used in case of data discrepancies within Merchandising and Cache table or Merchandising and consuming system.

Restart/Recovery

N/A

Design Assumptions

N/A