搜索
1Oracle®RetailDataModelReleaseNotes10gRelease2(10.2)B32407-03April2009KnownissuesinthecurrentreleaseofOracleRetailDataModelaredocumentedinthefollowingsections:■Section1,OracleDatabase11gRelease1CertificationIssues■Section2,OUIInstallerandHelpissues■Section3,Out-of-StockIntra-ETLisnotprovided■Section4,PhysicalDataModeltablesrenamed■Section5,IssueswithRelational,DataMining,andOLAPcomponents■Section6,Translationissues■Section7,SampleReportandDashboardissues■Section8,FeaturesNotIncludedinThisRelease■Section9,UpdatedDocumentation1OracleDatabase11gRelease1CertificationIssuesTherefollowingissuesexistregardingusingOracleRetailDataModelwithOracleDatabase11g:■Section1.1,DesinstallationnotavailableforOracleRetailDataModelwhenusingOracleDatabase11gRelease1(11.1.0.7)■Section1.2,OracleDatabase11gOLAPcertification1.1DesinstallationnotavailableforOracleRetailDataModelwhenusingOracleDatabase11gRelease1(11.1.0.7)WhenusingOracleDatabase11.1.0.7,thedeinstallationoptionforOracleRetailDataModelisgreyedoutinOracleInstaller.ThisissueisdocumentedwithOraclebug82720881.2OracleDatabase11gOLAPcertificationTheOLAPcomponentofOracleRetailDataModeliscertifiedwithOracleDatabase11gRelease1(11.1.0.6andhigher).ThecertifiedOLAPcomponentisavailableonMyOracleSupport(formerlyOracleMetaLink)aspatch7701563.ThedetailsrelatingtothecertificationofOracleRetailDataModelwiththeOLAPOptionofOracleDatabase11gRelease1(11.1.0.6andhigher)areasfollows:2■TheOLAPcomponentofOracleRetailDataModelcontainstwodifferentcodebasesfortwoversionsoftheDatabase:■OracleDatabase10gRelease2(10.2.0.3andhigher)withOLAPAPatch■OracleDatabase11gRelease1(11.1.0.6andhigher)withOLAPAPatchThesetwosetsofsourcesarepresentindifferentfolders(directories)intheshiphomeandusedasdescribedinthedatabaseversion-specificinstallprocessoutlinedintheOracleRetailDataModelInstallationGuide.■TheOLAPcomponentofOracleRetailDataModelthatisinstalledforusewithOracleDatabase11gRelease1wasdevelopedwiththeOLAPcubetypesettingof11g.However,someOLAPfeaturesofOracleDatabase11gRelease1(forexample,QueryRewriteusingCube-basedMaterializedViewsandautomaticrefreshofcubesfromrelationaltables)arenotavailableinthisreleaseofOracleRetailDataModel.TheseOLAPfeaturesareplannedinthenextrelease.■TheOLAPDashboardforOracleRetailDataModelfunctionsagainsteitherversionoftheDatabase(thatis,Oracle10gRelease2orOracle11gRelease1).AccesstotheDatabasefromOBIEE(front-end,mid-tier)isthesameastheOracleDatabase10gRelease2modeofaccessofOracleOLAPcubesfromOBIEE.2OUIInstallerandHelpissuesThefollowingissuesexistwhenusingtheOUIInstalleroronlineHelpforOracleRetailDataModel:■Section2.1,Databasereadme.txtfiledisplaysonthelastscreenoftheInstaller■Section2.2,HelpTopicsforOracleRetailDataModelintheOUIInstallerIssues■Section2.3,Non-ASCIIcharactersonHelpNavigatordisplaygarbled2.1Databasereadme.txtfiledisplaysonthelastscreenoftheInstallerAfterinstallation,theOUIInstallerautomaticallyshowstheOracleDatabasereadme.txtfileonthelastscreen.ItdoesnotshowinformationspecifictoOracleRetailDataModelThisissueistrackedwithOraclebugnumber8284660.2.2HelpTopicsforOracleRetailDataModelintheOUIInstallerIssuesSelectingHelpbyclickingaHelpbuttonontheOUIInstallerdialogsdoesnotdisplayaHelptopicthatisspecifictoadisplayedOracleRetailDataModeldialog.Instead,selectingHelpinthismanneralwaysdisplaystheHelptopicthatistheintroductiontoOracleRetailDataModel.Note:FortheLinux64bitplatform,theOLAPAPatchisnotavailableforOracleDatabase11gRelease1(11.1.0.6).Consequently,therecommendedversionfortheLinux64bitplatformisOracleDatabase11gRelease1(11.1.0.6)withOLAPBPatch..32.3Non-ASCIIcharactersonHelpNavigatordisplaygarbledNon-ASCIIcharactersonHelpNavigatormaydisplaygarbledformostJavaGUIconventionalcomponentsonLinux4.0.TheproblemonlyimpactsHelpNavigatortree;itdoesnotimpacttheHelptopicwindow.ThisissueistrackedwithOraclebug6503286whichalsoprovidesaworkaround.3Out-of-StockIntra-ETLisnotprovidedOracleRetailDataModelprovidesrelationalimplementationofout-of-stockpredictionthroughtheuseofamodelSQLfunction.However,theIntra-ETLthattransformsthebasemodeltotherelationalout-of-stockmodelisnotprovidedwiththeOracleRetailDataModelpackage.ThecustomermustbuildtheIntra-ETLthattransformsthebasemodeltotheout-of-stockpredictionmodel.4PhysicalDataModeltablesrenamedThefollowingtableshavebeenrenamedandsynonymsfortheoriginaltablenameshavebeencreated.ThisissueisdocumentedwithOraclebugnumber8227932.5IssueswithRelational,DataMining,andOLAPcomponentsOracleRetailDataModelhasthefollowingknownissuesrelatingtotheRelational,DataMiningandOLAPcomponents:■Section5.1,AMiningReportishidden■Section5.2,Forecastinghappensonlyduringthehistoricalfullload■Section5.3,MaterializedViewRefreshmayexperienceORA-03113&ORA-006005.1AMiningReportishiddenThesamplePOSLossReporthasbeenhiddenasitdoesnotprovideanyoutput.OriginalTableNameandNewSynonymNameNewTableNameDWB_MKT_SLS_ITEM_WKDWB_MKT_SL_ITEM_WKDWB_RTL_SLS_RETRN_LINE_ITEMDWB_RTL_SL_RETRN_LINE_ITEMDWB_SLS_PLAN_ITEM_ORG_HRCHY_WKDWB_SL_PLAN_ITEM_ORG_HRCHY_WKDWA_PRMTN_SLS_MRGN_WKDWA_PRMTN_SL_MRGN_WKDWA_MKT_SLS