Getting Error While Sending Email Notifications And Viewing Notifications If User Date Format Is Cha (Doc ID 1315813.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Quoting - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------
---> 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_MESSAGE=3835:
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"


STEPS
-----------------------
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

Changes

 

Cause

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