Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Name change in Workflow

Status
Not open for further replies.

query76

Programmer
Nov 24, 2011
1
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top