My Oracle Support Banner

R12: Error Updating City On Supplier Site Record - AP_SUPPLIER_SITES.CITY Width Not Correct (Doc ID 1381437.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Payables - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.


  • User received error with attempting to update CITY field on suppler site record.
  • AUDIT enabled for that column in AP_SUPPLIER_SITES_ALL table.
  • This table was introduced with 12.0. 
  • The column in AP_SUPPLIER_SITES_ALL_A is VARCHAR(60)
  • The procedure AP_SUPPLIER_SITES_ALL_AUP is consistently created with the column length VARCHAR2(25)
  • Investigation found that the value in FND_COLUMNS.WIDTH is VARCHAR2(25)
  • Width of 'CITY' column in AP_SUPPLIER_SITES_ALL remains unchanged after patch 11884093  was applied

Check the width using the following script:

Select width
from fnd_columns
where application_id = 200
and column_name ='CITY'
and table_id=113179;



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.