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 MAY 24, 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
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 be 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.
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 |