Charter Update Via Import Throwing Error In Submission (Doc ID 2206601.1)

Last updated on MARCH 08, 2017

Applies to:

Instantis EnterpriseTrack Cloud Service - Version 15.2.0.0 to 15.2.5.0 [Release 15.2]
Instantis EnterpriseTrack - Version 15.2.0.0 to 15.2.5.0 [Release 15.2]
Information in this document applies to any platform.

Symptoms

When doing charters update some records that pass validation receive evaluation exception during submission in the import step.

ERROR
-----------------------
Error in Submission...

Review the errors shown below, click the button at left, and try to correct the errors noted. Then submit again.

Submission failed.<br> Evaluation exception during submission.

[engine-id = F_LFG85QPSSXQ7C, engine-name =
/adminconfig/dataupload/process_stagingdata, time = 2016-08-02 09:27:27.489
EDT] ModifyDB: There is no value for "initial_forecast_nonrollup":
{actual_start_date=Thu Jul 31 21:00:00 PDT
2014,primary_metric_name=N/A,defect_definition=,measurement_system=,project_na
2016,filler10=,planned_completion_date=Mon May 16 21:00:00 PDT
2016,project_type=pt_5_KT4HDKC2QRXL5,insert_date=Thu Jul 31 21:00:00 PDT
2014,fin_approval_template_id=,accepted_by=KT5NDM4W3KJS9,estimated_duration=0,business_unit=Division_KT4GJQ3TGNHXQ,functional_area=,sub_unit=BU_KGXMGT9N258QX,intangible_benefits=,planned_start_date=nulldate(),region=Location_JPL2L8R94HGGR,filler9=,filler8=,originalideanumber=,filler5=,filler4=,problem_statement
bio,roadmap=WBS__KT88MJ4K8WC82,filler7=,filler6=,filler1=,benefits_to_be_pursued=,filler3=,currency_code=EUR,filler2=,primary_metric_type=metric_family_KT4H
17 04:25:56 PST
2015,datefiller4=nulldate(),scs2=_GLOBAL_,datefiller3=nulldate(),funnelrevisionnumber=1,scs1=_GLOBAL_,datefiller2=nulldate(),datefiller1=nulldate(),class=class_id_0_KT4HDKC2QRXL5,pcs=pcs_0_KT4HDKC2QRXL5,product=,process=,creator=KT5NDM4W3KJS9,revised_by=sys_admin_uid,comments=,initial_forecast_cost=,source_of_measurement=,resources=,funnelnumber=34197,funnel_status=Accepted,project_number=29949,initial_forecast_savings=,location=SU_KV2PGSDJTJHJP,planned_realization_date=Tue Dec 30 21:00:00 PST
2014,fintemplate_id=ft_id_0_KT4HDKC2QRXL5,customer=} in expression
[saappend("/userdata/charters/funnelrevisionmaster", sw)] in function
/dataupload/processdata/charters/upload_charters/updateProposalForRevisions

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Administration> data import/export>Import Data>Charters
Update>Import data> upload customer file
2. Validate data
3. Import > the following error is produced

Changes

 

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