Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

Expense 9.0 to 9.1 upgrade issues

edited Dec 4, 2012 11:23AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 2 commentsAnswered
Hi

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'));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center