My Oracle Support Banner

11i: Error While Sending Email Notifications And Viewing Notifications If User Date Format Is MM/dd/YYYY (Doc ID 1315813.1)

Last updated on FEBRUARY 23, 2019

Applies to:

Oracle Quoting - Version to [Release 11.5.10]
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/<XXX>DET [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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.