EGL9.2:Chartfield Configuration Abends At FS_CFUPDATE.ACTIVATE - Table or View Does Not Exist - PS_REP_SUFF_TAO4 (Doc ID 2072477.1)

Last updated on JUNE 02, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
*** checked for relevancy 02-JUN-2017 ***

Goal

While running the standard chartfield configuration process, the process abends with the below.  How to resolve?

File: E:\pt85413c-retail\peopletools\src\psappeng\psaesql.cppSQL error. Stmt #: 3066  Error Position : 22  Return: 942 - ORA-00942: table or view does not exist Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_REP_SUFF_TAO4

The Application abended due to a problem encountered during the internal housekeeping of Temporary Tables. The possible failure points are as follows:
 C++ memory allocation for adding new temp tables to the existing internal array.
 SQL processing for one of the following:
UPDATE to PS_AELOCKMGR.
SELECT to get available instance number.
INSERT to PS_AETEMPTBLMGR to reserve the instance number.
TRUNCATE/DELETE for the temp table name chosen.
COMMIT.

Process 28325 ABENDED at Step FS_CFUPDATE.ACTIVATE.AppTable (Call Section) -- RC = ?

Solution

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