Validation Condition With TO_NUMBER Function In Product Rules Definition Not Validating
Last updated on MARCH 08, 2017
Applies to:Oracle Fusion Product and Catalog Management - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
"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)
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.
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