1 Reply Latest reply on Dec 22, 2009 9:15 PM by Srini Chavali-Oracle

    Urgent Please - Receiving Transaction Processor

    user9935659
      Hi,
      We are on 11.5.10. I am trying to create PO receipts using the interface program "Receiving Transaction Processor". I inserted data into the rcv_headers_interface and rcv_transactions_interface tables. As this dta is for contract labor, i am assuming that there is no need to insert data into shipment_related interface table. Following shows the insert statement I made sure that I am running the process from the correct org (the org that i used in the filed destination_oprganization field). But still the process completes normally but po_interface_errors has a record with error message as :

      "RVTSH-189: Subroutine rvtshiline() returned error

      Cause: Subroutine rvtshiline() returned an internal error.

      Action: Note this error number and the actions you are trying to perform.
      Contact your system administrator for"

      The receipt gets created succesfully from the form. Anyone knows the issue? Please help me...thanks

      Here are the insert statements...


      --Insert data into Interface tables
      INSERT INTO rcv_headers_interface
      (header_interface_id,
      GROUP_ID,
      processing_status_code,
      receipt_source_code,
      transaction_type,
      auto_transact_code,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      expected_receipt_date,
      comments,
      validation_flag,
      packing_slip,
      vendor_id,
      vendor_site_id,
      ship_to_organization_id
      )
      VALUES (rcv_headers_interface_s.NEXTVAL,
      rcv_interface_groups_s.NEXTVAL,
      'PENDING',
      'VENDOR',
      'NEW',
      'RECEIVE',
      SYSDATE,
      fnd_global.user_id,
      SYSDATE,
      fnd_global.user_id,
      SYSDATE,
      'test',
      'Y',
      'ABC',
      po_headers.vendor_id,
      po_headers.vendor_site_id
      po_distributions.destination_organization_id
      );

      --Insert record in transactions_interface
      INSERT INTO rcv_transactions_interface
      (interface_transaction_id,
      header_interface_id,
      processing_status_code,
      receipt_source_code,
      transaction_date,
      GROUP_ID,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      transaction_type,
      processing_mode_code,
      transaction_status_code,
      quantity,
      unit_of_measure,
      source_document_code,
      po_header_id,
      po_line_id,
      po_line_location_id,
      po_distribution_id,
      to_organization_id,
      comments,
      interface_source_code,
      employee_id,
      auto_transact_code,
      destination_type_code,
      attribute_category,
      category_id,
      item_description
      )
      VALUES (rcv_transactions_interface_s.NEXTVAL,
      rcv_headers_interface_s.CURRVAL,
      'PENDING',
      'VENDOR',
      SYSDATE,
      rcv_interface_groups_s.CURRVAL,
      SYSDATE,
      fnd_global.user_id,
      SYSDATE,
      fnd_global.user_id,
      'RECEIVE', --'NEW',
      'BATCH',
      'PENDING',
      2,
      po_lines.unit_meas_lookup_code,
      'PO',
      po_headers..po_header_id,
      po_lines.po_line_id,
      po_line_locations.po_line_location_id,
      po_distributions.po_distribution_id,
      po_distributions.destination_organization_id,
      'TEST',
      'RCV',
      1234, --employee_id
      'RECEIVE',
      'RECEIVING',
      po_distributions.destination_organization_id,
      45074,
      'Standard'
      );