My Oracle Support Banner

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 JUNE 11, 2020

Applies to:

Oracle Fusion Supplier Model Cloud Service - Version 11.13.19.07.0 and later
Oracle Fusion Supplier Model - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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