INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY Allows Creating Categories With Trailing Spaces

(Doc ID 1575359.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.
During writing this Doc there is open related <> about calls made from parallel processes to create categories with the same data can also result in duplicate data with different category id .

Symptoms

INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY creates duplicate categories when called from parallel process .

When calling INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY multiple times in series with the same data, the API returns an error: Please enter a new Category Segment Combination
When called from multiple parallel processes, it allows the creation of duplicate categories.
This causes the Requisitions screen to report the following error when a part is used which has a duplicated category assigned to it:

APP-FND-01564: ORACLE error 1422 in FDFGCD

Cause: FDGCD failed due to ORA-01422: exact fetch returns more than requested number of rows

The SQL statement being executed at the time of error was:

select enabled_flag, summary_flag, nvl(to_char(start_date_active, 'J'), 0),
segment1, segment2, segment3, segment4, segment5, segment6, segment7, segment8, segment9, segment10, category_id
from apps.mtl_categories_vl
where structure_id = 50391
and segment1 = 'NLR'
and segment2 is null
and segment3 is null
and segment4 = '001'
and segment5 = '610C2322-001'
and segment6 = '3127000000-Machine made parts'
and segment7 is null
and segment8 is null
and segment9 is null
and segment10 is null
and ((nvl(disable_date, sysdate + 1) > sysdate ))

Error Codes
---------------------------------------------------
APP-FND-01564 error 1422

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