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?