Skip to Main Content

Developer Community

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

3205: 'buyer@domain.com’ is not a valid role or user name for a valid buyer email when setting #WFM_REPLYTO.

Ron BartlingSep 6 2024 — edited Sep 6 2024

We are retrieving the buyers email address in our PO Approval workflow by linking PO_HEADERS_ALL.AGENT_ID to PER_ALL_PEOPLE_F.PERSON_ID.

We then set #WFM_REPLY to, which is defined as a ROLE in the workflow

wf\_engine.SetItemAttrText(itemtype => itemtype  
                        ,itemkey  => itemkey  
                        ,aname    => '#WFM\_REPLYTO'  
                        ,avalue   => l\_buyer\_email);

This is generating at runtime the following (actual email changed to generic):

Error Message
3205: 'buyer@domain.com’ is not a valid role or user name

Error Stack
Wf_Engine.SetItemAttrText(POAPPRV, 6159477-672548, #WFM_FROM, buyer@domain.com) XXPO_WF_CUSTOM.XXPO_SET_REPLYTO.XXPO_WF_CUSTOM.SET_REPLYTO: 01:ORA-20002: 3205: 'buyer@domain.com' is not a valid role or user name.() Wf_Engine_Util.Function_Call(XXPO_WF_CUSTOM.XXPO_SET_REPLYTO, POAPPRV, 6159477-672548, 339963, RUN)

However we are able to create the PO using that user so it is a valid user.

We had this same basic logic working prior to a clone so are puzzled why we are now getting the error, particularly since we know the buyer and buyer's email are valid and active.

Comments
Post Details
Added on Sep 6 2024
0 comments
95 views