Workflow Error Extending Close Date Of An RFQ- ORA-06502: PL/SQL: Numeric Or Value Error, and Suppliers Not Notified
(Doc ID 2236924.1)
Last updated on SEPTEMBER 19, 2019
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/<Item Key> 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 = <Item Key>
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, <Item Key>, <id>, RUN)
Activity Id = <Activity Id>
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
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