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

How to set up a FYI notification for negotiation team members when the negotiation is approved?

Received Response
41
Views
1
Comments

Summary:

Need to send automatically an FYI notification to the Negotiation team members when the negotiation is approved.

Content (please ensure you mask any confidential information):

I have tried with SQL in the NegApprovalStatusFYI and NegotiationApproval tasks in BPM but it didn't work:

orcl:query-database(concat('select pu.username from fusion.pon_neg_team_members pntm, fusion.per_users pu where pntm.person_id = pu.person_id and pntm.auction_header_id=',/task:task/task:payload/task:AuctionHeaderId), true(), true(),'jdbc/ApplicationDBDS')


Version (include the version you are using, if applicable):

23D

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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