Supplier Product Uploads

Suppliers can upload product data, using a file, through Oracle Product Hub Portal.

Upload Flow

The following table describes the basic product upload flow when your supplier uses Product Hub Portal. This flow assumes that you're responsible for managing import of data to production tables, and that you have set up a spoke system for your product data supplier.

Who (User)	Where (Location)	What (Objects)	How (Action)
You	Edit Import Map page	Import map	Select the External option and choose the suppliers who will upload data. Select a source data file and map columns of source data to master data attributes.
You	Edit Import Map page	Import map source data file	Use the Generate Templates action to generate templates that suppliers can download in product hub portal.
Your supplier	Product Uploads page in Product Hub Portal	Import map source data file	Click Download Templates and download the source data template file, which is named for the corresponding import map.
Your supplier	Downloaded Template	Smart spreadsheet	Enter the product data and generate the data file to be uploaded to product hub portal.
Your supplier	Product Uploads page	Generated data file	Click Upload File, then specify the category and data file. A default name for the upload is provided. Click Upload to start the upload of the source data file to the interface tables.
You	Review Supplier Uploads page	Product information	Review and accept or reject products uploaded by suppliers and create item batches.
You	Manage Item Batches page	Item batch containing the data upload	Review the new item batch and import options for the spoke system definition for your supplier.
You	Manage Item Batches page	Item batch containing the data upload	The item batch page includes details about the outcome of the import process.
You Your supplier	Product Information Management work area Supplier Portal work area	Worklist notifications email messages	Events in the flow generate informational messages or emails, prompting you and your supplier to take action as needed.
Your supplier	Schedules page	Schedules	Examine the status of the schedule. Stop the schedule if desired. Edit future runs of the schedule if it hasn't completed them.

Note:

• Suppliers can't import structure component substitutes or reference designators from Oracle Product Hub Portal.
• When subsequent supplier product upload is performed, the newly uploaded product data is merged with the existing product data.
• When you upload a product with an incorrect category, you can't re-upload a new file with the correct category until you delete the existing product. To delete the existing product, use the Supplier Product REST resource and then you can upload the new data file with the correct product category.

Delete Attribute Values from Production

Supplier product administrators can delete attribute values of a product in Product Hub Portal and submit the changes for import into Oracle Product Hub. On successful import, the attribute values on the production item are deleted.

• Be aware of the following scenario, and its effect on the attributes GTIN, GTIN UOM, Manufacturer Part Number, and Manufacturer Name:

  1. You have previously imported a supplier product into production with GTIN or MPN relationships.

  2. The supplier deletes the attribute value in Product Hub Portal.

  3. You re-import the supplier product.

  4. GTIN or MPN relationships aren't deleted from production items after import if values are deleted from Oracle Product Hub.