My Oracle Support Banner

API INV_ITEM_CATEGORY_PUB.Update_Category_Assignment Not Changing Purchasing Category In iProcurement (Doc ID 1337071.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle iProcurement - Version 12.1.3 and later
Oracle Product Hub - Version 12.1.3 and later
Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.
INVPCATB.pls: INV_ITEM_CATEGORY_PUB: Public API For Item Categories


Category changes made with the API INV_ITEM_CATEGORY_PUB.update_category_assignment are not changing the Purchasing Category viewed thru iProcurement.

What is working
Correctly see the update in Oracle PIM and Oracle Inventory, but the iProcurement still shows the assignment previous category.


1. Create an item.
2. Assign to a Purchasing Category.
3. Update the assignment category with API INV_ITEM_CATEGORY_PUB.update_category_assignment.
4. See the update in Oracle PIM and Oracle Inventory
5. Do NOT see the updated category in iProcurement (see the old assignment).

Update the category via the screens.

Example API Call
Here is a sample API call. In this example, the variables for the organization, item, category set, category id and old category id are specific values that would need to be changed on each system. The same applies to the call to fnd_global.APPS_INITIALIZE that requires valid values for responsibility id, user id, and application id for each environment.




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

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

In this Document

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