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
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