INV Item User Defined Attribute Upload  Help

INV Item User Defined Attribute Upload creates, updates and deletes Oracle Product Information Management (PIM / Advanced Product Catalog) item user-defined attribute values directly from Excel. It works with the attribute groups defined in your item catalog – including multi-row attribute groups – at the item, item organization and item revision data levels, and processes everything through the standard Oracle PIM interfaces, so all PIM validations apply: value sets, unique keys of multi-row groups, catalog category applicability and item role security.

When to use it

• Mass-populate user-defined attribute values for new or existing items, for example after defining a new attribute group.
• Review and mass-update existing attribute values across many items in one spreadsheet.
• Maintain multi-row attribute groups (for example competitor or configuration lists) – add, change or delete individual rows.
• Maintain revision-level attribute values per item revision.
• Delete complete attribute group rows that are no longer needed.

Before you start

• Blitz Report is installed (Oracle E-Business Suite R12 – the upload uses PIM interfaces that do not exist on 11i) and you are signed in under a responsibility with access to the inventory organizations you want to maintain.
• Your user has PIM edit privileges on the items, for example through an item owner role – the upload enforces the same item and attribute group security as the PIM pages.
• The attribute groups are associated to the items’ catalog categories. Only catalog-associated attribute groups are included; the seeded Detailed Description and Images item features are separate PIM functions, not user-defined attribute groups.

Step 1 – Run the upload and set the parameters

Run INV Item User Defined Attribute Upload from Blitz Report and choose an Upload Mode: Create opens an empty template for new attribute values; Create, Update (the default) downloads the existing attribute values matching your parameters, one spreadsheet row per attribute value.

Step 2 – Enter or edit the attribute values

Each row carries one attribute value: Organization Code, Item, Data Level, Revision (for the item revision data level), Attribute Group, Row Number, Attribute, Value, UOM and Delete Row. The lists of values cascade – the Attribute Group list shows only groups applicable to the item’s catalog category at the chosen data level, the Attribute list shows the attributes of the chosen group, and the Value list offers the attribute’s value set where one is defined.

• Change a value – overwrite the Value cell of a downloaded row. Clearing the cell clears the stored value.
• Add values – enter new rows with the item, data level, attribute group, attribute and value. New rows and downloaded rows can be mixed freely.
• Multi-row attribute groups – use the Row Number column to group the attribute values that belong to one row of the group, and include the group’s unique key attributes on every row so Oracle can match existing rows. Leave Row Number blank for single-row groups.
• Revision level – set Data Level to Item Revision and enter the Revision. Leave Revision blank for the other data levels.
• Numeric attributes with a unit of measure – enter the UOM alongside the value; Oracle validates it against the attribute’s unit of measure class.
• Dates – enter date attribute values in the format DD-MON-YYYY.
• Delete a row – set Delete Row to Yes to delete the complete attribute group row the spreadsheet row belongs to.

Step 3 – Validate and Save

Use the add-in’s Validate and Save action. It checks for missing required values, then saves the file.

Step 4 – Upload and view the result

Back in Blitz Report click Upload and select the saved file. This submits the upload request; when it finishes, a result report opens listing every row as success or error with a message. Rows are processed together per attribute group row – if one attribute value of a group row fails, the whole group row is rejected and each of its rows shows the reason.

What’s produced

• Item user-defined attribute values in PIM, exactly as if they had been entered on the item’s attribute group pages – created, updated or deleted according to the rows.
• Unchanged rows are detected and skipped with the message “No change.”, leaving the item’s audit trail untouched.
• A result report with a Status and Message on every row.

Common questions

Which attribute groups can I maintain?
All user-defined attribute groups associated to the items’ catalog categories (including associations inherited from parent categories), at the item, item organization and item revision data levels. Supplier association data levels are not supported, and the seeded Detailed Description and Images features are separate PIM functions outside the scope of this upload.

How do I maintain a multi-row attribute group?
Enter one spreadsheet row per attribute, and give all attributes belonging to the same group row the same Row Number. Always include the group’s unique key attributes – they identify which existing row to update. Changing a unique key value creates a new row instead of updating the old one, exactly as in Oracle’s own import.

How do value sets behave?
Enter the display value you see in the PIM pages; the upload passes it through Oracle’s validation, which translates it to the stored value. An invalid value is rejected with Oracle’s own error message.

Why do I get a privileges error?
The upload enforces PIM item security. Your user needs an item role with edit privileges (for example item owner) on each item being changed – the same requirement as editing the attributes in the PIM pages.

Can I clear a value?
Yes – download the rows, clear the Value cell and upload. To remove a complete attribute group row, set Delete Row to Yes instead.

Troubleshooting