My Oracle Support Banner

R12: Inconsistent Data In PA_PROJ_ELEMENTS And PA_TASKS Leads To Error: Project: '&PROJECT';Task:'&TASK Parent tasks cannot be made chargeable (Doc ID 2472091.1)

Last updated on NOVEMBER 28, 2023

Applies to:

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


Chargeable Flag for parent task is showing 'Y' in PA_PROJ_ELEMENTS table whereas 'N' in PA_TASKS table. Due to this inconsistency workplan is giving the following error while publishing:

1. Search for problematic project
2. Navigate to Workplan > Tasks
3. Click on "Create tasks" button > enter task number 1 > Apply
    Chargeable flag enabled
4. Click on "Create tasks" button > enter task number 1.1 > Apply
    Chargeable flag enabled
5. Move as subtask 1.1 under 1
    Result: Chargeable flag not removed automatically for parent task 1 as per:
    select * from PA_PROJ_ELEMENTS where project_id = &project_id;




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.