My Oracle Support Banner

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 AUGUST 12, 2021

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.