Error while getting baseline item-month level:ORA-00001: unique constraint (SYS.I_SQLOBJ$NAME_TYPE)
Hi All,
We are doing a custom procedure which does a select on sales_data and then inserts back into a custom series. We are getting error which does not look like a data/logical error.
It looks like a database error. We are able to reproduce it and the procedure is erroring at the same place. We are able to run the query outside.
It looks like some database related error.
**************************
select sum(nvl(FORE_0,0) * nvl(mdp.unit_cost,0)) bln_fcst_amt, sum(nvl(FORE_0,0)) bln_fcst_qty from sales_data sd ,mdp_matrix mdp where sd.item_id = 16855 and mdp.item_id = sd.item_id and mdp.location_id = sd.location_id and nvl(mdp.cie_npi_flag,0) <> 1 and sd.sales_date >= to_date('30-AUG-15','DD-MON-YY') and sd.sales_date <= to_date('26-SEP-15','DD-MON-YY')