In TC OOTB functionality, whenever user will click on the 'Documents' tab then only 'InvolvedList' folder will be created due to which it is creating duplicate entries in source database under E_DOCU table for InvolvedList folder as there is custom action rule created under the 'Documents' objects.
- There are 2 custom fields which are created on Document object under the 'DOCU' category 'template' boolean type custom field and other field is 'uniqueID' is of text type custom field.
- Whenever 'InvolvedList' folder is created by default 'template' field is populated with default value and it is creating an entry under the 'E_DOCU' table.
- At same moment other entry is added with primary key as above entry under 'E_DOCU' table to populate the 'uniqueID' value through the custom action rule '8.1 Sequential Document ID'.
As a workaround, below are the steps implemented:
- We resolved this issue bye passing the custom action rule '8.1 Sequential Document ID' to update the custom field 'uniqueID' value only other than the 'InvolvedList' folder [Please refer the screenshot of the Qualifier which applied to bye-pass the rule].
[Please refer the attached screenshot Qualifier.png]
To populate the 'uniqueID' field on the document object, we have created a schedule action rule to execute for every 3 hours and it will search if the 'InvolvedList' folder is created and 'uniqueID' is not populated then it will populate the field with 'DOCU-PKPK', where 'PKPK' is primary key of the Document record. [Below is the schedule action configured under the Schedule Action Monitor and please find the schedule action class file attached to this email].
[Please refer the attached screenshot ScheduleAction.png and schedule action class file used to update the fields]