POSSUPIMP: Integrated Supplier Import Program Fails with ORA-12899 When Supplier Contact Name or Contact Number Are Greater Than 30 Characters In Length (Doc ID 2189463.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Supplier Hub - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

The POSSUPIMP: Integrated Supplier Import Program fails when the contact name or contact number are greater than 30 characters in length.

WARNING****** Unexpected error occured in pre_processing.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
 Message: Inside PROCEDURE IMPORT_BATCH Parameters:  p_batch_id: 42003 p_import_run_option: COMPLETE p_run_batch_dedup: N p_run_registry_dedup: N
 Message: Inside PROCEDURE IMPORT_BATCH Parameters:  p_batch_id: 42003 p_import_uda_only: N p_enable_party_as_supp: Y
 Message: Inside PROCEDURE check_party_exist Parameters:  p_batch_id: 42003 Rows inserted in hz_imp_parties_int: 25
 Message: Inside PROCEDURE check_party_site_exist Parameters:  p_batch_id: 42003 Rows inserted in hz_imp_addresses_int: 83
 Message: Inside PROCEDURE check_party_contact_exist Parameters:  p_batch_id: 42003 Rows inserted in hz_imp_parties_int: 108
 Inside check_party_contact_exist EXCEPTION  Message: -12899 ORA-12899: value too large for column "AR"."HZ_IMP_CONTACTS_INT"."CONTACT_NUMBER" (actual: 31, maximum: 30)
Error Message Count: 0 Error Message Data:  From check_party_contact_exist API.
UIC***** No. of Messages: 0, Message:  From pre_processing API.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+



 

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