Hi,
When creating custom attributes, for inbuilt enumerations, I can use:
enumeration_name_Api.decode(‘db_value’);
But when I create a custom enumeration and try to use the same expression, it gives me errors.
Any idea on how to access a custom enumeration using a statement?
Error:
CUSTOM_ENUMERATION_API"."DECODE": invalid identifier
Please help
shared with 
.
Hello Mayura!!!!! :)
Really nice to hear from you!
Thank you!
Hello,
Nevermind, I figured it out. It should be:
enumeration_name_CFP.decode(‘db_value’);
Thank you!
Hello Mayura!!!!! :)
Really nice to hear from you!
Thank you!
I’ve used something like:
select db_value from CUSTOM_FIELD_ENUM_VALUES
where lu = 'CUSTOM_ENUM_NAME'
Replacing “CUSTOM_ENUM_NAME” with the actual name of the enumeration. Nice and simple. There’s probably a more elegant way using an API, but..
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.