My Oracle Support Banner

EAP9.2: Voucher Post (AP_PSTVCHR) Fails Due to Table or View Does Not Exist Error After Updating to Image 28 (Doc ID 2457359.1)

Last updated on OCTOBER 11, 2018

Applies to:

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

Symptoms

Voucher Post process fails.

Steps:
------------
1) Go to Accounts Payable -> Batch Process -> Voucher -> Voucher Post.
2) Give run control parameters.
3) Run the process.

Process fails with following error.
ORA-00942: table or view does not exist
Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_EXD_TAX2_TMP4

Temporary Table processing failure during allocation phase. (108,530).

Note: The same issue was enountered with other tables as well: PS_GST_INH_TMP4, PS_GST_TAX1_TMP4, PS_GST_TDS_TMP4 and PS_REG_VCHR1_TMP4

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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