2 Replies Latest reply: Apr 30, 2013 12:49 PM by user149617 RSS

    PO_DOCUMENT_FUNDS_PVT.do_unreserve API Error in R12

    user149617
      Hi All,

      I am trying to use the PO_DOCUMENT_FUNDS_PVT.do_unreserve API to unreserve the existing 'Blanket Purchase agreement' in R12 and it error
      out and doesn't go through. The same API call works fine for 'Standard PO' without any issue. This same API call is used in our current Release 11i
      and it works fine, does anyone have any idea how to make this work in R12 for existing 'Blanket Purchase Agreement'? Any help is greatly appreciated.


      Thanks,
      SS
        • 1. Re: PO_DOCUMENT_FUNDS_PVT.do_unreserve API Error in R12
          Hussein Sawwan-Oracle
          user8866074 wrote:
          Hi All,

          I am trying to use the PO_DOCUMENT_FUNDS_PVT.do_unreserve API to unreserve the existing 'Blanket Purchase agreement' in R12 and it error
          out and doesn't go through. The same API call works fine for 'Standard PO' without any issue. This same API call is used in our current Release 11i
          and it works fine, does anyone have any idea how to make this work in R12 for existing 'Blanket Purchase Agreement'? Any help is greatly appreciated.


          Thanks,
          SS
          What is the error?

          https://blogs.oracle.com/stevenChan/entry/ebs_data_model_1213
          https://blogs.oracle.com/stevenChan/entry/ebs_seed_data_comparison_reports
          http://etrm.oracle.com

          Thanks,
          Hussein
          • 2. Re: PO_DOCUMENT_FUNDS_PVT.do_unreserve API Error in R12
            user149617
            Hi Hussien,
            Sorry for the delayed response, I was on vacation. Thanks for the links that you have provided. when I try to call the API it just returns with 'FATAL'
            error and when I check in the table 'po_online_report_text' based on online_report_id value returned by API call, it shows the following text

            Text_Line from above table when Unreserve failed on 04/29/2013
            --------------------------------------------------------------
            GL BC Packets are empty. Event 38090918 is not processed.
            The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines.
            GL BC Packets are empty. Event 38090918 is not processed.
            The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines.

            I don't see any event in XLA_AE_HEADERS table or GL_BC_PACKETS table with the event_id 38090918 as given in the error text. Any help would
            be greatly appreciated. Is there any other API that we can use to do 'Reserve'/'Unreserve' from back-end in R12 Encumbrance Accounting environment?


            Thanks,
            SS