Fusion PIM: Enhancement Request - Introduce NVL (IFNULL / ISNULL Replace) Functon In Item Rules (Doc ID 1943764.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Fusion Product Model - Version 11.1.8.0.0 to 11.1.10.0.0 [Release 1.0]
Information in this document applies to any platform.

Goal

Requirement is for the equivalent of the SQL Plus NVL function in Item Rules (Also called ISNULL / IFNULL replace).

At this moment you can only test on 'isnull', but requirement is to replace the value of an attribute when it is null.
Null values in general cause the validation to be ignored, unless you explicitly want to test for a null value with the “isnull” function.

For example: a logical_attribute can be TRUE, FALSE or null.
In SQL: where nvl(logical_attribute, “FALSE”) = “TRUE”
 

Solution

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