Hi All,
I have an use case where contractor users can be onbarded using VIA portal.
1. I have created a request form to accept user firstname, lastname, department and date of joining.
2. I have created a table in local database (AVDB) and a stored procedure to accept the parameters along with a sequence (for the user id attribute).
3. Now to provision the values entered in the form I am trying to create workflow that accepts the parameters given in the form and insert them to the table created in AVDB.
for example in the SQL EXECUTE node am trying to pass these parameters:
execute avuser.insertCONTRACTORS ('${avform.Lname}','${avform.Fname}', '${avform.Dept}', '${avform.DOJ}');
But the above is not working as the sql node giving error for the above execute command saying "INVALID SQL COMMAND".
May I know how to resolve this or is there any better way to achieve this?
(NOTE: My plan is after we insert the data into a table, I can create an Identity Collector to pull back the user and create an account in VIA)
This means there is no item int he CR to be processed. Is there a "Register User Command (Non-Visual)" control on the form? If so, then check the CR generated by running the form and make sure there is a item to create an account for the user. If that also checks out, then verify the "Create Account" capability is enabled on the Connector.
Hope this helps.