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

Create reference automatically between requests using execution command

SOLVED
Go to solution
Highlighted
Nagy Istvan
Occasional Contributor

Create reference automatically between requests using execution command

Hi,

 

Would you please give me some idea how we could solve that issue:

(PPM version 9.12)

 

We would like to cereate a reference automatically  between two requests.

  • Is there any execution command for this ?  I do not find any in the docs.
  • The there is no way create it using execution command, is there any other way ? Developing some java code ? Webservice (checked the WS doc, but have not found any) ? Or any other way , eg. database script ?

If anyone has done that before, would you please share the experiences .

 

Thanks a lot

    Istvan Nagy

6 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: Create reference automatically between requests using execution command

Hi Nagy,

What kind of reference you want to create, like request,package, url.. etc.

You can automatically create a reference and can attach it with any request of package; depending on your requirement.

This can be done from back-end by using... (This will create a reference between two requests)


KCRT_REQUEST_UTIL.create_references function.

Make sure you pass correct parameter

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Nagy Istvan
Occasional Contributor

Re: Create reference automatically between requests using execution command

Dear Utkarsh Mishra,

 

Thanks a lot. I have tried it using sql developer, it works fine.

declare
  a varchar2(100);
begin
 a := KCRT_REQUEST_UTIL.create_references(20,59031,20,,1,16,630);
end;

 

But I am not able to call that function from the PPM , because I get an errormessage:(I use selec ... from dual)

 ora-14551 cannot perform a dml operation inside a query

 

I have tried to put that call into a function, it does not work either...

Any idea to run that from PPM (rule or execution) ?

 

 

Thanks

    Istvan

Nagy Istvan
Occasional Contributor

Re: Create reference automatically between requests using execution command

I mean procedure. I could not call procedure from PPM... (function must not have actions like that)

Kerim KILIC
Frequent Visitor

Re: Create reference automatically between requests using execution command

hi, try pl/slq function in the execution type then call with kcrt_request_util.create_reference.
Utkarsh_Mishra
Honored Contributor
Solution

Re: Create reference automatically between requests using execution command

In order to call a procedure in PPM, you need to used command based execution step..

 

Here you can create a function, in that function call the UTIL procedure and return a value. The function can be directly called within execution step. Below is the snippet for the same.

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Nagy Istvan
Occasional Contributor

Re: Create reference automatically between requests using execution command

Thanks a lot, it works fine !

//Add this to "OnDomLoad" event