

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Can we delete or cancel a project in 9.12
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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;
/
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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) ??


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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