12.1.3 Create Item Instances Does Not Handle User Hook Error Messages (Doc ID 1921046.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Support Codes

Added a custom user hook on create item instance, using CSI_ITEM_INSTANCE_CUHK.create_item_instance_pre. Made sure that jtf_user_hooks table was updated correctly for both package CSI_ITEM_INSTANCE_GRP and CSI_ITEM_INSTANCE_PUB. The 11.5.10 create item instance page gives the complete error message but the 12.1.3 page only gives the word "Error". The complete error message is not shown. I have also setup the same for Update item Instances and it works correctly for both the 11.5.10 and 12.1.3 versions. See attaches for screenshots, jtf_user_hooks query results and csi_item_instance_cuhk source.
the following error occurs.

ERROR
-----------------------
 "Error"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a customer user hook on create item instance, using CSI_ITEM_INSTANCE_CUHK.create_item_instance_pre
2.Made sure that jtf_user_hooks table was updated correctly for both package CSI_ITEM_INSTANCE_GRP and CSI_ITEM_INSTANCE_PUB.
3.create item instance page gives the complete error message but the 12.1.3 page only gives the word "Error".


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