Question

2
Replies
371
Views
RajeshY9665 Member since 2016 6 posts
Accenture
Posted: 2 years ago
Last activity: 1 year 10 months ago
Closed

BIX can do updates in same record instead of inserting duplicate record in table when same case/transaction updated.

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.

Data Integration
Moderation Team has archived post
Share this page LinkedIn