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 APRIL 06, 2021
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