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

Internal Supplier Profile Change FYI notifications going to fusion_apps_prj_adf_appid

We have a requirement to send internal supplier profile change request FYI notifications to approval groups of all the BU's associated with the any of the supplier sites for that supplier except the Requestor's BU approval group. For this, we have modified the BPM task ProfileChangeRequestFYI and added an assignee with query as:

oraext:query-database-with-bindvar('SELECT LISTAGG(distinct(fwgm.member),',') approval_list FROM HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft, fa_fusion_soainfra.wfapprovalgroups fwg, fa_fusion_soainfra.wfapprovalgroupmembers fwgm, poz_supp_requests psar,poz_supplier_sites_v psv, per_all_assignments_m paam,per_all_people_f papf WHERE haouf.ORGANIZATION_ID = hauft.ORGANIZATION_ID AND hauft.LANGUAGE = 'US' AND hauft.EFFECTIVE_START_DATE = haouf.EFFECTIVE_START_DATE AND hauft.EFFECTIVE_END_DATE = haouf.EFFECTIVE_END_DATE AND SYSDATE BETWEEN hauft.effective_start_date AND hauft.effective_end_date AND hauft.organization_id = psv.prc_bu_id and psar.vendor_id = psv.vendor_id AND fwg.approvalgroupid = fwgm.approvalgroupid AND fwg.approvalgroupname = hauft.NAME and psar.request_by_person_id = papf.person_id and papf.person_id = paam.person_id and hauft.organization_id <> paam.business_unit_id AND psar.change_req_number=:bind_header_id',true(), true(),'jdbc/ApplicationDBDS', concat('bind_header_id=',/task:task/task:payload/task:changeRequestNumber))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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