Item Data Loading Configuration

There are several parameters that impact the upload of items via spreadsheets or using the integration methods, as well as the download of items into spreadsheets. These parameters are managed via the Foundation Data Upload and Download Tasks via the Item Data Loading Configuration template listed under the Administration template type. This template when downloaded comprises of two worksheets, Item Induction Configuration and Coresvc Item Induction Configuration. Each of these worksheets carries a single row of information and supports only updates. The parameters contained in each of these worksheets are described below. To make updates to either set of attributes, select the action type of Update in the appropriate tab and apply your changes.

Item Induction Configuration

This worksheet contains parameters that specify upper bounds on file size and the number of records that can be uploaded or downloaded.

System Options	Description
Maximum Number of Items for Download	Specifies the maximum number of items that can be downloaded at a time. The value in this parameter is compared to the number of item master level records would be extracted based on the criteria used in the Merchandising screen to initiate the extract. It is recommended that this be set to 1,000 or lower for best performance.
Maximum Number of Items for Synchronized Download	Specifies the maximum number of items, counting by item master rows, 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 Download	Specifies the maximum size of the file (XML or .ods) that can be processed for an upload in synchronous mode, measured in bytes. 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.
Maximum Number of Cost Changes for Synchronized Download	Specifies the maximum number of cost changes, by the number of header rows, that can be downloaded while a user waits, before switching to asynchronous processing
Maximum Number of Cost Changes for Download	Specifies the maximum number of cost changes that can be downloaded at a time, by number of header rows. It is recommended that this be set to 1,000 or lower for best performance.

Item Configuration

This worksheet contains parameters that capture the default choices to be used while cascading of item details from parent to child or other higher to lower levels within the item structure during the creation of items via the upload process.

System Options	Description
Maximum Chunk Size	This indicates the maximum number of items, based item master records, that should be processed in one chunk.
Number of Error on Process Retention Days	This attribute is no longer used by Merchandising.
Cascade UDA Details Indicator	Indicates whether updates, inserts, or deletes to UDAs for a parent item should be cascaded to the child items. Valid values are Yes or No.
Cascade of IUD for Item, Supplier and Country Indicator	Indicates whether updates, inserts, or deletes to item/supplier/country of origin records for a parent item should be cascaded to the child items. Valid values are Yes or No.
Cascade of IUD for Item, Supplier and Country Dim Indicator	Indicates whether updates, inserts, or deletes to item/supplier/country/dimensions for a parent item should be cascaded to the child items. Valid values are Yes or No.
Cascade of IUD for Item, Supplier, Manu Country Indicator	Indicates whether updates, inserts, or deletes to item/supplier/country of manufacture for a parent item should be cascaded to the child items. Valid values are Yes or No.
Update Default Location to All Item Supplier Country Indicator	Indicates whether updates, inserts, or deletes to item/supplier/country of origin records should be cascaded to the item/supplier/country of origin/locations. Valid values are Yes or No.
Update Child Default Location to all Item Supplier Country Indicator	Indicates whether updates, inserts, or deletes to item/supplier/country of origin/location records for a parent item should be cascaded to the child items. Valid values are Yes or No.
Cascade VAT Items	Indicates whether inserts, or deletes to VAT information for a parent item should be cascaded to the child items. Valid values are Yes or No.
Maximum Item Reserved Quantity	This parameter is used by the Item Reservation web service that can be used by an external system to request Merchandising item numbers. It specifies the maximum number of items that can be reserved in Merchandising by an external application.
Maximum Item Expiry Date	This parameter is used by the Item Reservation web service that can be used by an external system to request Merchandising item numbers. It specifies the maximum number of number of days for which item numbers that have been previously reserved will remain unused before they will be released.
Maximum Number of Threads	This attribute is no longer used by Merchandising.
Waiting Time between Threads (milliseconds)	This attribute is no longer used by Merchandising.
Cascade of Image Inherit on Child/Grandchild Indicator	Indicates whether image associated with a parent item should be inherited by the child items.
Cascade of IUD on Item, Supplier Indicator	Indicates whether updates, inserts, or deletes to the item supplier details associated with a parent item should be inherited by the child items.
Cascade of HTS	Indicates whether updates, inserts, or deletes to the HTS records for a parent item should be cascaded to the child items.
Cascade of Assessments	Indicates whether updates, inserts, or deletes to assessments records for a parent item should be cascaded to the child items.
Cascade of Expenses	Indicates whether updates, inserts, or deletes to the expense records for a parent item should be cascaded to the child items.
Cascade of Item Tickets	Indicates whether updates, inserts, or deletes to ticketing information for a parent item should be cascaded to the child items.
Cascade of Seasons	Indicates whether or not seasons should be cascaded to child items when added for a parent item. Valid values are Yes (Y) or No (N).
Cascade of Upcharges	Indicates whether or not upcharges should be cascaded to child items when added for a parent item. Valid values are Yes (Y) or No (N).

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 Item 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.