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. |
- 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:
-
You have previously imported a supplier product into production with GTIN or MPN relationships.
-
The supplier deletes the attribute value in Product Hub Portal.
-
You re-import the supplier product.
-
GTIN or MPN relationships aren't deleted from production items after import if values are deleted from Oracle Product Hub.
-