Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Creation of a Request out of a Project

Highlighted
Niraj Prabhu
Frequent Visitor

Creation of a Request out of a Project

Can you tell me the best way to create a request from PPM Project.
Thanks!
Niraj
Niraj P.
9 REPLIES
Richard Woodman
Super Collector

Re: Creation of a Request out of a Project

Niraj,

Can you provide a little more detail on what you are trying to do?

The Project Details tab in the Project Summary page is actually a demand request with an associated workflow. Within the workflow you can create a workflow step that spawns another demand request by using the ksc_copy_request command.
Niraj Prabhu
Frequent Visitor

Re: Creation of a Request out of a Project

Hi,

Thanks your msg.

I am using following code to generate the request out of a Project. The request gets created, but doesnt get attach to the Project in the References section.

Kcvs_utilities.create_request
(p_request_id => '[REQ.REQUEST_ID]'
,p_request_type_name => 'test_rt'
,p_workflow_name => 'test_workflow'
,p_user_id => '[SYS.USER_ID]'
,p_copy_same_token => 'TRUE'
,p_copy_notes => 'FALSE'
,p_create_reference => 'Y'
,p_ref_relation => 'CHILD OF THIS REQUEST'
,p_validation_name => 'KCVS Create Request'
,p_status_name => 'New')

Give me your thoughts on this.

Thanks!
Niraj
Niraj P.
Niraj Prabhu
Frequent Visitor

Re: Creation of a Request out of a Project

Hi,

With the above utility code, I could see that the Test request created has the Project relation in the References section. What I dont see is the Reference in the Project.

Please suggest!

Thanks,
Niraj
Niraj P.
Niraj Prabhu
Frequent Visitor

Re: Creation of a Request out of a Project

Hi,
Do anyone know about the way we can attach the request to the Project in References tab?
Regards,
Niraj
Niraj P.
Jason Nichols K
Honored Contributor

Re: Creation of a Request out of a Project

Niraj,

I have done something very similar, but used the ksc_copy_request special command instead. Behind the scenes, it uses the same utility, so this should work. That utility does make the Reference associatioin with the Request entity for the Project, but not the Project entity. This code after the utility code will create the Project reference:

UPDATE KNTA_REFERENCES SET
REF_RELATIONSHIP_ID = 403
, SOURCE_ENTITY_ID = 6
, SOURCE_ID = PROJECT_ID
, ORIGINAL_SOURCE_ID = PROJECT_ID
WHERE SOURCE_ID = P_FROM_REQUEST_ID
AND PARAMETER1 = TO_CHAR(O_REQUEST_ID);

UPDATE KNTA_REFERENCES SET
REF_RELATIONSHIP_ID = 400
, TARGET_TYPE_CODE = '6'
, PARAMETER1 = TO_CHAR(PROJECT_ID)
WHERE SOURCE_ID = O_REQUEST_ID
AND PARAMETER1 = TO_CHAR(P_FROM_REQUEST_ID);


I hope this helps.

Jason
Richard Woodman
Super Collector

Re: Creation of a Request out of a Project

Isn't there a field group for Project Reference that has to be added to the Request Type Header to allow the reference between the project and the request? What if you added the field group for Project Reference and then populated the field with the project number? Would that create the reference you are looking for?
Niraj Prabhu
Frequent Visitor

Re: Creation of a Request out of a Project

Hello Richard,

Thanks for your reply.

The Request already have the reference to the Project and can be seen in the References section.

But the Project References Tab doesnt add the created request.

Regards,
Niraj
Niraj P.
Semenov Alexand
Esteemed Contributor

Re: Creation of a Request out of a Project

Hi Niraj.
See best way in attaschment
Niraj Prabhu
Frequent Visitor

Re: Creation of a Request out of a Project

Issue Resolved.
Niraj P.
//Add this to "OnDomLoad" event