Purchase order/agreement change order new file not found in UCM

Summary:

Content (please ensure you mask any confidential information):

Hi all,

I've been working on a query to get the latest pdf file (xx_00012_0.pdf) (when clicking view pdf on purchase agreements). When a change order is done, the pdf is updated in oracle, so now the new file becomes, xx_00012_1.pdf, because a change order was done.

But when I try to find it in the UCM and in the table: fnd_documents_vl, the new change order does not exist.

EXCEPT, sometimes I do see the new change order files, but I don't always see them.

Am I missing something?