How can I transform the data when it has been collected and then added to the incentive compensation transaction table from staging?

If you have Oracle Data Integration, then you can create a custom mapping to modify the default mapping provided with the application. If you own a different extraction, transformation, and load tool, then you can create your own, new mapping.