EGO_ITEM_PUB.PROCESS_ITEM API Creates Item Without Item Revision when only one segment defined in "System Items" Key flexfield (Doc ID 1645685.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.

Symptoms

On : 12.1.3 version, Item Issues

ACTUAL BEHAVIOR
---------------
While attempting to create an item using EGO_ITEM_PUB.PROCESS_ITEM API, for item number containing the character which is used as Separator in the "System Items" key flexfield (no segments are configured), PROCESS_ITEM just creates the item but no revision anymore. No error is returned.

EXPECTED BEHAVIOR
-----------------------
Expect to have the same behavior as for the item number not containing the Separator character in the "System Items" key flexfield:
Example:
Separator in "System Items" key flexfield -> "-"
ItemNumber 140123_01_000001 -> OK and revision is created
ItemNumber 140123_01-000001 -> Not OK - Item is created but revision is not

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Development manager responsibility:
1) Create an item using ego_item_pub.process_item API for item number not containing the Separator character in the "System Items" key flexfield
2) Run ego_item_pub.process_item API.
3) The return status is 'S' and the item is created successfully but no revision created.



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