Thanks for the suggested work around. I was using this solution but came across a couple of questions.
1. Since we are doing it in SQL server, sequences don't exist do you know how should I handle the new time sheet creation.
2. I also tried it in one of the Oracle instances and I was able to create the adjusted timesheet and also able to xog the the data in the newly created timesheet, but when I try to submit the timesheet it gives me an error that "cannot obtain lock on the timesheet". I also tried xogging in the timesheet withcstatus approved or submitted but it always xogs in the timesheet with status 0. I was just wondering if you came across these issues.
Would appreciate if you have any recommendations for this.