Error "Ora-06502: Pl/Sql: Numeric Or Value Error:" on PO Workflows That Have Higher Number of Lines

(Doc ID 880422.1)

Last updated on SEPTEMBER 04, 2013

Applies to:

Oracle Purchasing - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 04-Sep-2013***


Symptoms

With profile PO: Notification Lines Display Limit = NNN, encountering error "ORA-06502: PL/SQL:
numeric or value error: character string buffer too small ORA-06512: at "APPS.WF_NOTIFICATION",
line 5474 ORA-06512: at line 5" on POs with less than NNN number of lines.

-- Steps To Reproduce:
1) Set profile PO: Notification Lines Display Limit = NNN
2) Create a Purchase Order (PO) with less than NNN number of lines and submit for approval
3) Error occurs in the notification

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