Hi K P
First of all, I would check to make sure the 'missing' actuals from Wed Thu and Fri are not in Invalid Transactions(imp_transactionimport) or waiting for Post to WIP(ppa_transcontrol).
Assuming that they are not in the above tables and the PRTIMEENTRY.PRRMEXPORTED = 1 for all the 5 days and prtimesheet.prid = ppa_wip.prexternalbatchid (the timesheet id) is only showing for Mon and Tues, we can confirm that the actuals from wed thu and fri were deleted from invalid transactions.
If that's the case, getting these actuals back to WIP is going to be tricky
If you simply adjust the timesheet and submit again without any changes, no transactions will be generated in invalid trx.
If you modify/insert any fields like user values and submit with the same actual hours, transactions will be generated but they will have the same positive and negative numbers which means your WIP table will end up having the sum of only Mon and Tues actuals.
Since the transactions were posted to invalid trx, the actual cost in the assignments will be updated. So as far as I can think, Transaction Entry is the only option here but this is going to mess up the mapping of data between timesheets table and ppa_wip table. For example, the externalbatchid will be different for these transaction entries and will not match with timesheet id. But I think the actual hours and cost (which usually matters the most) should be in sync.
I will be more than happy if anyone else have a better option than this.
Thanks,
Jerin