Question

2
Replies
397
Views
Close popover
Rajesh Yekkala (RajeshY9665)
Accenture

Accenture
US
RajeshY9665 Member since 2016 6 posts
Accenture
Posted: February 28, 2018
Last activity: November 1, 2018
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.