Resolution:
How to handle date datatype attribute/value while using dbloader

Environment:
==========
TIBCO Product name and version: TIBCO Collaborative Information Manager 7.x.x and 8.x.x
Operating System(s): All Operating Systems

Symptoms:
========
Following exception would be thrown when date datatype attribute is mapped with string datatype datasource attribute.
ID: C3E9C6EE_4369466E27AF5D780127B07D503839EF
DATETIME: 2010-03-30T20:12:34+00:00
EXCEPTIONMESSAGE: java.sql.SQLException: ORA-01861: literal does not match format string
STACKTRACE: java.sql.SQLException: ORA-01861: literal does not match format string
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
        at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:125)
        at com.martquest.util.MqDebuggableStatement.executeUpdate(MqDebuggableStatement.java:388)
        at com.martquest.util.MqDebuggableStatement.executeUpdate(MqDebuggableStatement.java:404)
        at com.martquest.session.catalog.initialload.DBLoaderSsnBean.bulkInsetMCT(DBLoaderSsnBean.java:1414)
        at com.martquest.session.catalog.initialload.DBLoaderSsn_6k4fjk_EOImpl.bulkInsetMCT(DBLoaderSsn_6k4fjk_EOImpl.java:364)
        at com.martquest.session.catalog.initialload.DBLoaderBusinessDelegate.bulkInsetMCT(DBLoaderBusinessDelegate.java:131)
        at com.martquest.catalog.engine.AsyncDBLoader.bulkLoadMct(AsyncDBLoader.java:583)
        at com.martquest.catalog.engine.AsyncDBLoader.onAsyncCall(AsyncDBLoader.java:167)
        at com.martquest.async.AsyncCallMessageListener.onMessage(AsyncCallMessageListener.java:57)
        at com.martquest.messaging.MqNativeMessageListener.onMessage(MqNativeMessageListener.java:70)
        at com.tibco.tibjms.TibjmsxSessionImp._submit(TibjmsxSessionImp.java:3944)
        at com.tibco.tibjms.TibjmsxSessionImp._dispatchAsyncMessage(TibjmsxSessionImp.java:2197)
        at com.tibco.tibjms.TibjmsxSessionImp$Dispatcher.run(TibjmsxSessionImp.java:3470)
DBERRORCODE: 1861

Cause:
=====

Resolution:
========
Map the date field as follows in the input mappings, when the value for ITEM_MASTER_BULK_LOAD.SALES_VARIANT_EFFECTIVE_DATE is the format of YYYYMMDD.

to_date(@ITEM_MASTER_BULK_LOAD.SALES_VARIANT_EFFECTIVE_DATE,'YYYYMMDD')

References:
=========

How to handle date datatype attribute/value while using dbloader