My Oracle Support Banner

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 FEBRUARY 03, 2019

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

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.