Replenishment Data Loading Configuration

There are several parameters that impact the upload of replenishment attributes via spreadsheets or using the supported batch upload, as well as the download of existing attributes into spreadsheets. These parameters are managed via the Foundation Data Upload and Download Tasks via the Replenishment Data Loading Configuration template listed under the Administration template type. This template when downloaded contains a single worksheet, Replenishment Induction Config. This worksheet consists of a single row of information and supports only updates. The parameters contained in the worksheet are described below. To make updates to the attributes, select the action type of Update in the appropriate tab and apply your changes.

System Options	Description
Maximum Chunk Size	This indicates the maximum number of replenishment attribute records that should be processed in one chunk.
Maximum Number of Threads	This indicates the maximum number of concurrent threads for processing replenishment attribute updates.
Waiting Time Between Threads (milliseconds)	This parameter holds the number of milliseconds between the submissions of two threads.
Maximum Replenishment for Download	Specifies the maximum number of replenishment attribute records that can be downloaded at a time. It is recommended that this be set to 1,000 or lower for best performance.
Maximum Replenishment for Synchronous Download	Specifies the maximum number of replenishment attribute records that can be downloaded while the user waits before switching to asynchronous processing.
Maximum File Size for Upload	Specifies the maximum size of the file (XML or .ods) that can be processed for upload at a time, measured in bytes. It is intended to be set based on a typical file sizes and processing time considerations. It is recommended that this be set to 500MB or lower for best performance.
Maximum File Size for Synch Upload	Specifies the maximum size of the file (XML or .ods) that can be processed for an upload in synchronous mode. This value should be set based on acceptable wait times. If the file size exceeds this value, the process request will be queued for asynchronous processing.

Uploading Changes

For the attributes defined above, once all the updates have been made to the data in the spreadsheet, save the file and close it. Then, return to the Merchandising screens and select Foundation Data > Upload Foundation Data from the main task list. In this screen, select the template type Administration and the template Replenishment Data Loading Configuration. This will generate a process description automatically, but this can be updated if desired. Lastly, select the Browse button and navigate to the directory where you saved the updated spreadsheet. To review the status of the upload and check whether any errors occurred, select the Foundation Data > Review Status task from the main task list.

For more information, see "Download/Upload Data from Spreadsheets" in the Oracle Retail Merchandising Do the Basics User Guide.