APIs EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG and EGO_ITEM_PUB.PROCESS_ITEM_ORG_ASSIGNMENTS Return Status U Incorrectly (Doc ID 1277350.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Product Hub - Version 12.0.4 and later
Information in this document applies to any platform.
EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG
EGO_ITEM_PUB.PROCESS_ITEM_ORG_ASSIGNMENTS
--Checked for currency on 14-OCT-2014--

Symptoms

When attempting to run the EGO_ITEM_PUB.Process_Item_Org_Assignments API,
the following error occurs.

ERROR

Calling EGO_ITEM_PUB.Process_Item_Org_Assignment API
=========================================
Return Status: U
Error Messages :
Unexpected error occured in package EGO_ITEM_PVT procedure Process_Item_Org_Assignments: ORA-01403: no data found.

STEPS

The issue can be reproduced at will with the following steps:
Run the API e.g.
EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG(
P_API_VERSION => l_api_version
, P_INIT_MSG_LIST => l_init_msg_list
, P_COMMIT => l_commit
, P_INVENTORY_ITEM_ID => Null ---l_inventory_item_id
, P_ITEM_NUMBER => l_inventory_item ---p_segment1 -- 'SU_ASG_ITEM1'
, P_ORGANIZATION_ID => NULL
, P_ORGANIZATION_CODE => l_organization_code
, P_PRIMARY_UOM_CODE => l_primary_uom_code
, X_RETURN_STATUS => x_return_status
, X_MSG_COUNT => x_msg_count
);


EGO_ITEM_PUB.PROCESS_ITEM_ORG_ASSIGNMENTS(
P_API_VERSION => l_api_version
P_INIT_MSG_LIST => l_init_msg_list
P_COMMIT => l_commit
P_ITEM_ORG_ASSIGNMENT_TBL => l_item_org_assignment_tbl
X_RETURN_STATUS => x_return_status
X_MSG_COUNT => x_msg_count
);

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