Fusion PIM: Enhancement Request - Introduce NVL (IFNULL / ISNULL Replace) Functon In Item Rules
Last updated on NOVEMBER 08, 2016
Applies to:Oracle Fusion Product Model - Version 188.8.131.52.0 to 184.108.40.206.0 [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”
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