1980794 - Errors during EIS Analytics 6.10 DataMart installation on a non-partitioned Oracle database

While installing EIS Analytics 6.10 Datamart on an Oracle database that is NOT partitioned, you see the following errors (or similar) in the install log:

1. CREATE TABLE DM_REPLENISHMENT_RUN
                   *
   ERROR at line 1:
   ORA-00955: name is already used by an existing object
   
   (other table names would include 'DM_REPLENISHMENT_RUN_DETAIL' and 'DM_REPLENISHMENT_ORDERS')
2. ON DM_FACT_SUPPLY_PATH(SCENARIO_PUSH_SK, TARGET_ITEM_SK)
                                                                                                 *
   ERROR at line 2:
   ORA-00904: "TARGET_ITEM_SK": invalid identifier
3. UPDATE DM_NODE SET LOCATION_SK = 1 WHERE TBL_KEY = 1
                                              *
   ERROR at line 1:
   ORA-00904: "LOCATION_SK": invalid identifier
4. UPDATE DM_NODE SET ITEM_SK = 1 WHERE TBL_KEY = 1
                                              *
   ERROR at line 1:
   ORA-00904: "ITEM_SK": invalid identifier
5. UPDATE DM_NODE SET ITEM_KEY = 0 WHERE TBL_KEY = 1
                                              *
   ERROR at line 1:
   ORA-00904: "ITEM_KEY" : invalid identifier
6. UPDATE DM_NODE SET LOCATION_KEY = 0 WHERE TBL_KEY = 1
                                              *
   ERROR at line 1:
   ORA-00904: "LOCATION_KEY": invalid identifier
7. INSERT INTO DM_VERSION
   *
   ERROR at line 1:
   ORA-01400: cannot insert NULL into ("SOPS_DATASTORE"."DM_VERSION"."DM_PRODUCT_KEY")

This applies to EIS Analytics 6.10, specifically the installation of the DataMart.

EIO, AIM, SmartOps , KBA , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , Problem