note1_id in PO_REQUISITIONS_INTERFACE_ALL table
As we know,
Attachments can't be directly imported through requisition import. So we have done the following,
2. Noted down the document_id. Fetched Document_id from FND_DOCUMENTS table.
3. Populate the note_id column of requisition interface table with the
document_id noted from the previous step
4.Run the Requisition Import
But the sequence of requisition attachment are not proper.While creating document first,we are inserting line into FND_DOCUMENTS table .
How to control sequence in this case?Do we have to insert line into FND_ATTACHED_DOCUMENTS table also?What will be the Requisition Line ID (PK1) in this case?