My Oracle Support Banner

Install Base Create Item Instance Post Hook Call Issue (Doc ID 1514378.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Installed Base - Version 12.1.2 to [Release 12.1]
Information in this document applies to any platform.


In the IB JSP screen, when creating an item instance, the instance is first created and a physical record is inserted on the csi_item_instance table and then the hook is called CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post. Meaning that one can query, join or refer the CSI_ITEM_INSTANCES table in the post hook for the newely created record to enforce the custom functionality.

In the new OAF IB page, the physical record does not exists in the CSI_ITEM_INSTANCE table (meaning IB is not created) when the post hook is called, therefore any query to select or join will result in zero row selection. The item instance is created after the call to the post hook and the physical record is inserted into the table. This is about the timing when the post hook is called.

Expect a physical record (IB created) when the post hook is called.

The issue can be reproduced at will with the following steps:

1. Enable custom hook

2. Create Item Instance


To view full details, 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 a vibrant support community of peers and Oracle experts.