Not Able To Query Defined Item Category Due To Error 'ORA-01403: no data found '

(Doc ID 2365704.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Oracle Financials for India - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, India Inventory Localizations

When attempting to query the define item category
the following error occurs.

ERROR
-----------------------
ORA-01403: no data
found


STEPS
-----------------------
1) Define the new tax category like
"CS_TAX_CATEGORY_111111111111111111111111111111111111" , where the total
number is character is 54
2)Define the new item category "CS_TAX_CATEGORY_2" and assign the define tax
category
3)Re-query the item category form , find that it is not allowing to query it
due to following error :

ORA-01403:No data found


BUSINESS IMPACT
-----------------------
Not able to re-query the existing tax category

Cause

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