We have a lot of staffing profiles that were created from templates. As such, they all have the same 14 positions but many of the positions are no longer required and never had any forecast. I have a requirement to "administratively" remove all positions without a forecast, as they still show up in the Analyze Resource Pools portlet & data sets. Deleting these rows from RSC_POSITIONS is easy, but then you also need to update the remaining values for STAFFING_PROFILE_SEQ for each staffing profile so there are no gaps in the numbers and this has me stumped.
Does anyone have a solution for this, or a better way to accomplish it?