Database Connector type is Oracle Provisioning comments is blank after completion of task.

[GeSaviynt]

Hi Team,

Issue is task is completed successfully and account is created in DB also, but provisioning comments and number of retries  for provisioning is blank in Saviynt.

Database type : Oracle

is it excepted behavior of DB connector? or is I am facing anything in configuration.

Thanks

Geeta

[This post has been edited by a Moderator to remove PII from the image..]

[rushikeshvartak · Accepted solution]

if task completed without error then retries & provisioning comments wont be updated.

[GeSaviynt]

Thanks for quick response @rushikeshvartak 

[kunaljain83]

Can you pass request form attributes as an input parameter to the stored procedure. I have to do this as the stored procedure is on a remote server.

{

  "createaccountqry": "SET @xx_debug_flag := 1; SET @xx_debug_message := '${requestAccessAttributes.get('Attribute1')}' ; CALL staging.spCRHChgOwn(@xx_debug_message)"

}

[rushikeshvartak]

{

  "createaccountqry": "SET @xx_debug_flag := 1; SET @xx_debug_message := '${Attribute1}' ; CALL staging.spCRHChgOwn(@xx_debug_message)"

}

[kunaljain83]

Hi Rushikesh, 

It worked. What is the parameter for passing requestkey and requestaccess attributes array.