My Oracle Support Banner

Customer Import Error: ORA-12899: value too large for column ??? (Doc ID 2615384.1)

Last updated on MAY 18, 2020

Applies to:

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

Symptoms

Since the latest version of Oracle Cloud we are not able to create new customers.  The process 'Load Interface File for Import' results in an error.

Issue 1:
Error on table RA_CUSTOMER_PROFILES_INT_ALL, column CREDIT_BALANCE_STATEMENTS
The log shows the following message:
Record 1: Rejected - Error on table RA_CUSTOMER_PROFILES_INT_ALL, column CREDIT_BALANCE_STATEMENTS.
ORA-12899: value too large for column ??? (actual: 7, maximum: 1)


Issue 2:
Error on table HZ_IMP_ACCTSITES_T, column ACCT_SITE_LANGUAGE
The log shows the following message:
Record 1: Rejected - Error on table HZ_IMP_ACCTSITES_T, column ACCT_SITE_LANGUAGE.
ORA-12899: value too large for column ??? (actual: 9, maximum: 4)



Changes

 update 19C

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


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