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 AUGUST 10, 2021
Applies to:PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Process Adhoc Notification (AE LM_NOTIF_ANN) receives No Success if no rows Exists in the Adhoc Notification Tables (PS_LM_NOT_ANN_VW)
(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.
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