1 Reply Latest reply on Jun 14, 2016 10:59 PM by anasazii

    PO Line Locations Interface

    3161434

      Hi Guys,

       

      Could you please help me to understand the PO Line Location Interface details.

       

      When is the Table PO_LINE_LOCATIONS_INTERFACE Table Populated.Is it used in PDOI.

      We have seen the PO_LINE_LOCATIONS_ALL Table populated with the Shipment Records even when we did not put any data in PO_LINE_LOCATIONS_INTERFACE Table.Are these records coming from PO_LINES_INTERFACE.When is it required to populate the PO_LINE_LOCATION_INTERFACE Table.

       

      The Column - LINE_LOC_POPULATED_FLAG present in PO_LINES_ALL.What is the significance of this.Why this NULL sometimes and Not NULL sometimes.

       

      Thanks,

      Akash

        • 1. Re: PO Line Locations Interface
          anasazii

          It looks like you can do either depending on how many shipments you want to create.  1 shipment - just populate PLI...if you need multiple shipments created, then you need to specify that information in PLLI and set the line_loc_populated_flag to 'Y'

           

          if you had the case where you wanted more than 1 shipment created for the line, then you would use the PLLI table (ex d)...all the other examples are just inserting into PLI (a,b,c,e).

          Vision Demo - How To Import Standard Purchase Orders Using the Purchase Document Open Interface PDOI - Pre PDOI Enhancements (Doc ID 1054004.1)

           

           

          This note may help too since it specifically mentions the flag...Set to Y when you are specifically populating PLLI else N.

          Vision Demo - How To Import Standard Purchase Orders Using the Purchase Document Open Interface PDOI (12.2 and 12.1.3 Enhanced PDOI) (Doc ID 2014101.1)

          After section a - Also note that the PO_LINES_INTERACE.LINE_LOC_POPULATED_FLAG is set to N - as PO_LINE_LOCATIONS_INTERFACE is not being populated.


          Hope that helps!

          Janel