| Oracle® Retail Merchandising System Operations Guide, Volume 1 - Batch Overviews and Designs Release 16.0.027 E97075-03 |
|
 Next |
| Oracle® Retail Merchandising System Operations Guide, Volume 1 - Batch Overviews and Designs Release 16.0.027 E97075-03 |
|
Next |
| Module Name | admin_api_purge.ksh |
| Description | Purge Manage Admin records |
| Functional Area | Administration |
| Module Type | Admin |
| Module Technology | ksh |
| Catalog ID | |
| Runtime Parameters | Database connection |
This script purges data from tables used for uploading Foundation Data from spreadsheets based on the retention days specified in the system parameter- PROC_DATA_RETENTION_DAYS for both RMS and ReSA and will help in keeping the size of these tables controlled.
Table 3-1 Scheduling Constraints
| Schedule Information | Description |
|---|---|
|
Processing Cycle |
Ad Hoc |
|
Frequency |
As Needed |
|
Pre-Processing |
NA |
|
Post-Processing |
NA |
|
Threading Scheme |
NA |
N/A
Table 3-2 Key Tables Affected
| Table | Select | Insert | Update | Delete |
|---|---|---|---|---|
|
S9T_ERRORS |
No |
No |
No |
Yes |
|
S9T_FOLDER |
No |
No |
No |
Yes |
|
SVC_ADMIN_UPLD_ER |
No |
No |
No |
Yes |
|
SVC_PROCESS_TRACKER |
No |
No |
No |
Yes |
N/A
