My Oracle Support Banner

ECC V4 Run Data With Full Load Failed ORA-12899: value too large for column (Doc ID 2707420.1)

Last updated on OCTOBER 18, 2020

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, ECC Property Manager

When attempting to run the ECC - Run Data Load the following error occurs.

ERROR
-----------------------
EBS, pn_ecc, pn-projection, FULL_LOAD, US, FALSE, INFO" failed with below error message "java.sql.SQLException: ORA-12899: value too large for column "PN"."PN_ECC_PROJECTION_TMP"."ACCOUNTING_METHOD" (actual: 66, maximum: 30)ORA-06512: at "APPS.PN_ECC_LOAD_PKG", line 10565ORA-06512: at "APPS.PN_ECC_LOAD_PKG", line 755"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ECC - Run Data Load

 

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.