Duplicate records appearing when creating new entries in a custom table

[Gallavalli Jaga]

We are experiencing an issue where duplicate records are being generated whenever a new entry is created in a custom table. Interestingly, these duplicate records are visible to some users but not to others. Has anyone encountered this behavior before, or can suggest possible reasons why visibility of these duplicates might differ across users?

[yashkamde]

Hello @Gallavalli Jaga ,

Are the records being generated through record producer?

If yes ! please check if you are using current.insert() in your record producer script or within your script include? If yes then please remove the line as Record producer itself generates a record in the target table and current.insert is not needed in this case.

If not ! plz check if any script is running the current.insert() that can cause recursiveness in the code..

If my response helped mark as helpful and accept the solution.

[Gallavalli Jaga]

The records are not being generated through a record producer. They are created manually by clicking the New button. After submitting, duplicate records appear in the list view for some users, while other users do not see the duplicates.

[Ankur Bawiskar]

@Gallavalli Jaga 

how are those records getting created?

any business rule has current.insert()?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Gallavalli Jaga]

The records are created manually by clicking the New button. After submitting, duplicate records appear in the list view for some users, while other users do not see the duplicates. There is no current.insert() in any business rule that could be causing this behavior. This issue is coming in Prod instance only not on sub prod's.