Clarity

  • 1.  Zero out ETC at the project level via XOG

    Posted Aug 10, 2018 08:42 AM

    CA PPM 14.3

     

    I have a requirement to ZERO out the ETC for all the cancelled projects via automated process.

     

    I see the below functionality available in CA PPM at the project level.  I noticed that, when I apply 0 at the 'New ETC' the ETC at the task level is set to zero

     

    Is there anyway, we can update this attribute via XOG/Gel script? 

     

    Any help is greatly appreciated.

     



  • 2.  Re: Zero out ETC at the project level via XOG

    Posted Aug 16, 2018 02:50 AM

    Hi,

     

    There has been similar related discussion on the following thread, with examples, you may refer to it here -> How to make the Allocation and ETC zeroes? 

    Also post making changes you may have to run the investment allocation job.

     

    Regards,

    Samik



  • 3.  Re: Zero out ETC at the project level via XOG

    Posted Aug 16, 2018 05:57 AM

    Adding onto the previous post:

     

    Following is a project having ETC at assignment level:

     

     

     

     

    Using the prj_projects_alloc_act_etc_read.xml (available under the XML folder of XOG client), the ETC of the assignment per project could be read out, following is a section of the read out, showing the ETC:

     

    The XML could be modified with respect to the ETC information:

     

    Post XOG, the ETC is updated in the system:

     

     

    You may look into the option of carrying out the same through a process / GEL , apply your applicable business rules etc for consideration of multiple projects.

     

    Note: when doing this XOG on an Inactive project, while updating the ETC, it will activate the project. Hence, you will need to include a step which will set the project inactive again, on the process.

     

    Regards,

    Samik



  • 4.  Re: Zero out ETC at the project level via XOG

    Posted Aug 16, 2018 06:58 AM

    Thanks Samik

     

    The example you have provided is only for ONE assignment in a project, whereas I have hundreds of assignments in a single project.  

     

    I have handled in the GEL script with FOR LOOP statement with the condition,  <core:if test="${row.ETC > 0}">

     

    I'm zero out both the below attributes

     

    remainingWork="0"

    sum="0.0000"/>

     

    Thanks

    -Venkitta



  • 5.  Re: Zero out ETC at the project level via XOG

    Posted Aug 16, 2018 09:01 AM

    Hi Venkitta,

     

    You are correct. You will need a script for multiple projects / assignments, using the logic as discussed above or if you have already one established.

    The point is that it is feasible using the XOG, only thing to mind is the project re-activation, in case it is inactive.

     

    Regards,

    Samik