My Oracle Support Banner

ELM 9.2: AE LM_NOTIF_ANN Receives No Success if No Rows Exists in the Adhoc Notification Table (Doc ID 2430945.1)

Last updated on FEBRUARY 03, 2019

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

Process Adhoc Notification (AE LM_NOTIF_ANN) receives No Success if no rows Exists in the Adhoc Notification Tables (PS_LM_NOT_ANN_VW)


Error Message: 
(Only can bee seen in generated trace file) 

ORA-03291: Invalid truncate option - missing STORAGE keyword
Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_LM_ANN_TMP_TBL;
 

Steps to Replicate Issue: 

1. Log in as Administrator
2. Execute Process Ad Hoc Notifications (AE LM_NOTIF_ANN)
3. Runs to success
4. Execute Process Ad Hoc Notifications (AE LM_NOTIF_ANN) 2nd time with no notifications in list in view PS_LM_NOT_ANN_VW, Process goes to no success.



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.