You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Name change Workflow using PS role query

2 replies [Last post]
Guest's picture
Guest

Hi All, Please take sometime to review below query ::

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_DI_COMP_ADVISOR ). I mapped new role for oprid in the activity.
Below is my sql for
_ROLE_DI_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 = 'test11'
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.

I need to change any thing else to trigger work flow. Please let me know.

ashok_star2004's picture
User offline. Last seen 30 weeks 1 day ago. Offline
Joined: 02/13/2009
Posts: 45
Re: Name change Workflow using PS role query

Hi,

You need to specify the binds to your role query in the Worklist field mapping. After giving the Role name in the field mapping, click on the Specify binds and map the binds.

Regards

Guest's picture
Guest
Re: Name change Workflow using PS role query

I already clicked on the specify binds and selected the fields. however, i still got the same issue. :(