My Oracle Support Banner

ELM 9.2: When Running the Search Index LS_LM_PRG_FL, the Process PTSF_GENFEED is Going to 'No Success' : "Error Position: 22 Return: 942 - ORA-00942: table or view does not exist Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_LM_CI_CTG_TAO1"" (Doc ID 2921784.1)

Last updated on APRIL 17, 2023

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The Seach Definition LS_LM_PRG_FL has been successfully deployed, however, when running the Search Index for the Search Definition LS_LM_PRG_FL, the Process is going to "No Success" with the following Error Message:

Steps to replicate the issue:

1. Enterprise Learning > Catalog > Rebuild Indexes > Build Search Index for the Search Definition LS_LM_PRG_FL

Changes

 

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