RFQ Was Cancelled, But Emails Are Not Generating For All Invited Suppliers (Doc ID 2835978.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

After upgrade to 12.2.10 from 12.2.8, RFQ was cancelled, emails are not generating for all invited suppliers.

Please note that from 12.2.8 functionality, it is not need quote for an RFQ to receive notification.
Sometimes RFQ can get cancelled before quote was issued.

WORKAROUND:
-----------
Add the additional contact email addresses to each supplier.



-- Log File --

FileComment
----------------------
.
.
fnd.common.Message.auto_log PON
SourcingUtil.getMessage msgText =>Cancel RFQ: 433783
pon.negotiation.tools.webui.NotifControllerUtil.isNotificationSubscribed NotifControllerCommonUtil.isNotificationSubscribed  is called with wf_message_name:NEGOTIATION_CANCELED, auction_header_id:433783
pon.negotiation.tools.NotifControllerCommonUtil.isNotificationSubscribed NotifControllerCommonUtil.isNotificationSubscribed  is called with wf_message_name:NEGOTIATION_CANCELED, auction_header_id:433783
pon.plsql.PON_WF_UTL_PVT.get_notif_preference_1 BEGIN: Check WF preference forNEGOTIATION_CANCELED for auction 433783
pon.plsql.PON_WF_UTL_PVT.get_notif_preference_2 BEGIN: Check WF preference forNEGOTIATION_CANCELED for doctype REQUEST_FOR_QUOTE
pon.plsql.PON_WF_UTL_PVT.get_notif_preference_2 Check WF preference forNEGOTIATION_CANCELED for doctype  REQUEST_FOR_QUOTE with return value Y
pon.negotiation.tools.NotifControllerCommonUtil.isNotificationSubscribed NotifControllerCommonUtil.isNotificationSubscribed  is called is over, returning value:true
.
.
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(null,1163163734,false,false,true): : BEGIN
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection: END: returning weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@2284a
fnd.common.DBResourceStore Added to Cache: mResText=&DOC_NAME &AUCTION_ID has been cancelled. We will notify all suppliers of your decisions.; mResID=0; mResType=null; mLogSeverity=0; mAlertCategory=null; mAlertSeverity=null
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.releaseLocalJDBCConnection(weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@2284a): : BEGIN

.
.
pon.plsql.PON_CONTERMS_UTL_PVT.cancelDeliverables End
pon.schema.server.AuctionHeadersALLEOImpl.beforeCommit In beforeCommit..
pon.negotiation.tools.webui.NotifControllerUtil.isNotificationSubscribed NotifControllerCommonUtil.isNotificationSubscribed  is called with wf_message_name:NEGOTIATION_CANCELED, auction_header_id:433783
pon.negotiation.tools.NotifControllerCommonUtil.isNotificationSubscribed NotifControllerCommonUtil.isNotificationSubscribed  is called with wf_message_name:NEGOTIATION_CANCELED, auction_header_id:433783
pon.plsql.PON_WF_UTL_PVT.get_notif_preference_1 BEGIN: Check WF preference forNEGOTIATION_CANCELED for auction 433783
pon.plsql.PON_WF_UTL_PVT.get_notif_preference_2 BEGIN: Check WF preference forNEGOTIATION_CANCELED for doctype REQUEST_FOR_QUOTE
pon.plsql.PON_WF_UTL_PVT.get_notif_preference_2 Check WF preference forNEGOTIATION_CANCELED for doctype  REQUEST_FOR_QUOTE with return value Y
pon.negotiation.tools.NotifControllerCommonUtil.isNotificationSubscribed NotifControllerCommonUtil.isNotificationSubscribed  is called is over, returning value:true
SourcingUtil.getMessage Start: getMessage method


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create RFQ. After its published user canceled it.
2. RFQ is in CANCELLED status
3. Cancel Notices (ie both Email and Worklist) are not getting generated for ALL invited suppliers on RFQ.

Cause

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