My Oracle Support Banner

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

Last updated on OCTOBER 15, 2020

Applies to:

Oracle Fusion Product and Catalog Management - Version 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 :


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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.