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.
Flexfield SQL to return employee work location when Manager is adding the DoR
I am trying to create a DFF segment in document records that will default an employee's work location. This DoR will be available only to Managers to add. Does anyone have an SQL that will return the work location value of the employee for whom Manager is adding the document?
I have tried using the logic of paam.assignment_id = :{PARAMETER.ASSIGNMENTID} but it doesn't return any value in document. When I hardcode the assignment id in the SQL, it returns the location of that assignment, so the query seems to be working fine. Is this paam.assignment_id = :{PARAMETER.ASSIGNMENTID} correct? I am unable to use PERSONID as the DFF segments throws up error.
Tagged:
0