Can we delete or cancel a project in 9.12

[Mohit_Agrawal]

Hi All,

I am new to project mgmt.

Can we delete or cancel a project in 9.12 version? so that it does not show any longer on the "My Actions (Pending Request)" list of the project manager. I see that actual cost has already been adjusted to zero.

Thanks

Mohit

[Natalia_R_PPM]

Hello Mohit,

Yes, We  can delete a project in PPM :

"Sometimes projects are created in error. Project managers can delete projects
from the Project Overview page. On the Project Summary tab of the Project
Overview page, click Delete to delete a project."

HP Project Management User’s Guide

I attached the Guide here with more information. Also you can follow the steps in the txt file.

Hope it helps.

Thanks

Regards,

Natalia Rojas

[Natalia_R_PPM]

Attached: ***********************************************************************************************
 -- Step1
***********************************************************************************************
CREATE TABLE temp_invalid_prjects (
  project_id NUMBER,
  project_name VARCHAR2(300 CHAR)
);

CREATE TABLE temp_invalid_project_types(
project_type_id NUMBER
);
***********************************************************************************************
--step 2
***********************************************************************************************
delete from temp_invalid_prjects;
delete from temp_invalid_project_types;

***********************************************************************************************
-- Step3
***********************************************************************************************
INSERT INTO temp_invalid_prjects
           (project_id, project_name)
  (select project_id,project_name from pm_projects
where project_id=<project_id>);
 
***********************************************************************************************   
 -- Step 4
***********************************************************************************************
select * from temp_invalid_prjects;

***********************************************************************************************
-- Step 5
***********************************************************************************************
UPDATE wp_tasks
  SET task_info_id = NULL
WHERE work_plan_id IN (SELECT work_plan_id
                         FROM pm_work_plans
                        WHERE project_id IN (SELECT project_id
                                               FROM temp_invalid_prjects));
                                               
***********************************************************************************************
--  Step 6
***********************************************************************************************
DELETE FROM wp_task_info
     WHERE unassigned_work_unit_id IN (
              SELECT work_unit_id
                FROM wp_work_units
               WHERE task_id IN (
                        SELECT task_id
                          FROM wp_tasks
                         WHERE work_plan_id IN (
                                  SELECT work_plan_id
                                    FROM pm_work_plans
                                   WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects))));     
                                                      
***********************************************************************************************
--  Step 7
***********************************************************************************************
DELETE FROM wp_work_units
     WHERE task_id IN (
              SELECT task_id
                FROM wp_tasks
               WHERE work_plan_id IN (
                              SELECT work_plan_id
                                FROM pm_work_plans
                               WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects)));  
                                                      
***********************************************************************************************
--  Step 8
***********************************************************************************************
DELETE FROM wp_task_owners
     WHERE task_id IN (
              SELECT task_id
                FROM wp_tasks
               WHERE work_plan_id IN (
                              SELECT work_plan_id
                                FROM pm_work_plans
                               WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects)));   
                                                      
***********************************************************************************************
 -- Step 9
***********************************************************************************************
DELETE FROM pm_exception_rule_results
     WHERE new_task_id IN (
              SELECT task_id
                FROM wp_tasks
               WHERE work_plan_id IN (
                              SELECT work_plan_id
                                FROM pm_work_plans
                               WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects)));
***********************************************************************************************
--  Step 10
***********************************************************************************************
UPDATE pm_work_plans
  SET root_task_id = NULL
WHERE project_id IN (SELECT project_id
                       FROM temp_invalid_prjects);

***********************************************************************************************
--  Step 11
***********************************************************************************************
DELETE FROM wp_schedule_warnings
     WHERE dependency_id IN (
              SELECT dependency_id
                FROM wp_dependencies
               WHERE successor_id IN (
                        SELECT task_id
                          FROM wp_tasks
                         WHERE work_plan_id IN (
                                  SELECT work_plan_id
                                    FROM pm_work_plans
                                   WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects))));
***********************************************************************************************
--  Step 12
***********************************************************************************************
DELETE FROM wp_dependencies
     WHERE successor_id IN (
              SELECT task_id
                FROM wp_tasks
               WHERE work_plan_id IN (
                              SELECT work_plan_id
                                FROM pm_work_plans
                               WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects)));
***********************************************************************************************
--  Step 13
***********************************************************************************************
DELETE FROM wp_tasks
     WHERE work_plan_id IN (SELECT work_plan_id
                              FROM pm_work_plans
                             WHERE project_id IN (SELECT project_id
                                                    FROM temp_invalid_prjects));

***********************************************************************************************                                                      
 --  Step 14
***********************************************************************************************
DELETE FROM pm_work_plans
     WHERE project_id IN (SELECT project_id
                            FROM temp_invalid_prjects);


***********************************************************************************************
--  Step 15
***********************************************************************************************
DELETE FROM knta_references
     WHERE source_id IN (SELECT project_id
                           FROM temp_invalid_prjects);

***********************************************************************************************
--  Step 16
***********************************************************************************************
DELETE FROM itg_group_participant_users
     WHERE trustee_id IN (
              SELECT trustee_id
                FROM itg_trustee
               WHERE project_type_id IN (
                              SELECT project_type_id
                                FROM pm_project_types
                               WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects)));
***********************************************************************************************
--  Step 17
***********************************************************************************************
DELETE FROM itg_trustee
     WHERE project_type_id IN (
                              SELECT project_type_id
                                FROM pm_project_types
                               WHERE project_id IN (
                                                    SELECT project_id
                                                      FROM temp_invalid_prjects));      
                                                      
***********************************************************************************************
--  Step 18:
***********************************************************************************************
INSERT INTO temp_invalid_project_types
           (project_type_id)
  (select project_type_id from pm_project_types
   WHERE project_id IN (SELECT project_id
                       FROM temp_invalid_prjects));

UPDATE pm_project_types
  SET project_id = NULL
WHERE project_id IN (SELECT project_id
                       FROM temp_invalid_prjects);

***********************************************************************************************
--  Step 19
***********************************************************************************************
UPDATE pm_projects
  SET project_type_id = NULL
WHERE project_id IN (SELECT project_id
                       FROM temp_invalid_prjects);

***********************************************************************************************
--  Step 20
***********************************************************************************************
DELETE FROM pm_project_types
     WHERE project_type_id IN (select project_type_id from temp_invalid_project_types);
***********************************************************************************************
--  Step 21
***********************************************************************************************
DELETE FROM itg_trustee
     WHERE project_id IN (SELECT project_id
                            FROM temp_invalid_prjects);
                            
***********************************************************************************************
--  Step 22
***********************************************************************************************
DELETE FROM PM_MSP_LINK_REQUESTS
where project_id IN (SELECT project_id
                            FROM temp_invalid_prjects);
DELETE FROM pm_projects
     WHERE project_id IN (SELECT project_id
                            FROM temp_invalid_prjects);       
                            
***********************************************************************************************
 --  Step 23
***********************************************************************************************
DELETE FROM kcrt_fg_pfm_project
where prj_project_id in
(SELECT project_id
                            FROM temp_invalid_prjects);                            
***********************************************************************************************
Finally
***********************************************************************************************
commit;

--  Step 24: Request_Deletion
CREATE OR REPLACE FUNCTION TFS_Pfm_Request_Deletion (v_req_id IN NUMBER)
RETURN VARCHAR2
IS
o_message_type     NUMBER;
o_message_name     VARCHAR2(240);
o_message          VARCHAR2(2000);
o_last_update_date DATE:=SYSDATE;
o_entity_date      DATE:=SYSDATE;
p_event            VARCHAR2(200);
p_request_id       NUMBER;
p_user             NUMBER;
A NUMBER;

PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
p_event := 'DELETE';
p_user     := 1;
A:=v_req_id;

kcrt_requests_th.Process_Row
    (p_event => p_event,
     p_REQUEST_id =>A,
     p_last_updated_by => p_user,
     o_last_update_date => o_last_update_date,
     o_entity_last_update_date => o_entity_date,
     o_message_type => o_message_type,
     o_message_name => o_message_name,
     o_message => o_message
     );

commit;
RETURN 'SUCCESS';
END TFS_Pfm_Request_Deletion;
/

[Mohit_Agrawal]

Hi Natalia,

I don't see any Delete option under the Project Overview page. In fact I did search in the 9.10 Project Mgmt guide and I cannot find anything on deleting a project.

However it's there in 9.30 version guide.

Can we delete or cancel in 9.12 version?

[Mohit_Agrawal]

is there any update on this?

Can we really not cancel a project in 9.12? The "Cancel Request" button in the Project Details tab seems to be invisible to me. Can we make the available to admin so that we can cancel the request and the project stands cancelled.

Thanks

Mohit

[Mohit_Agrawal]

No updated on this?

How do you stop showing a project in the manager's queue if the project is no longer required?

I dont see any cancel option.

Do I only have to take "Reject" option the request workflow? (project details tab) ??

[DipK]

Hi Mohit,

Check that the user has "Cancel" and "Delete" access under user access tab of the Request type associated with Project. Also the user needs to have "Edit All Projects" access grants if its not his Project to be able to Cancel/Delete it.

I hope as an admin user, both Cancel and Delete button are available to you.

Thanks & Regards,

Dipesh