My Oracle Support Banner

Imported Items Do Not Display In Main Store Under Shopping Categories in Rel.12.0.4 (Doc ID 603785.1)

Last updated on JULY 05, 2021

Applies to:

Oracle iProcurement - Version 12.0.4 to 12.0.6 [Release 12]
Information in this document applies to any platform.


Problem Statement:
Items are imported from legacy systems using the Item Import application program interface (API).  The Purchasing categories are assigned or updated through the API.
When a user logs into iProcurement and searches in the main store, they expect to see the items under the Shopping categories but they do not display.  Users can search for the item and it will display in the search results without a shopping category.

In order for the item to display using the category hierarchy, the user may query up the item in core application item form and change the Purchasing Category then save the record.

Recent Changes: upgraded to 12.0.4

Workaround manually update the Purchasing Category on items, to get the items to display in iProcurement.

Steps To Reproduce:
1. After items are imported to the Application, log into iProcurement.
2. Click on Main Store link.  The page indicates that there are no categories available.
3. Log in to Oracle Purchasing or Oracle Inventory.
4. Query a purchasing item.
5. Change the purchasing category and save.
6. Return to iProcurement, and see the category and item are now found under the Main Store.


Upgrade to release 12


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.