×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Name change in Workflow

Name change in Workflow

Name change in Workflow

(OP)
Hi,Please read below query and please reply the solution for this problem...

My company asked me to change work flow for Name Change.
We are in ver 8.9 ( Tools 8.49 ).

 Requirement is Change vanilla work flow from payroll administrator
to Compensation Advisor. Compensation Advisor should get email and worklist, after submit the name change request. Then he will approve.

So I create a new role ( COMPENSATION ADVISOR ) add attached
new query role ( _ROLE_COMP_ADVISOR ). I mapped new role for oprid in the activity.
Below is my sql for


_ROLE_COMP_ADVISOR ( role query ).


SELECT A.ROLEUSER
  FROM PS_ROLEXLATOPR A, PS_GPI_TRNSSEC_VW2 B, PS_CURRENT_JOB C, PS_EMPLMT_SRCH_QRY C1, PS_PER_ORG_ASGN D, PS_EMPLMT_SRCH_QRY D1
  WHERE C.EMPLID = C1.EMPLID
    AND C.EMPL_RCD = C1.EMPL_RCD
    AND C1.OPRID = 'test1'
    AND D.EMPLID = D1.EMPLID
    AND D.EMPL_RCD = D1.EMPL_RCD
    AND D1.OPRID = 'test1'
    AND ( B.OPRID = A.OPRID
     AND B.PAY_OFFICE_CD = D.PAY_OFFICE_CD
     AND B.PAY_LIST_CD = D.PAY_LIST_CD
     AND C.EMPLID = D.EMPLID
     AND D.EMPL_RCD = D.ORG_INSTANCE_ERN
     AND C.EMPL_RCD = D.EMPL_RCD
     AND B.GPI_CREATE_IND = 'Y'
     AND B.GPI_ALTERNATE_IND = 'N'
     AND C.HR_STATUS = 'A'
     AND C.EMPLID = :1 )


    
I am using prompt for userid. Above query is working fine. When I run above query,
three compensation advisors are fetched for my emplid.


When I click submit button for Name Change,
I am getting below errors.

could not find bind value EMPLID for role query.
A bind value could not be found in the current page for a role query
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close