Data Pull Completing In Error With Error Message ORA-12899: Value Too Large For Column

(Doc ID 2074908.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

12.1.3.9.1 - APS

When attempting to run the Data Collections, the following error occurs in the Planning Data Pull/Worker (MSCPDP/MSCPDPW)...

ERROR
-----------------------
05-OCT 03:37:00 : LOADING TRADING PARTNERS
05-OCT 03:37:33 : Error pulling data from MRP_AP_CUSTOMER_SITES_V to MSC_ST_TRADING_PARTNER_SITES.
05-OCT 03:37:33 : ORA-12899: value too large for column "MSC"."MSC_ST_TRADING_PARTNER_SITES"."PARTNER_SITE_NUMBER" (actual: 31, maximum: 30)
05-OCT 03:37:33 : ORA-12899: value too large for column "MSC"."MSC_ST_TRADING_PARTNER_SITES"."PARTNER_SITE_NUMBER" (actual: 31, maximum: 30)
05-OCT 03:37:33 : Error_Stack...
05-OCT 03:37:33 : ORA-12899: value too large for column "MSC"."MSC_ST_TRADING_PARTNER_SITES"."PARTNER_SITE_NUMBER" (actual: 31, maximum: 30)

05-OCT 03:37:33 : Error_Backtrace...
05-OCT 03:37:33 : ORA-06512: at "APPS.MSC_CL_PULL", line 7039
ORA-06512: at "APPS.MSC_CL_PULL", line 1805

ANALYSIS
-------------
1. Code to pull data is in MSCPSTPB.pls - customer version MSCPSTPB.pls 120.3.12010000.3

  933 /* For bug 2564735 , added substr for 30 chars on the column partner_site_number */
  934 v_sql_stmt:=
  935 'insert into MSC_ST_TRADING_PARTNER_SITES'
  936 ||' ( TP_SITE_CODE,'
 .....
  982 ||' x.COUNTY,'
  983 ||' substr(x.PARTNER_SITE_NUMBER,1,30), '
  984 /* SCE Change Ends */
  985 ||' :v_instance_id'
 986 ||' from MRP_AP_CUSTOMER_SITES_V'||MSC_CL_PULL.v_dblink||' x'
 
2. Trace file show the same code executed.
In file - FTP.zip
see trace file - DCYP1C_ora_11527_SYSADMIN_CR570066.trc
matches log file - l570066.txt

line 15059 - PARSING IN CURSOR #140079800177016
insert into MSC_ST_TRADING_PARTNER_SITES ( TP_SITE_CODE, SR_TP_ID,
.....
.COUNTY, substr(x.PARTNER_SITE_NUMBER,1,30),
  :v_instance_id from MRP_AP_CUSTOMER_SITES_V@APSDEV1_TO_EBSDEV1 x WHERE (x.RN1>-1 OR x.RN2>-1 OR x.RN3>-1)

 line 15636 - ERROR #140079800177016:err=12899 tim=1444195067084601

3. Appears that this may be multi-byte character causing the issue.

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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot continue with planning.

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