BIP PO rtf Template archive query

Summary

Displaying the Line Level Notes to Supplier in the PO Template in BIP

Content

Hi,

I have a requirement to display "Notes to Supplier" field on to PO rtf Template at the line level. The PDFARCHIVEPURCHASEORDERLINE query is having a field "Line.NOTE_TO_VENDOR AS NoteToVendor," in the query.

when I am running the Data Model query I only see the outputs from the Draft queries. The Archive queries don't execute. Is there any background process in the Fusion application to be run to display the Archive queries output or should the PO be Approved to get the Archive queries executed.