Empty result returned from GET_VALUE_SET in time and labor fast formula
Summary:
When i try to return a value set with parameter from fast formula, no value returned. Can anyone advice on that? Below is my code snippet.
Version (include the version you are using, if applicable):
25C
Code Snippet (add any code snippets that support your topic, if applicable):
Below is the setting in Value Set, where correct value set could be returned in BIP. The fast formula work if i replace :pPerson into hardcoded person id.
__________________________________________________________
FROM Clause = HR_DOCUMENTS_OF_RECORD
Value Column Name = DOCUMENT_CODE
ID Column Name = DOCUMENTS_OF_RECORD_ID
WHERE Clause =
person_ID = :pPerson
Tagged:
0