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 OCTOBER 01, 2024

Applies to:

Goal

What is the right process to handle the data on the import process to avoid the error :  SQL Error: ORA-12899: value too large for column "AP"."AP_SUP_SITE_CONTACT_INT"."FIRST_NAME" (actual: 20, maximum: 15)

This is the scenario:

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.

Steps
=============================================
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)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.