How To Change The Date Format For Date Columns In BICC Extract

Summary:

Hi Team,

My requirement is to insert the values from the date columns of BICC extract into ATP using DBMS_CLOUD.COPY_DATA functionality. COPY_DATA is not working if I have the target column datatype as DATE and the BICC extract contains value as '2025-11-10 15:08:14.330000'. Please share your inputs. Much appreciated. Thanks in advance!

CREATE TABLE "XXXPO_SUPPLIER_STG"
( "CREATIONDATE" DATE,
"LASTUPDATEDATE" DATE,
"PARTNERNAME" VARCHAR2(2000 BYTE) COLLATE "USING_NLS_COMP",
"PARTNERNUMBER" VARCHAR2(2000 BYTE) COLLATE "USING_NLS_COMP",
"PARTNERTYPE" NUMBER,
"TPID" NUMBER
);

Sample Data:

CREATIONDATE,LASTUPDATEDATE,PARTNERNAME,PARTNERNUMBER,PARTNERTYPE,TPID
"2025-11-14 13:49:03","2025-12-19 11:16:34","Test Name","1","4","62002"