My Oracle Support Banner

SCC_SL_SMSET - Error Position: 22 Return: 942 - ORA-00942: table or view does not exist Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_SCC_SLSM1_TMP4 (Doc ID 2477570.1)

Last updated on JANUARY 06, 2020

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the new Application Engine process SCC_SL_SMSET, the following error occurs.

ERROR
-----------------------
File: /vob/peopletools/src/psappeng/psaesql.cppSQL error. Stmt #: 3091 Error Position: 22 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_SCC_SLSM1_TMP4

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Run the SCC_SL_SMSET process (Student Admissions > Application Transaction Mgmt > Transaction Management Process > SCC_SL_SMSET)

 

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