0 Replies Latest reply on Jul 10, 2014 6:49 AM by 1493880

    Urgent: Requirement to update receipt_routing_id on po_line_locations on existing Standard PO from back end.

    1493880

      Hello All,

       

      I have a requirement to update receipt_routing_id on po_line_locations (Inspection Required) from back end on existing Standard PO (R12).

       

      I searched for any public API to do so, but I did not  get any information. I am avoiding direct update on base table as it is not recommended by Oracle.

       

      Can we update this via PO interface table. If yes then how many interface tables needs to be populated and what would be the value for column 'ACTION' in each table below?

       

      po_headers_interface

      po_lines_interface

      po_line_locations_interface

      po_distributions_interface


      Any help on the same will be highly appreciated...

       

      Thanks in advance...