Workflow Error Extending Close Date Of An RFQ- ORA-06502: PL/SQL: Numeric Or Value Error, and Suppliers Not Notified
Last updated on DECEMBER 11, 2017
Applies to:Oracle Sourcing - Version 12.1.3 and later
Information in this document applies to any platform.
On Oracle Sourcing, 12.1.3 version, Auction/RFx creation
A buyer is trying to extend close date of an RFQ. Once done through the normal Oracle process (Actions> Extend RFQ), the buyer gets a confirmation message on the form that the RFQ close date has been extended and that the suppliers have been notified about the same on email. However, suppliers are not getting an email.
Workflow administrator gets the following error notification"
Subject: Action Required: Error in Workflow PONAUCT/29016-16001 ORA-06502: PL/SQL: numeric or value error: character string buffer too small
An Error occurred in the following Workflow.
Item Type = PONAUCT
Item Key = 12345-12345
Error Name = -6502
Error Message = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error Stack =
Wf_Engine_Util.Function_Call(PON_AUCTION_PKG.NOTIFY_BIDDERS_OF_CLOSECHANGED, PONAUCT, 12345-12345, 340558, RUN)
Activity Id = 340558
Activity Label = PUBLISH_AUC_CLOSECHANGED_FREM:NOTIFY_BIDDER_LIST_CLOSECHANGE
Result Code = #EXCEPTION
Notification Id =
Assigned User =
STEPS TO REPRODUCE
1. Create an RFQ and publish
2. Extend the close date of the RFQ
- get confirmation message that the RFQ close date has been extended and that the suppliers have been notified about the same on email.
- Suppliers are not getting an email notification
- Workflow is in error
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms