Clarity

  • Private Community

  • 1.  Direct update of role in PPA_WIP will that create any discrepency?

    Posted Nov 26, 2014 05:20 AM

    Hi experts,

    I got into this interesting situation, where the organization wants to simplify the roles in rate matrix.

    Currently we are over 5000+ roles in rate matrix, the idea  was to simplify the number of roles in the organization to close 100+ roles.

    Eventually when this happens, we are ought to update the existing records in wip table.

     

    My uncertainty drills down to this point:

    Can we update role_code with new role id to those existing records in PPA_WIP through a SQL update statement?, will there be any discrepency in any other tables?

    or do we have any other tables apart from ppa_Wip which would hold role_code for actual's records?

     

     

    Regards,

    Naga



  • 2.  Re: Direct update of role in PPA_WIP will that create any discrepency?

    Posted Nov 26, 2014 05:37 AM

    Can't you look at XOG at an option ?

     

    A direct db update is a BIG NO

     

    NJ



  • 3.  Re: Direct update of role in PPA_WIP will that create any discrepency?

    Posted Nov 26, 2014 05:39 AM

    Another option can be an object based portlet

     

    NJ



  • 4.  Re: Direct update of role in PPA_WIP will that create any discrepency?
    Best Answer

    Posted Nov 26, 2014 07:22 AM

    Another supported way is WIP adjustments where you change the role. With your number of records that is not feasible.

    Is it an option not to change for the existing records and to use query base portlets where you replace the roles with the new ones.

    Consider also using 20+ roles instead of 100+. Do you really have 100+ different types of project work?

    Open a case with support to get an official position on the direct database update in your particular case.



  • 5.  Re: Direct update of role in PPA_WIP will that create any discrepency?

    Posted Nov 26, 2014 11:25 AM

    Adjustsment did work for few of my sample records!

    How to Make WIP Adjustments for Cost Type | CA Clarity PPM Cookbook

    Thanks for ur thougts martti.

     

    As we have diff departments, yes we  have 100+ different types of project work...

    Will check CA for direct database update....

     

    Regards,

    Naga



  • 6.  Re: Direct update of role in PPA_WIP will that create any discrepency?

    Posted Nov 26, 2014 11:28 AM

    Good to know it worked, and thanks to Martti for his valuable insight

     

    NJ



  • 7.  Re: Direct update of role in PPA_WIP will that create any discrepency?

    Posted Nov 26, 2014 09:30 AM

    Hey NJ,

     

    Incase if i wanted to go with object based portlet what will be the name of data provider?

    Though I could see the objectType="transaction" in transaction write XML, I did not find object with name transaction.

     

    Regards,

    Naga



  • 8.  Re: Direct update of role in PPA_WIP will that create any discrepency?

    Posted Nov 26, 2014 10:36 AM

    Correct, there is no such object

     

    And, I agree with Martti -

     

    "Consider also using 20+ roles instead of 100+. Do you really have 100+ different types of project work?

    Open a case with support to get an official position on the direct database update in your particular case."

     

    NJ