Instance Statuses Not Derived From Install Base Profile Options (Doc ID 1569843.1)

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.

Symptoms

Actual Behavior
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...')

Expected Behavior
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

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