While Importing the 6.1.1 Oracle Database Dump Receive Error: "IMP-00041: Warning: object created with compilation warnings" (Doc ID 1587251.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 6.1.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to import the PLM for Process 6.1.1 Oracle Database dump, receiving the following errors:

IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PLM4P"."VWBILASTNPDSTAGE"     ("LA"
 "STNPDSTAGE") AS "
 "("
 "    select LAST_NPD_STAGE() as LASTNPDSTAGE from dual"
 ")"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PLM4P"."VWBINPDPRJSTARTENDDATES"                        "
 "   ("PROJECTPKID","SCHEDULEPKID","INMARKETLAUNCHDATE","ACTUALINMARKETLAUNCH"
 "DATE","CREATIONDATE","MODIFICATIONDATE","STAGE1PLANNEDSTARTDATE","GATE5PLAN"
 "NEDENDDATE","STAGE1ACTUALSTARTDATE","GATE5ACTUALENDDATE") AS "
 "("
 " select proj.pkid as PROJECTPKID, aps.pkid as SCHEDULEPKID, "
 " NULLIF(aps.InMarketLaunchDate,to_date('9999-12-31','yyyy-mm-dd')) as INMAR"
 "KETLAUNCHDATE, "
 " NULLIF(aps.ActualInMarketLaunchDate,to_date('9999-12-31','yyyy-mm-dd')) as"
 " ACTUALINMARKETLAUNCHDATE,"
 " NULLIF(act.CreationDate,to_date('9999-12-31','yyyy-mm-dd')) as CREATIONDAT"
 "E,"
 " NULLIF(act.ModificationDate,to_date('9999-12-31','yyyy-mm-dd')) as MODIFIC"
 "ATIONDATE, "
 " NULLIF(asm.PlannedStartDate,to_date('9999-12-31','yyyy-mm-dd')) as STAGE1P"
 "LANNEDSTARTDATE,"
 " NULLIF(asm2.PlannedEndDate,to_date('9999-12-31','yyyy-mm-dd')) as GATE5PLA"
 "NNEDENDDATE,"
 " NULLIF(asm.ActualStartDate,to_date('9999-12-31','yyyy-mm-dd')) as STAGE1AC"
 "TUALSTARTDATE,"
 " NULLIF(asm2.ActualEndDate,to_date('9999-12-31','yyyy-mm-dd')) as GATE5ACTU"
 "ALENDDATE"
 " from npdProjects proj"
 " left outer join npdIdea isp on proj.fkIdea = isp.pkid"
 " left outer join npdStageMasterStages sms1 on isp.fkTargetStage = sms1.fkSt"
 "ageStatus"
 " inner join npdProjectTemplates pt on proj.fkProjectTemplate = pt.pkid"
 " left outer join npdStageMasterStages sms2 on pt.fkStartStage = sms2.fkStag"
 "eStatus"
 " inner join npdActivities act on proj.pkid = act.fkProject"
 " inner join npdActivityProjectSchedules aps on aps.fkActivity = act.pkid"
 " inner join npdActivityStageMilestones asm on asm.fkActivityProjectSchedule"
 " = aps.pkid and "
 " asm.StageNumber = (case when (sms1.StageNumber is not null) then sms1.Stag"
 "eNumber"
 " when (sms2.StageNumber is not null) then sms2.StageNumber else 1 end) and "
 " asm.isGate = 0"
 " inner join npdActivityStageMilestones asm2 on asm2.fkActivityProjectSchedu"
 "le = aps.pkid and asm2.StageNumber = LAST_NPD_STAGE() and asm2.isGate = 1)"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PLM4P"."VWBISPECWKFLWFS"                           ("SPE"
 "C_PROC_PKID","OLD_STATUS_PKID","NEW_STATUS_PKID","ISCOMPLETE","SPEC_PKID",""
 "SPEC_TYPE","TAXONOMY_PKID","SPEC_STEP_PKID","ACTIVE_STEP_IN_RED_FLG","DAYS_"
 "BEYOND_RED","WKFLW_DUR_DAYS_AMBER","WKFLW_DUR_DAYS_RED","CREATE_DATE","ACTI"
 "VITY_DATE","APPROVE_DATE","LAST_EDIT") AS "
 "("
 "select ss.fkProcessTemplate, wfh.status, wfh.NewStatus, "
 "case "
 "  when (wfat2.Position = wfat.Position and wfat2.IsTerminal = 1) then 1"
 "  when wfat2.Position > wfat.Position then 1 "
 "  else 0 "
 "end,"
 "ss.SpecID, ss.SpecType, ss.fkTaxonomyNode, wfat.pkid, (case when (ss.SpecSt"
 "atusID = wfh.NewStatus and ss.LastEdit = wfh.activityDate) then 1 else 0 en"
 "d), "
 "(case when wfat.RedSLA > 0 then cast((getDate() - (wfh.activityDate + wfat."
 "RedSLA)) as int) else 0 end), wfat.AmberSLA, wfat.RedSLA, "
 "NULLIF(ss.CreatedDate,to_date('9999-12-31','yyyy-mm-dd')),"
 "NULLIF(wfh.activityDate,to_date('9999-12-31','yyyy-mm-dd')),"
 "NULLIF(sdh.activityDate,to_date('9999-12-31','yyyy-mm-dd')),"
 "NULLIF(ss.LASTEDIT,to_date('9999-12-31','yyyy-mm-dd'))"
 "from specSummary ss "
 "inner join SpecWorkflowAuditHistory wfh on wfh.docID = ss.SpecID "
 "left join gsmWorkflowActivityTemplates wfat on wfat.fkProcessTemplate = ss."
 "fkProcessTemplate and wfat.fkWorkflowStatus = wfh.NewStatus "
 "left join gsmSignatureDocs sd on sd.fkParent = ss.pkid and sd.fkParentWorkf"
 "lowStatus = wfh.NewStatus and sd.CreatedDate = wfh.activityDate "
 "left join gsmSignatureDocWFAuditHistory sdh on sdh.docID = sd.pkid and sdh."
 "status = sd.fkWorkflowStatus"
 "left join gsmWorkflowActivityTemplates wfat2 on wfat2.fkProcessTemplate = s"
 "s.fkProcessTemplate and wfat2.fkWorkflowStatus = ss.SpecStatusID "
 "where ss.SpecType in (1004, 2147, 1009, 2121, 6500, 6501, 5750, 5816))"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PLM4P"."VWBIGSMSPECSUMMARYMENUDETAILS"                  "
 "         ("MENUITEM","PACKAGING","APPEARANCE","SENSORY","PKID","STANDARDNAM"
 "E") AS "
 "SELECT PARSE_MENU_ATTR('MenuItem', content_list) as MENUITEM, PARSE_MENU_AT"
 "TR('Packaging', content_list) as PACKAGING,PARSE_MENU_ATTR('Appearance', co"
 "ntent_list) as APPEARANCE,"
 "PARSE_MENU_ATTR('Sensory', content_list) as SENSORY, PKID, STANDARDNAME FRO"
 "M (SELECT sensory.Content as content_list, mi.pkid, sml.Name as standardNam"
 "e FROM FoodServiceMenuItem mi"
 "left outer join FoodServiceStandardType standards on mi.fkStandard = standa"
 "rds.pkid"
 "left outer join FoodServiceStandardTypeML sml on standards.pkid = sml.fkFoo"
 "dServiceStandard"
 "left outer join commonTextRepository sensory on mi.pkid = sensory.fkParent)"

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