My Oracle Support Banner

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 FEBRUARY 06, 2019

Applies to:

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

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

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
Goal
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.