My Oracle Support Banner

Error "INV_CAT_PO_REFER" When Changing The Default Purchasing Category Set (Doc ID 783248.1)

Last updated on AUGUST 20, 2021

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 and later
Oracle Item Master - Version to 12.1.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Oracle Item Master - Version: 11.5.10 and higher
This problem can occur on any platform.


Problem Statement:

There is an additional constraint/validation in the Purchasing Functional Area that is not mentioned in the User's Manual:
There is a validation on the default purchasing category set. 
It cannot be modified if records exist in any of the PO tables that refer to the old category set AND if the structure id's for the new and old category sets are different.

The Error Message (although, there is no Error Number) is "INV_CAT_PO_REFER. Purchasing default category set cannot be modified as records exist in purchasing tables that refer to the old category set and the flex structures do not match for the old and new category set."


When there is an attempt to change the default category set of the purchasing functional area
and the structure id of the old and new category sets are different
and if records exist in any of the PO tables that refer to the old category set user
then you will not be able to modify the default value associated with the Purchasing Functional Area.


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.