ORA-06502 Error Page While Sharing Award Decision With Supplier (Doc ID 2145028.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Awards

When trying to share award decision with Supplier following error page appears. One of Supplier has Russian language preference (ICX: Language). If change language preference to English there is no issue.

ERROR
-----------------------
Exception Details.

 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: : character string buffer too small ошибка числа или значения
ORA-06512: на "APPS.PON_AUCTION_PKG", line 2942
ORA-06512: на "APPS.PON_AWARD_PKG", line 865
ORA-06512: на "APPS.PON_AWARD_PKG", line 754
ORA-06512: на line 1

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.pon.award.completion.server.CompleteAwardAMImpl.completeAward(CompleteAwardAMImpl.java:357)
at oracle.apps.pon.award.completion.webui.CompleteAward2CO.processFormRequest(CompleteAward2CO.java:207)
at oracle.apps.fnd.framewo


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create negotiation from Sourcing Buyer
2. Award Supplier
3. Complete Award with checked "Share Award decisions with Suppliers immediately" checkbox and unchecked "Create PO for this negotiation" check box.
4. Get an error page.

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