P6 Web Services CreateBaselineProjects Operation Creates Baseline Without Activities (Doc ID 2988319.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Symptoms

When creating a baseline using the P6 Web Services CreateBaselineProjects operation, the baseline is created without activities.
 
 
STEPS TO REPRODUCE:
1. Run a request to create a baseline project. e.g. p6ws/services/BaselineProjectService
 
      <v2:CreateBaselineProjects>
         <!--1 or more repetitions:-->
         <v2:BaselineProject>
            <v2:BaselineTypeName>Initial Planning Baseline</v2:BaselineTypeName>
            <v2:BaselineTypeObjectId>111</v2:BaselineTypeObjectId>
            <v2:Id>test-B1</v2:Id>
            <v2:Name>Test Baseline B1</v2:Name>
            <v2:OriginalProjectObjectId>4251</v2:OriginalProjectObjectId>
            <v2:ParentEPSObjectId>18132</v2:ParentEPSObjectId>
         </v2:BaselineProject>
      </v2:CreateBaselineProjects>
 
 
2. Run the following query to check for baseline activities.
    select t.proj_id, p.proj_short_name, count(*) from admuser.task t, admuser.project p where t.proj_id=p.proj_id and p.proj_short_name='<BASELINE NAME>'  and p.orig_proj_id in (select proj_id from project where proj_short_name='<PROJECT NAME>') group by t.proj_id,  p.proj_short_name;
    e.g. select t.proj_id, p.proj_short_name, count(*) from admuser.task t, admuser.project p where t.proj_id=p.proj_id and p.proj_short_name='test-B1' and p.orig_proj_id in (select proj_id from project where proj_short_name='test') group by t.proj_id,  p.proj_short_name;
    
3. No activities are returned but the baseline project exists. Check the project exists using the following query.
    select * from project where orig_proj_id=(select proj_id from project where proj_short_name='<PROJECT NAME>');
    e.g. select * from project where orig_proj_id=(select proj_id from project where proj_short_name='test');
 
4. Creating a baseline in P6 Web works correctly.

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.