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.
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)
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