[sgshah]

Hi,

I am having issues updating a custom table using 'Upload an XML/CSV Transmission' in OTM.

The initial load of the table is fine; however, following update to the table are erroring out.

Table Definition:
----------
CREATETABLE CUSTOM_TABLE (
DC VARCHAR2(100)NOTNULL,
STATE VARCHAR2(100)NOTNULL,
LAST_PICK_RELEASE VARCHAR2(100)NOTNULL,
SHIPMENT_DATE VARCHAR2(100)NOTNULL,
DELIVERY_DATE VARCHAR2(100)NOTNULL,
DOMAIN_NAME VARCHAR2(50)NOTNULL,
INSERT_USER VARCHAR2(128)NOTNULL,
INSERT_DATE DATENOTNULL,
UPDATE_USER VARCHAR2(128),
UPDATE_DATE DATE,
PRIMARYKEY( DC, STATE )
----------

I have provided grants to APP_USER and EXT_USER. As well as created similar Triggers found in other OTM tables (to update UPDATE_DATE & UPDATE_USER etc.)

The initial load CSV is something like this (Sample):
----------
GLOGOWNER.CUSTOM_TABLE
DC,STATE,LAST_PICK_RELEASE,SHIPMENT_DATE,DELIVERY_ DATE,DOMAIN_NAME
ONT,AK,Monday,Wednesday,Friday,TESTDOMAIN
ONT,HI,Monday,Wednesday,Friday,TESTDOMAIN
ONT,DE,Monday,Wednesday,Tuesday,TESTDOMAIN
--------

And the update CSV is something like this:
--------
GLOGOWNER.CUSTOM_TABLE
DC,STATE,LAST_PICK_RELEASE,SHIPMENT_DATE,DELIVERY_ DATE,DOMAIN_NAME
ONT,AK,Monday,Wednesday,Monday,TESTDOMAIN
ONT,HI,Monday,Wednesday,Monday,TESTDOMAIN
ONT,DE,Monday,Wednesday,Monday,TESTDOMAIN
--------

When I try to upload the update into OTM via CSV (using IU - Insert Update), all records fail with the following error: ORA-00936: missing expression. The Key to the table is STATE-DC, and thus I would assume that any changes to the non-key fields would be updated, however, no changes to the table are seen, as they all error out.

Thanks,
Samir