My Oracle Support Banner

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 JUNE 21, 2018

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

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
Cause
Solution
 WORKAROUND:
 SOLUTION:
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.