Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Need to pull date from a valueset into an extract via a fast formula
Summary
Need to pull date from a valueset into an extract via a fast formulaContent
Hi Experts,
Need a quick help!
I have created a table validated valueset with a character data type.
I need to retrieve the previous action_date of an employee.
This query works fine for that in BI Publisher:
SELECT (pao1.ACTION_DATE)
FROM PER_ALL_ASSIGNMENTS_M paam_curr,
PER_ALL_ASSIGNMENTS_M paam_prev,
PER_ACTION_OCCURRENCES pao1
WHERE paam_curr.PERSON_ID=:{PARAMETER.P_PERSON_ID} (--replace this with an person id with more than 2 action changes in application)
AND paam_curr.ASSIGNMENT_TYPE='E'
Tagged:
1