You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!