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 OCTOBER 10, 2022

Applies to:

Symptoms

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:

STEPS:
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;

Changes

Cause

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