EGL: Chart Field Configuration Process ABENDED at Step FS_CFUPDATE.ViewSrch.Step01 (SQL) -- RC = 942 (108,524) (Doc ID 1296137.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
****Checked for Currency on Aug-29-2012****
****Checked for Currency on Dec-18-2014****

Symptoms

When attempting to extend the length of ALTACCT from 10 to 15 and change label for DEPTID for ESP language code,
The following error occurs.


ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1617 Error Position: 397 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: INSERT INTO PS_CF_PRJITM_TAO4 (PROCESS_INSTANCE, PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, TAKEACTION) SELECT DISTINCT 11168, 'FS_CF_CREATE_VIEW' , 0, 1, RTRIM(SUBSTR(A.name,4,15)), 0, ' ', 0, ' ', 0, ' ', 1 FROM dba_dependencies A, PS_CFVWSRCH_TMP4 B WHERE A.type = 'VIEW' AND A.referenced_name = B.RECNAME_18 AND B.PROCESS_INSTANCE = :1

Traitement 11168 ABANDONNE  'l' tape FS_CFUPDATE.ViewSrch.Step01 (SQL) -- Code Retour = 942 (108,524)


ENVIRONMENT
-----------------------
FMS 9.1 and PT 8.51 on oracle 11g


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Chart field configuration page, request following change.
    - extend the length of ALTACCT from 10 to 15
    - change label for DEPTID for ESP language code.
2. Run chartfield configuration process.
3. Process failed with above abend error.

Cause

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