Submitting Request For Quotation Fails With ORA-6502: character string buffer too small for Japanese and Other Languages

(Doc ID 2109769.1)

Last updated on NOVEMBER 15, 2017

Applies to:

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

Symptoms

Problem Statement
In Sourcing, Submitting Request For Quotation (RFQ) for approval in Japanese language (and other languages) always fails with error.

Error
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: "APPS.PON_AUCTION_APPROVAL_PKG", line 496

Steps to Reproduce

  1. Create and submit RFQ in Japanese language.

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