R12 AP : Not Able To Update The City In The Address Book In Supplier Form due to error : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
(Doc ID 2951142.1)
Last updated on MAY 25, 2023
Applies to:
Oracle Payables - Version 12.1.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to update the City in the Address Book in Supplier form for the Supplier
the following error occurs.
ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.AP_SUPPLIER_SITES_ALL_AUP", line 102 ORA-06512: at "APPS.AP_SUPPLIER_SITES_ALL_AU", line 1 ORA-04088: error during execution of trigger 'APPS.AP_SUPPLIER_SITES_ALL_AU' occurred in &CALLING_SEQUENCE with parameters (Party Site ID = ) while performing the following operation: &DEBUG_INFO (PARAMETERS=Location ID = 258832)
STEPS
-----------------------
1. Payables -> Supplier -> Suppliers-> Address book.
2. Update city in Address book -> error occurs.
Changes
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 |
Changes |
Cause |
Solution |
References |