My Oracle Support Banner

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 JANUARY 07, 2020

Applies to:

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


Voucher Approval Batch process and View Vouchers link on Batch Voucher Approval page result in 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)

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.