SKU creation - error

[rj5316]

Hi,

we get the following errror when trying to create an SKU.... can anyone help....

"java.sql.SQLException: ORA-01821: date format not recognized ORA-06512: at "GLOGOWNER.PARTIT", line 93 ORA-06512: at "GLOGOWNER.PARTIT", line 105 ORA-06512: at "GLOGOWNER.CHK_BIU_SKU", line 7 ORA-04088: error during execution of trigger 'GLOGOWNER.CHK_BIU_SKU'"

rgds--

[james_foran]

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.

[bob_romijn]

Re: SKU creation - error

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