View Single Post
  #2 (permalink)  
Old January 23rd, 2008, 08:04
james_foran james_foran is offline
Member
 
Join Date: Dec 2007
Posts: 58
Thanks: 5
Thanked 8 Times in 8 Posts
Groans: 1
Groaned at 1 Time in 1 Post
Rep Power: 1
james_foran is on a distinguished road
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.
Reply With Quote