Download from Oracle Inventory

The Download function enables you to download existing Oracle Inventory Item information into the worksheet. This information can then be modified to create new items or to update existing items.

Note - If you download a set of data, then place your cursor above this data on the worksheet and undertake another download, the second download will push the other data down the sheet that was downloaded first.

TIP: Item Wizard has a lot of columns and it is sometimes hard to know what data goes where. A download is a fast and effective way to examine an existing item and determine what data goes in what column. Alternatively, you could use templating or copy item functionality.

Item Wizard provides you with three methods of downloading items into your worksheet:

• Method 1 - Use the Download Form which provides multiple criteria for you to target the required price lists.

• Method 2 – Use the Download Using Sheet Data option and enter multiple criteria into your worksheet to download based on the data entered. Downloading via the interface table is included in this option.

• Method 3 – Use the Custom Query option. This feature allows users to run pre-defined queries created by their Administrators where they are assigned to the same Oracle Responsibility being used in the Wizard.

Please note that Item Wizard does contain nine different modes. For the sake of simplicity, we will demonstrate the functionality for the Items mode when downloading as this is the primary mode of Item Wizard. Downloading in all modes are conducted the same way. However, the Download from interface is only available for the Items Mode.

Furthermore, the Organization Assignment mode does not have a download due to its functionality being purely designed for assigning items to other inventory organizations.