EAP: 'ORA-00942' error occurs when trying to View Vouchers on Batch Voucher Approval page and VCHR_APRV_AF process abends with the same error (Doc ID 2030096.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Voucher Approval Batch process and View Vouchers link on Batch Voucher Approval page result in error

ERROR:
Fatal SQL - ORA-00942
Fatal SQL error occurred. (2,125) EOAW_CORE.Utils.OnExecute Name:getNextId PCPC:8367 Statement:262

Called from:EOAW_CORE.DEFN.AppDef.OnExecute Name:Instantiate Statement:77

Called from:EOAW_CORE.LaunchManager.OnExecute Name:PrepareToSubmit Statement:159

Called from:EOAW_CORE.LaunchManager.OnExecute Name:DoSubmit Statement:31

Called from:VCHR_APRV_AF.MAIN.GBL.default.1900-01-01.Step03.OnExecute Statement:19

Process ABENDED at Step VCHR_APRV_AF.MAIN.Step03 (PeopleCode) -- RC = 24 (108,524)


STEPS:
1) Navigate to Accounts Payable > Vouchers > Approve > Batch Voucher Approval
2) Click on View Vouchers hyperlink on the Run control page
Above SQL error occurs
3) Run the VCHR_APRV_AF process and the process fails with the above error


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