Project and Portfolio Management Practitioners Forum
cancel

Usage of ksc_move_request_workflow

Highlighted
Aravinth
Respected Contributor.

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
Acclaimed 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