My Oracle Support Banner

R12: AP: Supplier Contact Open Interface Fails Becuase there is a Difference In Length for First_Name and Last_Name Between HZ_PARTIES and AP_SUP_SITE_CONTACT_INT (Doc ID 2809040.1)

Last updated on SEPTEMBER 29, 2021

Applies to:

Oracle Payables - Version 12.2.7 and later
Information in this document applies to any platform.


The length of HZ_PARTIES.Person_First_Name and HZ_PARTIES.Person_Last_Name is 150.

The Length of AP_SUP_SITE_CONTACT_INT.First_Name and AP_SUP_SITE_CONTACT_INT.Last_Name is 15 and 60 respectively.

Due to this difference Supplier Contacts Open Interface Import can not be used to import a contact with more than 15 characters in the first name of 60 characters in the last name.  There is no such limitation when creating a contact in the Suppliers form.

Unexpected Error:Insert into ap_sup_site_contact_int failed for the record - ORA-12899: value too large for column "AP"."AP_SUP_SITE_CONTACT_INT"."FIRST_NAME" (actual: 19, maximum: 15)we are not able to Import Contacts having first name of more than 15 characters.

Attempt to create a row in AP_SUP_SITE_CONTACT_INT than 15 characters in First_Name or 60 characters in Last_Name.

Receive the following error ...
SQL Error: ORA-12899: value too large for column "AP"."AP_SUP_SITE_CONTACT_INT"."FIRST_NAME" (actual: 20, maximum: 15)
and /or
SQL Error: ORA-12899: value too large for column "AP"."AP_SUP_SITE_CONTACT_INT"."LAST_NAME" (actual: 75, maximum: 60)


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.