My Oracle Support Banner

EGO_ITEM_PUB.Process_items Does Not Return All Error Messages (Doc ID 858283.1)

Last updated on JULY 02, 2017

Applies to:

Oracle Product Hub - Version 12.0.3 to 12.0.6 [Release 12]
Information in this document applies to any platform.

Symptoms

While using EGO_ITEM_PUB.PROCESS_ITEMS for creating/updating items through interface, the API does not return errors for all the items that errored out.

For Ex, try to create 5 items using the API as shown below :

The below is the list of error messages retrieved from the error stack:

=====================================
Calling EGO_ITEM_PUB.Process_Items API
=====================================
Return Status: Ereturned err count:4
1: Failed
2: Failed
Inventory Item Id :3:32950
Organization Id :3:82
4: Failed
5: Failed
=====================================
Error Message Count :1
1:5:MTL_SYSTEM_ITEMS_B
1:The TEMPLATE_ID or TEMPLATE_NAME specified is not a valid template.

Note: See that errors are returned but only the last error is shown.
* For a sample of the API code code, refer <Note 728350.1>.


-- Expected Behavior:
Expect to see 4 Error messages are returned in the above case

Cause

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
Symptoms
Cause
Solution
References

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