Question

5
Replies
1705
Views
Mahendra_Kumar Member since 2011 12 posts
Tata Consultancy Services
Posted: 3 years ago
Last activity: 3 years 5 months ago
Closed

Hard Deleting Work Object Data using SQL

Hi,

Our client wishes to implement a clean up process by using SQL queries to be run as and when required.

So, we have identified the following tables from which thw work object and its dependent data to be deleted.

PC_DATA_WORKATTACH

PC_LINK_ATTACHMENT

PC_ASSIGN_WORKLIST/PC_ASSIGN_WORKBASKET

WORK OBJECT TABLE

Can you please let me know if hard deleting the data from these tables would be enough or we have to consider any other tables ?

Also, what additional processing should we consider while performing this operation.?

Thanks.

***Updated by moderator: Lochan to update Categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn