Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
oraext:query-database() not able use in requisition BPM workflow — Cloud Customer Connect
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

oraext:query-database() not able use in requisition BPM workflow

Received Response
21
Views
3
Comments
edited Dec 30, 2021 8:24AM in Self Service Procurement 3 comments

Summary:

We are trying to use below query in a new participant in BPM workflow , but the when we submit the requisition for approval it is getting auto rejected

oraext:query-database(concat("WITH CC_APPROVER AS (SELECT pu.username Approver FROM hz_ref_entities MRE ,per_users pu WHERE 1 = 1 AND UPPER(MRE.attribute_category) = upper('Procurement_Approval_Matrix_C') AND upper(pu.username) = upper(MRE.EXTN_ATTRIBUTE_CHAR011) AND MRE.EXTN_ATTRIBUTE_CHAR007 = 'US ABC' AND MRE.EXTN_ATTRIBUTE_NUMBER008 <= (SELECT SUM(prl.ASSESSABLE_VALUE) req_total FROM por_requisition_lines_all prl,por_requisition_headers_all prh WHERE 1=1 AND PRH.requisition_header_id = PRL.requisition_header_id AND prh.REQUISITION_HEADER_ID = ", /task:task/task:payload/ns1:findReqHeaderDimensionResponse/ns1:result/ns2:RequisitionHeaderId, " AND NVL(prl.LINE_STATUS, 'N') <> 'CANCELED' AND prl.ASSESSABLE_VALUE is not null GROUP BY prh.REQUISITION_HEADER_ID) ORDER BY MRE.EXTN_ATTRIBUTE_NUMBER006) SELECT zzz.approver from CC_APPROVER zzz"),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!