1 Reply Latest reply: Jan 28, 2013 1:06 PM by 987590 RSS

    Receiving Transactions interface

    rahul kataria
      Some records are there in rcv_headers_interface & rcv_transactions_interface whose processing_status_code is in error or pending but still we are able to see that records are successfully processed to base tables i.e rcv_shipment_headers, rcv_shipment_lines and rcv_transactions.

      Kindly let me know how can we trace the error records which are not processed to rcv_shipment_headers, rcv_shipment_lines and rcv_transactions.
        • 1. Re: Receiving Transactions interface
          987590
          the below script shows all the shipment lines along with shipment_header_id that are either 'EXPECTED' or 'PARTIALLY RECEIVED' these would not have made it to the rcv_transactions table.

          find these shipment lines in the interface and try to process them.

          SELECT * FROM po.rcv_shipment_lines rsl
          WHERE rsl.SHIPMENT_LINE_STATUS_CODE != ''FULLY RECEIVED'



          if you have errored records in the rcv_transactions_interface and rcv_headers_interface that are not received.
          use the below script to find

          SELECT rti.SHIPMENT_LINE_ID FROM po.rcv_transactions_interface rti
          MINUS
          SELECT rt.shipment_line_id FROM
          po.rcv_transactions rt,
          po.rcv_transactions_interface rti
          WHERE rt.SHIPMENT_LINE_ID(+) = rti.SHIPMENT_LINE_ID

          To check errors

          select * from po.po_interface_errors pie
          where pie.INTERFACE_LINE_ID = 24126926 (this is interface_transaction_id from receiving_transactions_interface for the errored record or you can use batch_id/group_id which the Receiving_transaction_processor program errors out with)