Designer->Global objects->Globla User Functions->
Here i have some folders like
Conversion Operation ->TO_CHAR_FORMAT function
Substitution ->GET_SCEN_NAME - For this in implementation ODI related stuff to get the scenario name which etl now it is running.
etc like that
My problem is sometimes i am not bale get the value of GET_SCEN_NAME,TO_CHAR_FORMAT
like WHERE PACKAGE_NAME='GET_SCEN_NAME()'
some time it works fine,
why it is not getting the value of that functions.