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 ***
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.
Process 28325 ABENDED at Step FS_CFUPDATE.ACTIVATE.AppTable (Call Section) -- RC = ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms