JTF Create Install Base User Hook Not Being Called (Doc ID 2506904.1)

Last updated on JULY 14, 2020

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
The create_item_instance_post is not getting called in CSI_ITEM_INSTANCE_CUHK

EXPECTED BEHAVIOR
-----------------------
Expect create_item_instance_post to get called in CSI_ITEM_INSTANCE_CUHK

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

Step1
-----
Add the following code to package body for CSI_ITEM_INSTANCE_CUHK:
PROCEDURE create_item_instance_post
(
p_api_version IN NUMBER
,p_commit IN VARCHAR2 := fnd_api.g_false
,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
,p_instance_rec IN csi_datastructures_pub.instance_rec
,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
,p_party_tbl IN csi_datastructures_pub.party_tbl
,p_account_tbl IN csi_datastructures_pub.party_account_tbl
,p_pricing_attrib_tbl IN csi_datastructures_pub.pricing_attribs_tbl
,p_org_assignments_tbl IN csi_datastructures_pub.organization_units_tbl
,p_asset_assignment_tbl IN csi_datastructures_pub.instance_asset_tbl
,p_txn_rec IN csi_datastructures_pub.transaction_rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS

l_debug_level NUMBER;

BEGIN

-- Set return status
x_return_status := FND_API.G_RET_STS_SUCCESS;

l_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
IF (l_debug_level > 0) THEN
csi_gen_utility_pvt.put_line( 'XXDMX Inside create_item_instance_post');
END IF;

END create_item_instance_post;

Step 2
-------
Enable Hook:
UPDATE jtf_user_hooks
SET execute_flag = 'Y'
WHERE pkg_name = 'CSI_ITEM_INSTANCE_PUB'
AND api_name IN ('CREATE_ITEM_INSTANCE','UPDATE_ITEM_INSTANCE','EXPIRE_ITEM_INSTANCE')
AND user_hook_type = 'C'
AND processing_type = 'A';

Step 3
-------
Tuen on CSI Debug profile option.

Step 4
------
Create a new Install Base Instance in the Installed Base user interface.

Changes

Cause

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