| Re: SKU creation I am not a database person, but ther is a trigger on the INSERT into SKU table. One part of it is.... BEFORE INSERT OR UPDATE ON SKU
FOR EACH ROW
BEGIN
IF INSERTING THEN
IF :NEW.INSERT_USER IS NULL OR :NEW.INSERT_DATE IS NULL THEN
:NEW.INSERT_USER := vpd.get_gl_user;
:NEW.INSERT_DATE := vpd.gmt_sysdate;
END IF;
:new.partition_key := partit.domain_part_key(:new.domain_name);
ELSE
:NEW.partition_key := :OLD.partition_key;
:NEW.INSERT_USER := :OLD.INSERT_USER;
:NEW.INSERT_DATE := :OLD.INSERT_DATE;
:NEW.UPDATE_USER := vpd.get_gl_user;
:NEW.UPDATE_DATE := vpd.gmt_sysdate;
END IF;
party.domain_part_key is a function that returns a number... You should get one of your DB guys to have a look at this error. |