Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

App Engine EX_BD_DEL No Success affecting all historical data?

We have run into an unexpected issue on our PeopleSoft FSCM 9.2 (Image 51) system. At around 4 yesterday, a user ran EX_BD_DEL twice, to delete 2 expense reports that had already been budget checked. The first instance completed successfully after 2 minutes and processed 1 document. The second instance failed with No Success and took much longer, showing the following error in the log:

Return: 936 - ORA-00936: missing expression

Failed SQL stmt: UPDATE PS_EX_SHEET_HDR SET BUDGET_HDR_STATUS = 'N', PROCESS_INSTANCE = 11490578 WHERE AND NOT EXISTS ( SELECT 'X' FROM PS_KK_SHDR_EXSHEET KKSH WHERE KKSH.KK_PROC_INSTANCE = 11490578 AND KKSH.KK_SOURCE_TRAN = 'EX_EXSHEET' AND PS_EX_SHEET_HDR.SHEET_ID = KKSH.SHEET_ID )

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