Error ¡n Creating Combinations Of Category

(Doc ID 1669158.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.


On 12.1.3 version, Inventory Transactions

When attempting to query an item, query a specific flex structure in the category codes form or query specific category set, the following errors occur.

ORA-01722: Invalid Number
FRM-40505: ORACLE error: unable to perform query.

and for category set:
ORA-01722: Invalid number
APP-FND-00756: Cannot find combination CCID= 20151 CODE= MCAT SET = 50408

The issue can be reproduced at will with the following steps:
1. Navigation: inventory / items / master items / query item
2. Navigation: inventory / setup / items / categories / category codes
3. Navigation: inventory / setup / items / categories / category sets

Due to this issue, users cannot access, create or assign category codes for category sets sales, purchasing, inventory.


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 hundreds of Community platforms