

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hello,
To update staffing profile status from the request workflow, you could use special command Ksc_set_staffing_profile_status.
for example:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hello,
To update staffing profile status from the request workflow, you could use special command Ksc_set_staffing_profile_status.
for example:


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
This worked! Thanks!