we have created a below table in BIX Database. Its allowing to insert duplicate records into the table when ever the same case/transaction has update. so as my requirement we need to store/capture the final update of the case/transaction into table.

It will be great if someone helps us with resolution.

CREATE TABLE BIXDATA.FIXTROUBLETICKET
(
"PZINSKEY" VARCHAR2(256 BYTE) NULL,
"PXEXTRACTIDENTIFIER" VARCHAR2(256 BYTE) NULL,
"PXEXTRACTDATETIME" TIMESTAMP(6) ,
"PXCREATEDATETIME" TIMESTAMP(6) ,
"PXCREATEOPERATOR" VARCHAR2(128 BYTE) NULL,
"WTN" VARCHAR2(16 BYTE) NULL,
"PXUPDATEDATETIME" TIMESTAMP(6) ,
"PXUPDATEOPERATOR" VARCHAR2(32 BYTE) NULL,
"CAPARENTID" VARCHAR2(32 BYTE) NULL,
"PXCOMMITDATETIME" TIMESTAMP(6) ,
"INSIDEACCESSREQUIRED" VARCHAR2(256 BYTE) NULL,
"REPORTCODE" VARCHAR2(256 BYTE) NULL,
"AFFECTEDSERVICES" VARCHAR2(1024 BYTE) NULL,
"CUSTOMERTROUBLE" VARCHAR2(1024 BYTE) NULL,
"POCPHONENO" VARCHAR2(256 BYTE) NULL,
"TICKETNO" VARCHAR2(256 BYTE) NULL,
"TICKETTYPE" VARCHAR2(256 BYTE) NULL,
"SERVICECASEID" VARCHAR2(256 BYTE) NULL,
"AVAILABLEAPPOINTMENTENDDATE" TIMESTAMP(6) ,
"AVAILABLEAPPOINTMENTSTARTDATE" TIMESTAMP(6) ,
"APPOINTMENTENDDATE" TIMESTAMP(6) ,
"APPOINTMENTSTARTDATE" TIMESTAMP(6),
CONSTRAINT FIXTROUBLETICKET_PK PRIMARY KEY (PZINSKEY, PXUPDATEDATETIME)
) TABLESPACE BIXDATA;

Regards,

Rajesh.