Updating Staffing Profile status From the Request Workflow - Can this be done using Ksc_run_sql?

[cABany]

What I'm attempting to do is update the Staffing Profile status based on the an action taken in the request workflow.

I was trying to build an execution step that would do this but it's failing every time.

I'm running ksc_run_sql... 

ksc_run_sql QUERY_STRING="UPDATE rsc_staffing_profiles set status_code = 1 where container_entity_id = [REQ.REQUEST_ID];" ENV_NAME="[SOURCE_ENV.ENVIRONMENT_NAME]"

Perhaps I can't run an Update statement here?

KSC SQL Query

Source Command:update_status

Running query: UPDATE rsc_staffing_profiles set status_code = 1 where container_entity_id = 33370;
Unexpected error!
ERROR: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Any ideas?

Thanks in advance.

[Sharon_Han · Accepted solution]

Hello,

To update staffing profile status from the request workflow, you could use special command Ksc_set_staffing_profile_status.

for example:

ksc_set_staffing_profile_status USE_NAMES_FLAG="N" STAFF_PROF_IDS="[REQ.P.KNTA_STAFFING_PROFILE]" STATUS_CODE="6"

Thanks,

SHaron

[cABany]

This worked! Thanks!