3 Replies Latest reply on Oct 25, 2012 3:29 AM by Sanjay Desai EBS

    R12 - How to import contract and planned PO's ?

    Prabhu Thangavel
      Hi,

      I am using Purchasing Document Open Interface for importing Standard and Blanket PO's. Can you please suggest how to import contract and planned PO's ? I need to migrate the PO's from 11i to R12. Please suggest.

      Regards,
      Prabhu
        • 1. Re: R12 - How to import contract and planned PO's ?
          630565
          Hi Prabhu,

          you cannot use PDOI for CPA.. Try using the below API.. pls populate the correct values in the interface tables... important thing is action ="NEW" and interface_source_code = "SOURCING" in the po_headers_interface for this API to pickup...

          PO_SOURCING_GRP.CREATE_CPA(
          p_api_version => 1.0,
          p_init_msg_list => FND_API.G_TRUE,
          p_commit => FND_API.G_FALSE,
          p_validation_level => FND_API.G_VALID_LEVEL_FULL,
          x_msg_count => x_msg_count,
          x_msg_data => x_msg_data,
          x_return_status => x_return_status,
          p_interface_header_id => x_interface_header_id,
          p_auction_header_id => p_auction_header_id ,
          p_bid_number => x_bid_number ,
          p_sourcing_k_doc_type => x_contract_doc_name,
          p_conterms_exist_flag => x_conterms_exist_flag,
          p_document_creation_method => 'AWARD_SOURCING',
          x_document_id => x_po_header_id,
          x_document_number => x_order_number
          );


          Regards,
          Praveen
          • 2. Re: R12 - How to import contract and planned PO's ?
            Prabhu Thangavel
            Hi Praveen,

            Thanks for your prompt response. Only po_headers_interface table right ?

            Regards,
            Prabhu
            • 3. Re: R12 - How to import contract and planned PO's ?
              Sanjay Desai EBS
              Hi Prabhu,

              Visit following link . May be useful to you.

              https://forums.oracle.com/forums/search.jspa?threadID=&q=How+to+import+planned+contract+PO&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

              regards
              sanjay

              Edited by: Sanjay Desai on Oct 25, 2012 8:59 AM