Instance Statuses Not Derived From Install Base Profile Options
Last updated on MAY 19, 2017
Applies to:Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.
There are logical errors within the CSI_ITEM_INSTANCE_PVT package. The Update_Item_Instance procedure contains hard coded status settings instead of using the CSI: Instance Termination Status and CSI: Default Instance Status profile options. Additionally there is an incorrect NULL comparison within a vital IF...THEN clause (Code says 'IF x = NULL THEN...' which is not valid - it should be 'IF x IS NULL THEN...')
Hard codes value assignments should be removed and replaced by use of the CSI: Instance Termination Status and CSI: Default Instance Status profile option values
The incorrect NULL comparison should be corrected.
Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Create customer statuses
2. Set "CSI: Instance Termination Status" and "CSI: Default Instance Status" profiles to custom values
3. Create new instance or expire existing instance
4. Notice that instance statuses are set to hard coded seeded values not values from the profile options
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms