Attachment not showing in attachment table but visible in work notes of Change request

[Roopa11]

Hi All,

We have one strange issue, user is sending one csv file to change request, its showing in work notes and visible to some users not for all.

and this attachment not showing as attachment to change request and its not present in attachment table also.

I can observe that attachment present in staging table..

What could be the issue here..

Thanks

[Rajesh Chopade1]

Hi @Roopa11 

Do following check once:

Verify that the users who cannot see the attachment have the correct roles and permissions to view attachments on change requests. Check ACLs (Access Control Lists) for attachments on the change request table (change_request) to ensure they are not preventing access.

Ensure that there are no errors in moving attachments from the staging table to the sys_attachment table.

Review business rules and scripts associated with the change request process. Ensure there are no conditions that selectively hide attachments.

Manually verify if you can move the attachment from the staging table to sys_attachment using scripts or SQL queries.

Look for any client scripts or data policies that might influence attachment visibility.

Replicate the issue in a non-production environment to better understand the conditions causing it.

i hope my answer helps you to resolve your issue if yes please mark my answer correct & helpful.

thank you

rajesh

[Slava Savitsky]

What do you mean by "sending one csv file to change request"?

When you search for the file in the attachments table, what filter do you use?

What "staging table" are you referring to?

[Roopa11]

What do you mean by "sending one csv file to change request"?

Ans : attaching file to change request

When you search for the file in the attachments table, what filter do you use?

Ans : file name

What "staging table" are you referring to?

ans : before change request created in change_request table, we have given access to custom table (staging) from there syn happening to main change_request table

[Slava Savitsky]

I am afraid it doesn't help much. It sounds like you have some customization that uses a staging table, but you are not willing to share any details. How are we supposed to help you without knowing anything about the setup of your system?