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.
Earliest Tracking History User Comment for the specified Transaction Event Type
Summary
For each requisition show the Earliest Tracking History User Comment for the specified Transaction Event TypeContent
The following is one of the columns needed for several reports being converted to OBI:
- For each requisition on the report, show the requisition’s "Requisition Tracking History"."Transaction User Comments" where the following are true:
- "Requisition Tracking History"."Transaction Event Type" = 'Requisition Approval Requested'
- the "Requisition Tracking History"."Req. History Transaction Date" is the earliest of the requisition’s rows containing "Requisition Tracking History"."Transaction Event Type" = 'Requisition Approval Requested'
- “Requisition Tracking History"."Transaction User Comments" is not null.
Multiple CASE statements have been attempted resulting in the correct result for some, incorrect for others. Please help.
0