1 Reply Latest reply on Jul 3, 2017 7:34 PM by Vanha.L-Oracle

    unable to Finally close the  PO line

    2987029

      Hi,

       

      There is BPA and all the release against that BPA are closed, this was checked in Releases form. When i try close the PO line, getting an error as "You cannot finally close this  line because open releases exists"

       

      please let me know what other things i can check or if there is any query which gives releases against BPA.

       

      Appreciate your valuable inputs on this issue.

       

      Thanks

      V

        • 1. Re: unable to Finally close the  PO line
          Vanha.L-Oracle

          This error is good.

          You need to make sure all the releases' shipments are either cancelled or finally closed. Use following query. If rows return, process to final those release shipments.

           

          SELECT 'Uncancelled Open Releases Exist'

          FROM po_line_locations_all pll

          WHERE pll.po_line_id = &blanket_line_id

            AND pll.shipment_type = 'BLANKET'

            AND NVL(pll.cancel_flag, 'N') = 'N'

            AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED';

           

          Hope this helps.

          Vanha