#55 25x: Inventory Unique Constraint

R2.5.1
closed
Jorg Janke
7
2004-07-01
2004-07-01
Jorg Janke
No

When creating Physical Inventory, you may get an error
message ORA-00001: unique constraint
M_INVENTORYLINE_PRODUCTLOCATTR violated.

Fixed in 2.5.1e.

Fix:
SQL>

DROP INDEX M_InventoryLine_ProductLocAttr
/
DROP INDEX M_InventoryLine_Inventory
/
CREATE UNIQUE INDEX M_InventoryLine_ProductLocAttr
ON M_InventoryLine(M_Inventory_ID, M_Locator_ID,
M_Product_ID, M_AttributeSetInstance_ID)
TABLESPACE INDX
/

Discussion

  • Jorg Janke
    Jorg Janke
    2004-07-01

    • labels: --> Database.sql
    • milestone: --> R2.5.1
    • priority: 5 --> 7
    • assigned_to: nobody --> jjanke
     
  • Jorg Janke
    Jorg Janke
    2004-07-01

    • status: open --> closed