Procurement - EBS (MOSC)

MOSC Banner

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,

1. created the attachment in the application.

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center