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 |
Wrapper Script |
rmswrap_shell.ksh |
Design Overview
This batch program calls a package function 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.
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 |