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 05, 2023

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.


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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.