'EGO_ITEM_PUB' API Errors with ORA-1403 in INVPUOPI.trans_item

(Doc ID 1454963.1)

Last updated on AUGUST 21, 2016

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

When attempting to use the EGO_ITEM_PUB.Process_Item API in UPDATE mode, the following error occurs.

ERROR
-----------------------
err_text :INVPUOPI.trans_item: ORA-01403: no data found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Following is the wrapper being used:

DECLARE
  x_Inventory_Item_Id NUMBER(9);
  x_Organization_Id NUMBER(9);
  x_return_status VARCHAR2(2000);
  x_msg_count NUMBER;
  x_msg_data VARCHAR2(2000);
BEGIN
EGO_ITEM_PUB.Process_Item(
  p_api_version => 1.0
  ,p_init_msg_list => 'T'
  ,p_commit => 'T'
  -- Transaction data
  ,p_Transaction_Type => 'UPDATE'
  ,p_segment1 => 'TESTITEM'
  ,p_organization_id => 25
...
  ,x_Inventory_Item_Id =>x_Inventory_Item_Id
  ,x_Organization_Id => x_Organization_Id
  ,x_return_status => x_return_status
  ,x_msg_count => x_msg_count
  ,x_msg_data => x_msg_data
  -- ,p_object_version_number => p_object_version_number
  );
  END;
/

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