Getting Error While Sending Email Notifications And Viewing Notifications If User Date Format Is Cha
Last updated on APRIL 12, 2017
Applies to:Oracle Quoting - Version 18.104.22.168 and later
Information in this document applies to any platform.
When attempting to sending Email Notifications and Viewing Notifications if user date format is changed to MM/dd/YYYY in Preferences,
the following error occurs.
---> Quoting UI Error
"ORA-6510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.ASO_APR_INT", line 208 ORA-0413: not a valid a month ORA-06512: at "APPS.WF_NOTIFICATION", line 5746 ORA-06512 at line 5"
---> Notification UI Error
"Error in Workflow ASOAPPRV/10046DET [WF_ERROR]
Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML.
Caused by: 2020: Error when getting notification content.
Caused by: User-Defined Exception ASOAPP"
The issue can be reproduced at will with the following steps:
1. Create Quote
2. Send approval Notifications with user date format is changed to MM/dd/YYYY in Preferences
3. Get error
4. Navigate to the Notifications page to view the notification
5. Open notification and see errors
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms