My Oracle Support Banner

Fusion PIM: Importing Item Category Assignment Does Not Update Assignment When Using SYNC Transaction Type (Doc ID 1667218.1)

Last updated on JANUARY 19, 2016

Applies to:

Oracle Fusion Product Hub - Version and later
Information in this document applies to any platform.


Catalog is defined to allow only 1 category assignment. When an item is imported we do not know whether this is a new or existing item (with an existing item category assignment). During import all items will be assigned to an alternate catalog category (item category). It is possible an existing item is imported with an updated (another) item category. We expect the system to update the item category.

When using the UPDATE transaction type (upload by spreadsheet & SQL insert statement), the import correctly updates the item category. But as stated, during item import we do not know whether the item category assignment exists, hence the need to use SYNC.

When item category assignment is imported with SYNCH option, if there is an existing category assignment, system should:
1. Unassign the existing category
2. Assign the new category assignment being imported


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.