Supplier Wizard provides you with the ability to download existing Suppliers and their associated Sites and Contacts into the worksheet.
Downloading is recommended when modifying existing Supplier information as it provides the worksheet with the correct Id’s and allows you to view the data in the worksheet as it exists in Oracle E-Business Suite.
This facility is also useful for creating new suppliers by using an existing supplier as the Template. If you choose to do this, you will need to remove the downloaded Id’s for each supplier and associated record so that a new Id is created for the new supplier. If you do not remove the ‘Id’ the Wizard will try and update the existing record and an error will occur:
Restrict Operating Unit Option
If you use a multi org responsibility on the Supplier Wizard - Setup ribbon, select the operating units you wish to download.
The options provided are as follows:
a)Current OU only– This will restrict the download to be only the operating unit selected when you logged into the Wizard and can be found on the ‘About This Program’ form.
b)All Available OUs– This option will enable you to download all records for all of the operating units you have access to.
For single org responsibilities the option selected above has no effect.
Supplier Wizard provides you with three methods of downloading into your worksheet:
•Method 1 - Use aDownload Formwhich provides multiple criteria for you to target the required Suppliers and associated Sites.
•Method 2 – Use theDownload via sheetoption and enter multiple criteria into your worksheet to download based on the data entered.
•Method 3 – Use theCustom Query Tab 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.
