Procurement - EBS (MOSC)

MOSC Banner

How to import Blanket Purchase Agreement distribution line in R12.2.6

edited Jul 11, 2019 5:07AM in Procurement - EBS (MOSC) 3 commentsAnswered

Hi,

Do any one have idea regarding importing of distribution line for Blanket Purchase agreement. We are using R12.2.6 where we can book encumbrance for BPA through encumbrance tab available in the front end. But we have business requirement of creating BPA through back end . While creating BPA through interface table, only header and line tables are getting populated not the distribution table.

Quick response will be highly appreciated.

Attaching the code:

------------------Header----------------------

Insert into PO.PO_HEADERS_INTERFACE

    (INTERFACE_HEADER_ID,

     BATCH_ID,

     PROCESS_CODE,

     ACTION, 

     ORG_ID,

     DOCUMENT_TYPE_CODE, 

     CURRENCY_CODE,

     AMOUNT_AGREED,

     AGENT_ID, 

     VENDOR_ID,

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