How to enable AFX Custom Variables

[PaulCherrier]

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

[PaulCherrier · Accepted solution]

https://community.rsa.com/docs/DOC-47428