PRC:POZ: ESS Job Load Interface File For Import Is Failing With Error: ORA-12899: value too large for column When Importing Supplier Addresses Using FBDI (Doc ID 2612499.1)

Last updated on FEBRUARY 07, 2025

Applies to:

Symptoms

Create Suppliers

ESS Job Load Interface File for Import Import failing for Import Supplier Address using the FBDI template

When trying to load interface data for importing supplier address using FBDI template and the load interface file for import job is failing with the following error:


ERROR
-----------------------
Record 3102: Rejected - Error on table POZ_SUP_ADDRESSES_INT, column FAX.
ORA-12899: value too large for column ??? (actual: 17, maximum: 15)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate the SupplierAddressImportTemplate.xlsm
2. Use a fax number with more than 15 characters
3. Observe error
Record 3102: Rejected - Error on table POZ_SUP_ADDRESSES_INT, column FAX.
ORA-12899: value too large for column ??? (actual: 17, maximum: 15)

Changes

Cause

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