Validation Condition With TO_NUMBER Function In Product Rules Definition Not Validating (Doc ID 1635772.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Product and Catalog Management - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

Issue
--------

"Syntax Error at line 1 of Validation Condition. Correct the error before proceeding. (EGO-2745513)" displayed when setting up condition with To_Number function


there are 2 EFF attributes 1 numeric and 2 character ones

The first one is Item Net Weight which is defined as a numeric EFF with UOM class

The second one is Net Content which is defined as a character EFF BUT this field can contain alpha characters aswell as numeric values (e.g. EA,GR,KG aswell as 1,2,3)

The third one is Net Content UOM which is defined as a character field and contains UOM values

Now the equation that client is trying to set up is this

IF [net content UOM] (which is character data) = "KG"
THEN Item Net Weight must be smaller or equal to [Net Content]/1000

The issue here is that the [Net Content]field is a character field and the calculation is numeric so how to set up the validation

Attempt was made to define it like this :

TO_NUMBER([Item].[XX_GDSN_ITEM_DESCRIPTION].[SUB_BRAND]) > 10

where Sub_Brand is the character field being converted to a number field but a syntax error is given at this point "Syntax Error at line 1 of Validation Condition. Correct the error before proceeding. (EGO-2745513)

Expected Behaviour
-----------------------------
Should be able to cast the defined Char field to a numeric using the "TO_NUMBER" function so that it can be compared with another numeric field.

Cause

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