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 MARCH 01, 2017

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/29016-16001 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 = 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

Changes

 

Cause

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