Problem

WebEDI Installation with Oracle 12

Resolution

Before starting the installation, do the following changes in the installation kit:

• In /WebEDI_Portal_3.6.1_allOS_BN1_dvd/Components/WebEDI_Portal_V3.6.1/delivery/Database/install/sql/oracle/base_setup.sql, you need to comment this line:
• In /home/qatestn0/WebEDI_Portal_3.6.1_allOS_BN1_dvd/Components/WebEDI_Portal_V3.6.1/delivery/Database/install/sql/oracle/obp_setup.sql, you need to comment these lines:

-- create bitmap index idx_perf_adm_msg_01 on adm_message (job_id);

-- create bitmap index idx_supplier_idx002 on idx_supplier (org_nr, lieferant_nr, abladestelle);

-- create bitmap index idx_supplier_idx003 on idx_supplier (org_nr);

-- create bitmap index idx_supplier_idx004 on idx_supplier (lieferant_nr);

-- create bitmap index idx_supplier_idx005 on idx_supplier (abladestelle);

-- create bitmap index idx_perf_idx_sup_01 on idx_supplier (msg_id);

-- create bitmap index idx_perf_mdb_psm_01 on mdb_plant_sup_map (supplierno);

-- create bitmap index idx_perf_mdb_psm_02 on mdb_plant_sup_map (supplierid);

During installation:

• You can select Oracle 10g or Oracle 11g
• At “Database options” step, set for “Verify information: false” (by default is true - please check attachment)