AnsweredAssumed Answered

How to enable AFX Custom Variables

Question asked by Paul Cherrier on Dec 6, 2019
Latest reply on Dec 6, 2019 by Paul Cherrier

How do we utilize the AFX Custom variables from a workflow to an Oracle DB connector? We're getting the following error:

AFX can not process this change item because a runtime value can not be found for the following required variables: ${Custom.USERNAME}, ${Custom.TEMP_PASS}, ${Custom.IAM_ID}

but the variables are populated in the workflow.

 

Query (Username and ID)

 

SELECT
UPPER(SUBSTR(u.first_name,1,1)||u.last_name) as AFXCUSTOM_CUSTOM_USERNAME,
u.user_id as AFXCUSTOM_CUSTOM_IAM_ID,
from avuser.pv_users u, avuser.pv_users s
where s.id = u.supervisor_id
  and u.id = (select affected_user_id
            from avuser.pv_change_request_detail
            where change_request_id=  '${access_request_requestID}'
              and id =  '${jobUserData_ChangeRequestItem.ItemId}'
              and value_type = 'User')

 

Query (Password)

 

select 'PVT3mpP@$s' ||
trunc(dbms_random.value(1,9999))
|| dbms_random.string('u',1)
|| dbms_random.string('l',1)
|| substr(sym,dbms_random.value(1,length(sym)),1)
|| dbms_random.string('a',4) as AFXCUSTOM_CUSTOM_TEMP_PASS
from (select '!@#$%^&*()_+=-?:<>}{|\' as sym from  dual)

 

Connector

 

Populated variables from Workflow

 

 

Error

Attachments

Outcomes