R12: AP: Errors ORA-04088, ORA-06512, During Execution of Audit Trail Trigger 'APPS.AP_SUPPLIER_SITES_ALL_AU' While Updating a Supplier Site Address
(Doc ID 2812877.1)
Last updated on AUGUST 18, 2023
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
ORA-04088: error during execution of trigger 'APPS.AP_SUPPLIER_SITES_ALL_AU' occurred in &CALLING_SE
Created a supplier and supplier site. When we try to update the suppler site address information, the following error raises:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_MSG_PUB", line 279
ORA-06512: at "APPS.AP_VENDOR_PUB_PKG", line 27351
ORA-20001: APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.AP_SUPPLIER_SITES_ALL_AUP", line 242
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
with parameters (VENDOR_SITE_ID = 289829)
while performing the following operation:
ORA-06512: at line 42
The issue can be reproduced at will with the following steps:
1. Created a supplier
2. Created a supplier site
3. Try to update the suppler site address information.
4. Get the error.
Audit Trail enabled for table AP_SUPPLIER_SITES_ALL, columns CITY, ZIP, COUNTRY.
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