Database Software

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!

Workflow error Error>> ORA-20002: 3205: 'PER_ROLE:638' is not a valid role or user name

1656342Feb 22 2016 — edited Mar 22 2016

Hi,

We are upgrading our EBS from R12.0.6 to R12.2.5. There is custom workflow having several attributes as a role, that is working fine in R12.0.6 but same is throwing error in R12.2.5 Error>> ORA-20002: 3205: 'PER_ROLE:638' is not a valid role or user name where 638 us person_id (per_people_f).

Please guide me where it is going wrong.

SEND_TO_PR_REQUESTER is attrubute of role type;

-----------------------------------------------------------------------------------------------------------------------------

wf_engine.setitemattrtext (itemtype,

itemkey,

'SEND_TO_PR_REQUESTER',

'PER_ROLE:' || po_rcpt_rec.requestor_id

);

Regards

Pravin Khandekar

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2016

Added on Feb 22 2016

#database-key-features, #workflow

1 comment

7,473 views