EEX 9.2: App Eng EX_TRAN_PRCS Fails On Step EX_STAGE_PMT.PAYMENTS.CheckER. SQL Server Invalid Column ROWNUM (Doc ID 1959047.1)

Last updated on JUNE 20, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

9.2

Issue:
Running stage payment and encounter error.
App Eng EX_TRAN_PRCS fails on step EX_STAGE_PMT.PAYMENTS.CheckER.
SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'ROWNUM'.

Steps:
1) create and submit report
2) approve
3) stage report for payment

Expected result: report will be staged for payment

Actual result: cannot successful stage report for payment encounter error App Eng EX_TRAN_PRCS fails on step EX_STAGE_PMT.PAYMENTS.CheckER.
SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'ROWNUM'.

Please see replication steps document for more details. 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms