The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Usage of ksc_move_request_workflow

Highlighted
Aravinth
Super Collector

Usage of ksc_move_request_workflow

Hi,
We are trying to use the 'ksc_move_request_workflow' special command and schedule it at one of our WF steps.
But we are having issues setting up the parameter 'SCHEDULE_DATE'.

a. We are getting the error "(KNTA-10127) Could not understand the parameter 00:00:00" while parsing the command com.kintana.crt.server.KSCMoveRequestInWorkflow" if the value is something like '2009-04-23 00:00:00'.
b. When we remove the time format we receive the error 'Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff'.

What should be the format that should go in here ?

Thanks,
PPMS User
1 REPLY
Mahen M
Honored Contributor

Re: Usage of ksc_move_request_workflow

See whether this query snippet works.

Select Period_name from PRODPITG.KTMG_PERIODS
where start_date = next_day(TRUNC(to_date('2009-03-30 00:00:00', 'yyyy-mm-dd hh24:mi:ss'))-7,'MONDAY')

Regards,
Mahendran M
//Add this to "OnDomLoad" event