You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

In the EPBCS application

In the EPBCS application under data exchange we are giving SQL expression sql("CASE WHEN $UD4$ LIKE 4% THEN ‘DATA * -1’ ELSE 'DATA’ END" ) here we are referencing UD1 AND DATA AS data column name but we are getting error as column not inserted or incase if prefix $DATA$ ($ PREFIX with data) in and out parameter error.

WE are following the below syntax:

syntax given in oracle ADMIN GUIDE:

The parameters are sql(""). For example, to return the value "S1" when the UD4 source value is "031010," or otherwise return the value "S2", specify the SQL expression: sql("CASE WHEN $UD4$ = ’031010’ THEN ‘S1’ ELSE ‘S2’ END")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!