AnsweredAssumed Answered

Database Dynamic Delete

Question asked by spaduri906455 on Sep 16, 2018
Latest reply on Sep 18, 2018 by trey.yeager826393

Hello all,

 

I have got a requirement to delete the records in target table Salesorder Line(Oracle DB) which were deleted in Source Table(Netsuite). (Key - InternalID and Line)

I have developed a process to update/insert the records into DB from Netsuite using Standard Statement. I have tried including delete in Merge statement by comparing InternalId and Line but never succeeded.  So trying to develop a separate process for delete.

 

1)Records in Database to be deleted whenever it gets deleted in Netsuite

2)Comparison Keys- InternalID and Line

 

 

Any ideas on how to develop will be helpful.

 

Thanks in Advance.

Susvith

Outcomes