My Oracle Support Banner

Data Not Deleted From PA_PROJECT_ACCUM_HEADERS/PA_PROJECT_ACCUM_ACTUALS When Deleting Project From Projects Form (PAXPREPR) (Doc ID 2888027.1)

Last updated on AUGUST 05, 2022

Applies to:

Oracle Project Foundation - Version 12.2.2 and later
Information in this document applies to any platform.


When a project is created and then deleted immediately (no transactions or any processing done on project) from the Projects form (PAXPREPR), the data in PA_PROJECT_ACCUM_HEADERS and PA_PROJECT_ACCUM_ACTUALS does not get purged

Projects Form Responsibility > Projects

These SQLs still show data after deleting project:

There have been no summarization processes run for the project (Update Project Summary Amounts and Refresh Project Summary Amounts).

The expectation is that after the project is deleted, the data should deleted from PA_PROJECT_ACCUM_HEADERS and PA_PROJECT_ACCUM_ACTUALS .


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.