we have a SQL rule in a request type that sets a field's value (Drop-down validated by list) based on some other field's value. We are in a multi-language environment using German and English.
If the rule is defined with a German text in the selection and someone logs into PPM with an English session, then the rule throws an error message: "Could not set field '<field name >' to value '<some German value>' in Rule 1 - '<Rule Name>'.
Does anyone know a way to make a SQL rule aware of the current session language and select the necessary value accordingly from the KNTA_LOOKUPS_NLS or KNTA_LOOKUPS_LOC table?
I already searched the available documentation with no success.
Thanks for your help!