AnsweredAssumed Answered

Provisioning command automatically cancels

Question asked by Paul Cherrier on Nov 9, 2017
Latest reply on Nov 14, 2017 by Boris Lekumovich

We are building new provisioning commands to an oracle database and for some reason it defaults to Canceled every time without notice. What causes Work Items to be canceled?

 

 

Data

${jobUserData_username}
${jobUserData_FIRST_NAME}
${jobUserData_last_name}
${jobUserData_middle_initial}
${jobUserData_email_address}
${jobUserData_SUPERVISOR_IAM_ID}
${jobUserData_IAM_ID}
${jobUserData_Start_Date}

 

Query

SELECT u.first_name
     , u.last_name
     , u.middle_initial
     , SUBSTR(u.first_name,1,1)||u.middle_initial||u.last_name AS username
     , u.email_address
     , s.user_id AS SUPERVISOR_IAM_ID
     , u.user_id AS IAM_ID
     , u.cost_center
     , sysdate as Start_Date
from avuser.pv_users u, avuser.pv_users s
where s.id = u.supervisor_id
  and u.id = (select distinct(affected_user_id)
            from avuser.pv_change_request_activity
            where change_request_id= '${access_request_requestID}'
              and value_type = 'User')

 

 

Outcomes