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

Last updated on MAY 13, 2013

Applies to:

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

Symptoms

  • 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;

WIDTH
----------------------
25


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms