My Oracle Support Banner

Bind Peeking Issue Due To Inventory Items Without EAM ORG ID But Marked As Eam_item_type (Doc ID 2799538.1)

Last updated on AUGUST 14, 2021

Applies to:

Oracle Enterprise Asset Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

While upgrading our EBS from 12.1.3 to 12.2.10, there is a performance issues associated with bind peeking due to Inventory Items with the flag eam_item_type set but associated with an organization without EAM ORG ID.
This attribute eam_item_type is controlled at master level and for this reason, we have in the system a lot of items with this flag set, indifferently if they are associated to EAM organization or not.
Whenever any process creates an CSI Instance, procedure csi_Item_Instance_Vld_pvt.Check_for_eam_item is called and only takes in consideration the eam_item_type flag. In our opinion, the column maint_organization_id in table mtl_parameters should be checked also. This behaviour is causing the invocation of procedure EAM_OBJECTINSTANTIATION_PUB.Populate_activity_defaults for inventory items not belonging to an EAM Org ID, producing a sub-optional execution plan because optimizer is using a NULL value for the bind ORGANIZATION_ID.

EXPECTED BEHAVIOR

This behaviour should not cause the invocation of procedure EAM_OBJECTINSTANTIATION_PUB.Populate_activity_defaults for inventory items
not belonging to an EAM Org ID.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create CSI instance in 12.2.10 via API.
2. Procedure csi_Item_Instance_Vld_pvt.Check_for_eam_item is called and only takes in consideration the eam_item_type flag.
3. This behaviour is causing the invocation of procedure EAM_OBJECTINSTANTIATION_PUB.Populate_activity_defaults for inventory items not belonging to an EAM Org ID.
4. This cause a NULL value for the bind ORGANIZATION_ID.

Changes

 

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
Changes
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.