Need steps/document in order to download attachments for purchase orders from UCM
Summary:
1)
We have a requirement to download all PO's for 1 particular BU for 4 years (2019 to 2023)
We found a document (km note listed below)which provides the steps and sql queries for invoices attachments download.
Is there something similar for PO's ?
KM NOTE:
How to download payables invoice attachments from UCM using getDocumentForDocumentId method from ERP Integration Service webservice (Doc ID 2550855.1)
2)
Are all PO documents ONLY stored in the table: fnd_documents_tl.dm_version_number
OR are there any other tables where PO PDF attachments are stored when a PO is created in Oracle ?
How do we get the attachment document ID's of all PO's created in the Oracle system?