PONAUCT Notifications Error When Additional Contact Email Is Used And RFQ Is Published And Begins Immediately

(Doc ID 1271992.1)

Last updated on NOVEMBER 25, 2015

Applies to:

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


In Oracle Sourcing, Release 11.5.10, during RFQ creation and publication, when the RFQ is published, errors occur on the notification generation if the Additional Contact Email field is populated on the Suppliers region of the RFQ and the RFQ is scheduled to open immediately (as soon as the RFQ is published).

The notification is successfully generated when the Additional Contact Email field is not populated for the suppliers invited to participate in the RFQ process.

In both cases, the RFQ is successfully published when the buyer/user chooses to publish the document.


The following errors can be seen from the Workflow Status Monitor for the failed notification:

Workflow Errors: PONAUCT, 1803-1210

Failed Activity: Notify Bidder list that the auction has started
Activity Type = Function
Error Name = 100
Error Message = ORA-01403: no data found ORA-01403: no data found
Error Stack = Wf_Engine_Util.Function_Call(PON_AUCTION_PKG.NOTIFY_BIDDER_LIST_START,PONAUCT, 1803-1210,315615,RUN)

Failed Activity: Notify perparer auction has started
Activity Type = Notice
Error Name = WF_ERROR
Error Message =
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: ORA-29549: class APPS.oracle/apps/fnd/security/WebSessionManagerProc has changed, Java session state cleared' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage3(3546521, WFMAIL, ORA-29549: class APPS.oracle/apps/fnd/security/WebSessionManagerProc has changed, Java session state cleared , Step -> Performing token substitution) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 3546521) WF_XML.Generate(oracle.apps.wf.notification.send, 3546521) WF_XML.Generate(oracle.apps.wf.notification.send, 3546521) Wf_Event.setMessage(oracle.apps.wf.notification_send, 3546521, WF_XML.Generate) Wf_Event.dispatch_internal()
Error Stack = (null)

Steps To Reproduce
The issue can be reproduced at will with the following steps:

1. In Oracle Purchasing, create a purchase requisition (ensure that a Buyer is assigned).
2. In Oracle Purchasing, AutoCreate the requisition into a Sourcing RFQ
3. In Oracle Sourcing, complete the RFQ definition in the various regions (Header, Line,
    Controls, Contract, Supplier).
    Ensure that the negotiation is scheduled to begin immediately (as soon as the RFQ is
    published),  and also ensure that one or more suppliers is invited.
    In the Suppliers region, populate the Additional Contact Email field for the supplier.
4. Publish the RFQ. The notification is not sent to any of the suppliers that have had the Additional
    Contact Field value populated on the RFQ.

Business Impact
Due to this issue, buyers cannot communicate the RFQ documents to an additional supplier contact person via notification; rather, the RFQ is only sent to the email address listed on the supplier contact's definition.


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