My Oracle Support Banner

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.

Symptoms

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

ERROR
-----------------------

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

Cause

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
Symptoms
Cause
Solution
References


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