When it comes to using Manufacturer mode, it is using Oracle Private Package. Unfortunately, there isn't Oracle Public API available for this mode, so users will need to be extra diligent in testing before making the move to the production environment.
To make the manufacturer parts available in the iProcurement, Item Extension Wizard runs a concurrent program called "Rebuild Catalog interMedia Index" as part of the upload in Manufacturer mode. It's important to note that the "Rebuild Catalog interMedia Index" program doesn't allow you to run past dates.
To be able to create and delete an item – Manufacturer Part Number assignments.
Requirements:
Set the profile 'More4Apps: IEW Activate Manufacturer Part Mode' to "Yes". Note that this is using a private package to insert into the Oracle tables and may not be supported by Oracle.
Rules and Exceptions:
Create/insert can only occur if an item exists in Oracle.
As per standard Oracle functionality, Manufacturer Part Numbers are at master organization only.
Updates are not supported - you must delete the existing relationship to the Manufacturer Part Number and re-load the new part number.
Functionality Type:
This load type uses a custom API not supported by Oracle.
User Form Layout:
Spreadsheet Data Columns:
•Item Number – Any existing Oracle Item Number.
•Manufacturer – This is required and selectable only. You cannot create manufacturers. These are predefined in Oracle.
•Manufacturer Part – This is a free text character field up to 150 characters.
•Delete Manufacturer Part – Before you can select the delete option a check is made to make sure it doesn’t exist in the Approved Supplier List (ASL).
