Process Uploaded Franchise Customers and Customer Groups (fcustomerprocess)
|
Module Name |
fcustomerprocess.ksh |
|
Description |
Process Uploaded Franchise Customers and Customer Groups |
|
Functional Area |
Franchise Management |
|
Module Type |
Business Processing |
|
Module Technology |
ksh |
|
Catalog ID |
RMS492 |
|
Wrapper Script |
batch_fprocess.ksh |
Design Overview
This module processes the franchise customer groups and franchise customers information from the staging tables and loads it into Merchandising base tables for franchise customer groups and franchise customer information. It is also designed to process (insert/update or delete) the validated data that maps to franchise customer groups and franchise customer information.
Restart/Recovery
The restart recovery is different from the conventional Merchandising batch. During the batch process, you can evaluate the successful processing of data in the following way:
-
PL/SQL function will load the data from staging tables into Merchandising tables. For records that result (insert/update/delete) in constraint error or are not found in the Merchandising tables(for update/delete) are rejected and the information is updated back in the corresponding staging table with appropriate error message.
Also, records that do not meet certain business validations (which can only be validated during data processing) are rejected and the information is updated back in the corresponding staging table with appropriate error message.
Action Required: When this condition exists, you can fix the data upload file and try to reload and process the data.
