Expression Builder to Create SOURCE FILTERS: Unable To Fully Define Standard Functions (i.e. NVL)

(Doc ID 2405205.1)

Last updated on MAY 30, 2018

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.

Goal

DMW 2.4.7

Using Expression Builder to create Source Filters within a Transformation.

However, you cannot add a comma and default value parameter using the Expression Items. For example, try using the NVL Standard Function in the Expression Builder adding commas and hit:

ERROR
------------
DMW-###: "cannot add a comma and default value parameter using the Expression Items"
or
DMW-###: "The expression is invalid. The validation process failed with error invalid number of arguments"



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