[bob_romijn]

Hi,

THis is because your trigger code is not as it was originally from Glog/Oracle. I raised a SR last week(s) with Oracle to solve this because we have the same issue. (Wondering who you really are and not working on the same machine?....)

Oracle advises this on the SKU table:

The trigger CHK_BIU_SKU has been modified, it is not same as OTM supplied version. It appears that
client version has more code to support additional client specific functionality.

Existing client version is as shown below (so wrong).

-------------
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.calc_part_key('SKU', :new.insert_date);
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;
IF VPD.SHOULD_COPY THEN
:NEW.OWNER_CORPORATION_GID := vpd.replace_gid(:NEW.OWNER_CORPORATION_GID);
:NEW.PACKAGED_ITEM_GID := vpd.replace_gid(:NEW.PACKAGED_ITEM_GID);
:NEW.SHIP_UNIT_SPEC_GID := vpd.replace_gid(:NEW.SHIP_UNIT_SPEC_GID);
:NEW.SKU_GID := vpd.replace_gid(:NEW.SKU_GID);
:NEW.SUPPLIER_CORPORATION_GID := vpd.replace_gid(:NEW.SUPPLIER_CORPORATION_GID);
:NEW.USER_DEFINED1_ICON_GID := vpd.replace_gid(:NEW.USER_DEFINED1_ICON_GID);
:NEW.USER_DEFINED2_ICON_GID := vpd.replace_gid(:NEW.USER_DEFINED2_ICON_GID);
:NEW.USER_DEFINED3_ICON_GID := vpd.replace_gid(:NEW.USER_DEFINED3_ICON_GID);
:NEW.USER_DEFINED4_ICON_GID := vpd.replace_gid(:NEW.USER_DEFINED4_ICON_GID);
:NEW.USER_DEFINED5_ICON_GID := vpd.replace_gid(:NEW.USER_DEFINED5_ICON_GID);
:NEW.WAREHOUSE_LOCATION_GID := vpd.replace_gid(:NEW.WAREHOUSE_LOCATION_GID);
:NEW.DOMAIN_NAME := vpd.replace_domain_name(:NEW.DOMAIN_NAME);
END IF;
END;
--------------------


Please change to the below code:OTM supplied version is as shown below.
-------------------
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;
END;
---------------------


Without this change we are not able to add records into the SKU table.

Best regards,

Bob