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.


On : 12.1.3 version, Item Issues

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.

Expect to have the same behavior as for the item number not containing the Separator character in the "System Items" key flexfield:
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

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.


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