My Oracle Support Banner

Ahl_mc_itemgroup_pvt Coding Issue "= Null" In If Condition (Doc ID 1269343.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When using public API
AHL_MC_ITEMGROUP_PUB.PROCESS_ITEM_GROUP (in AHLPIGPB.pls) and in this API, AHL_MC_ITEMGROUP_PVT.MODIFY_ITEM_GROUP (in AHLVIGPB.pls) is called. In this private tree, there are some IF condition has "= NULL" condition to check if the value is null, instead it should have been coded as "IS NULL".

Checked latest AHLVIGPB.pls 120.6.12010000.4 and found following:
*********************
REM PACKAGE NAME
REM AHL_MC_ITEMGROUP_PVT

[line 1169] ELSIF (l_x_item_assoc_rec.quantity = null ) THEN
[line 1178] ELSIF (l_x_item_assoc_rec.uom_code = null) THEN
[line 1552] IF (l_item_assoc_rec.REVISION = NULL) THEN
[line 1558] IF (l_item_assoc_rec.PRIORITY = NULL) THEN

(skipping..)

[line 1675] IF (l_item_assoc_rec.ATTRIBUTE15 = NULL) THEN
[line 2218] IF (l_item_group_rec.DESCRIPTION = NULL) THEN

(skiping...)

[line 2308] IF (l_item_group_rec.ATTRIBUTE15 = NULL) THEN
*********************

Because of above coding, the columns are getting updated to NULL and the original value is lost during update.

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