Hi @JannetteC ,

Based on the requirement, I think your select statement should be like below.

select agreement_id from ifsapp.cc_support_agreement where customer_id = :owner

And the  arguments should be;

v.owner

Try these and see whether it works.

Hi @ThushAsanka , I have tried that but I am getting the same error message.

@JannetteC, just checked, and noticed that it’s not agreement_id, and it’s support_agreement_id.

So, it should be like below.

select support_agreement_id from ifsapp.cc_support_agreement where customer_id = :owner

Thanks,

Thanks @ThushAsanka I was missing the = sign, all good now.