Expense 9.0 to 9.1 upgrade issues
Can anyone help with the below issues
Issue 1:
As part of upgrade to 9.1 we are setting all the expense reports to PND status which are submitted or partially approved via SQL (approx 700 count). Below are the sql used
We set the status to terminated in below SQLand found it is not working correctly for few instances where user just submitted and is not yet apporved by level 1. What is the best status to update them all of them for workflow tables (first 3 sql) or is there anyother way of setting all these to PENDING.
UPDATE PS_EX_SHEET_AW SET PTAFTHREAD_STATUS = 'T' WHERE SHEET_ID IN (SELECT SHEET_ID FROM PS_EX_SHEET_HDR WHERE SHEET_STATUS IN( 'SUB' , 'PAR'));