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.
We need a value set through which we can auto generate the incident numbers.
Summary:
We are looking to setup a value set through which we can auto generate incident numbers where incident number is a DFF on DOR. We are trying to create a Value set with a SQL query but not sure how to insert the Select clause based on which the query will run. Can someone please help on this?
Query -
select max(HRD.DEI_ATTRIBUTE2)+1
from HR_DOCUMENTS_OF_RECORD HRD, per_all_people_f papf
where
papf.person_id = HRD.person_id
and HRD.DEI_ATTRIBUTE_CATEGORY = 'GB_ACCIDENT_PART_A'
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
0