Purge Dashboard Working Tables (rms_oi_purge.ksh)
|
Module Name |
rms_oi_purge.ksh |
|
Description |
Purge data from the dashboard working tables |
|
Functional Area |
Operational Insight Dashboard Reports |
|
Module Type |
Admin |
|
Module Technology |
Ksh |
|
Catalog ID |
RMS490 |
|
Runtime Parameters |
$UP (database connect string) |
Design Overview
This batch program calls OI_UTILITY.PURGE_RMS_OI_TABLES to truncate the data in the Merchandising Operational
Insight Dashboard staging tables. During normal operation, the staged data for the session are deleted when a user closes
the report window. This program provides a way to clean up and control the size of the staging tables if data failed to be
deleted due to abnormal termination of the session.
Scheduling Constraints
| Schedule Information | Description |
|---|---|
|
Processing Cycle |
Ad Hoc |
|
Frequency |
Daily |
|
Scheduling Considerations |
When no user is on-line using the OI dashboard reports. |
|
Pre-Processing |
N/A |
|
Post-Processing |
N/A |
|
Threading Scheme |
N/A |
Key Tables Affected
Table 2-5 Key Tables Affected
| Table | Select | Insert | Update | Delete |
|---|---|---|---|---|
|
RMS_OI_BUYER_EARLY_LATE_SHIP |
No |
No |
No |
Yes |
|
RMS_OI_BUYER_ORDERS_TO_APPROVE |
No |
No |
No |
Yes |
|
RMS_OI_INV_ANA_OPEN_ORDER |
No |
No |
No |
Yes |
|
RMS_OI_INV_ANA_VARIANCE |
No |
No |
No |
Yes |
|
RMS_OI_INV_CTL_NEG_INV |
No |
No |
No |
Yes |
|
RMS_OI_INV_ORD_ERRORS |
No |
No |
No |
Yes |
|
RMS_OI_INV_ORD_ITEM_ERRORS |
No |
No |
No |
Yes |
|
RMS_OI_MISSING_STOCK_COUNT |
No |
No |
No |
Yes |
|
RMS_OI_OVERDUE_SHIP_ALLOC |
No |
No |
No |
Yes |
|
RMS_OI_OVERDUE_SHIP_TSF |
No |
No |
No |
Yes |
|
RMS_OI_OVERDUE_SHIP_RTV |
No |
No |
No |
Yes |
|
RMS_OI_STK_ORD_PEND_CLOSE |
No |
No |
No |
Yes |
|
RMS_OI_STOCK_COUNT_VARIANCE |
No |
No |
No |
Yes |
|
RMS_OI_TSF_PEND_APPROVE |
No |
No |
No |
Yes |
|
RMS_OI_UNEXPECTED_INV |
No |
No |
No |
Yes |
|
RMS_OI_DATA_STWRD_INCOMP_ITEMS |
No |
No |
No |
Yes |