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?
Can't you look at XOG at an option ?
A direct db update is a BIG NO
Another option can be an object based portlet
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.
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....
Good to know it worked, and thanks to Martti for his valuable insight
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.
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."