Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Transaction table is not storing the details of all offer approvals
Summary:
Hi Team,
We have a requirement to get the offer approval history from transaction table. The issue we are facing is the table we are using does not have the details of all offer approval transactions and we are not able t find a reason/pattern for the missing data.
Some completed transaction information is retrieved from the query and some are not.
Transaction present but query not retrieving data:
This is query we are using:
select
wft.*,
irv.REQUISITION_NUMBERfrom fA_FUSION_SOAINFRA.WFTASK wft,
IRC_OFFERS iof, IRC_SUBMISSIONS isub , irc_requisitions_vl irv
where irv.REQUISITION_ID (+) = isub.REQUISITION_ID
Tagged:
0