My Oracle Support Banner

ORA-20002: 3240: Ошибка "-6502 - ORA-06502: PL/SQL: : Numeric or Value Error: Character String Buffer too Small" в API "pon_auction_pkg.GEN_AWARD_LINES_BODY" для "PLSQLCLOB" ORA-06512 Error Opening Auction Award Decision Notifications In Russian Version (Doc ID 2527841.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

When attempting to open an Award Notification, only in Russian language, the following error occurs:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Publish Auction:
2. Create Bid (surrogate):
3. Close Auction:
4. Save Award:
5. Complete Award:
6. Open Notifocation:
7. Get an error (on first attempt):

ORA-20002: 3240: Ошибка "-6502 - ORA-06502: PL/SQL: : буфер символьных строк слишком маленький ошибка числа или значения " в API "pon_auction_pkg.GEN_AWARD_LINES_BODY" для "PLSQLCLOB" ORA-06512: на "APPS.WF_NOTIFICATION", line 5856 ORA-06512: на line 6

On english:
ORA-20002: 3240: Ошибка "-6502 - ORA-06502: PL/SQL: : Numeric or Value Error: Character String Buffer too Small" в API "pon_auction_pkg.GEN_AWARD_LINES_BODY" для "PLSQLCLOB" ORA-06512: на "APPS.WF_NOTIFICATION", line 5856 ORA-06512: на line 6


8. Get on error (on second attempt):


ORA-01403: данные не найдены ORA-06512: на "APPS.WF_NOTIFICATION", line 5856 ORA-06512: на line 6

On english:
ORA-01403: No Data Found ORA-06512: на "APPS.WF_NOTIFICATION", line 5856 ORA-06512: на line 6

 

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.