AnsweredAssumed Answered

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

Question asked by Nag_cl on Nov 26, 2014
Latest reply on Nov 26, 2014 by navzjoshi00

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?