Option to add SQL based FYI BPM stage rule for ReqApproval
Summary:
With RSSP we dont have option to add approvers at the stage level, I am looking to add a new stage to include project approvers in the requisition BPM rule to receive FYI notification. Is it possible to provide SQL based FYI notification rule?
When I add I get attached null values. Please advise.
User Rule Query: FYI Notification type
orcl:query-database(concat('select pi_name_fyi from (select distinct prh.requisition_number, prh.requisition_header_id , prd.pjc_project_id,gapi.pi_name,pu.username pi_name_fyi from por_requisition_headers_all prh,por_requisition_lines_all prl, por_req_distributions_all prd, gms_award_projects gap, okc_k_headers_vl okv, gms_award_pi_v gapi,per_users pu where prh.requisition_header_id = prl.requisition_header_id and prl.requisition_line_id=prd.requisition_line_id and prd.pjc_project_id is not null and gap.project_id=prd.pjc_project_id and gap.award_id= okv.id and okv.version_type=''C'' and okv.id = gapi.id and sysdate between gapi.start_date and nvl(gapi.end_date, sysdate + 1) and pu.person_id=gapi.person_id ) where requisition_header_id= ',/task:task/task:payload/ns4:findReqHeaderDimensionResponse/ns4:result/ns2:RequisitionHeaderId),false(),false(),'jdbc/ApplicationDBDS')