My Oracle Support Banner

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 to [Release 1.0]
Information in this document applies to any platform.


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”


To view full details, 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 a vibrant support community of peers and Oracle experts.