Deleting Oracle Commerce (ATG) BCC Project

Here are the steps for deleting a BCC project from oracle DB

1. Remove avm assets locks for the project (if any)

delete from avm_asset_lock where workspace_id in

(select id from avm_devline where name in

(select workspace from epub_project where project_id = '<PROJECT  ID>'));

2.  Deleting history of this project

delete from EPUB_PR_HISTORY where project_id in

(select project_id from epub_project where project_id = '<PROJECT  ID>');

3. Delete the project

delete from epub_project where project_id = '<PROJECT  ID>';

4. Delete history of the process

delete from EPUB_PROC_HISTORY where process_id in

(select process_id from epub_process where project = '<PROJECT  ID>');

5. Delete task information of process

delete from EPUB_PROC_TASKINFO where id in

(select process_id from epub_process where project = '<PROJECT  ID>');

6. delete EPUB_WORKFLOW_STRS of project (if any)

delete  from EPUB_WORKFLOW_STRS where id in

(select id from EPUB_IND_WORKFLOW where process_id in

(select process_id from epub_process where project = '<PROJECT  ID>'));

7. delete states of project (if any)

delete  from EPUB_IND_WORKFLOW where process_id in

(select process_id from epub_process where project = '<PROJECT  ID>');

8. Delete the process

delete from epub_process where project = '<PROJECT  ID>';

9. Additional data cleanup scripts ( since we have already deleted the project from epub_project, this shouldnt exists in that table).

delete from WB_WBENCH_TILE where project_id not in (select project_id from epub_project);

delete from WB_WORKBENCH where project_id not in (select project_id from epub_project);

delete from EPUB_INT_PRJ_HIST where project_id not in (select project_id from epub_project);

delete from EPUB_PR_TG_AP_TS where project_id not in (select project_id from epub_project);

delete from EPUB_PR_TG_STATUS where project_id not in (select project_id from epub_project);