Not Able To Insert Data Into MTL_PENDING_ITEM_STATUS Using The EGO_ITEM_PUB API (Doc ID 1471502.1)

Last updated on MARCH 02, 2015

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Cannot insert data into MTL_PENDING_ITEM_STATUS using the api EGO_ITEM_PUB.Process_item_phase_and_status. All required columns are used, but it still returns the message no data found.

ERROR

Error Message :Executing -
"EGO_ITEM_LC_IMP_PC_PUB"."Create_Pending_Phase_Change" "ORA-01403: no data
found"


STEPS

The issue can be reproduced at will with the following steps:
Please find below the ct call to the API:

DECLARE
o_return_status VARCHAR2 (1);
o_msg_count NUMBER;
o_msg_data VARCHAR2 (4000);
BEGIN

FND_GLOBAL.APPS_INITIALIZE(1564, 32049, 431);

EGO_ITEM_PUB.Process_item_phase_and_status
(p_api_version =>1.0
,p_commit =>fnd_api.G_TRUE
,p_init_msg_list =>fnd_api.G_TRUE
,p_transaction_type =>EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
,p_inventory_item_id =>10425
,p_item_number =>NULL
,p_organization_id =>204
,p_organization_code =>NULL
,p_revision_id =>NULL
,p_revision =>NULL
,p_implement_changes =>fnd_api.G_TRUE
,p_status =>'Obsolete'
,p_effective_date =>'10-JUN-12'
,p_lifecycle_id =>NULL
,p_phase_id =>NULL
,p_new_effective_date =>'10-JUN-12'
,x_return_status =>o_return_status
,x_msg_count =>o_msg_count
,x_msg_data =>o_msg_data
);
IF o_msg_count > 0 THEN

  
  FOR i IN 1 .. o_msg_count LOOP

  DBMS_OUTPUT.PUT_LINE('Error Message :'||fnd_msg_pub.get (p_msg_index => i, p_encoded => fnd_api.g_false));

  END LOOP;

  END IF;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('in others exception');
COMMIT;
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