INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY Allows Creating Categories With Trailing Spaces
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 <
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
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 ))
APP-FND-01564 error 1422
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