Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Having trouble getting this table-based Value Set to work
Summary:
Value Set in Fast Formula
Content (required):
I have been wracking my brain all night/day on this one. The SQL works fine in BI but when I use it as a Value Set in my Fast Formula, it returns nothing
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
FROM clause: BEN_ELIG_PER_ELCTBL_CHC bepec , BEN_REL_ASSIGNMENTS_F braf , ben_pl_f bpf
Value Column Name: bpf.name
WHERE clause: 1=1
and bepec.benefit_relation_id = braf.benefit_relation_id
and braf.person_id = :{PARAMETER.PERSON_ID}
Tagged:
0