10 Replies Latest reply on Nov 22, 2010 1:14 PM by Sandeep Gandhi, Consultant

    RVCTP module: Receiving Transaction Processor

    user11984177
      Hi,

      I am doing receipt using by passing ASN no as input parameter, not picking the records from interface tables.

      when i checked in rcv_transactions_interface table proceeing_status_code is "RUNNING" , "PENDING" .

      when i run the Receiving Transaction Processor got below error.

      i changed profile option as "BATCH", still getting same error

      please help to solve this




      Purchasing: Version : 11.5.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      RVCTP module: Receiving Transaction Processor
      ---------------------------------------------------------------------------

      Current system time is 16-NOV-2010 13:05:39

      ---------------------------------------------------------------------------

      Concurrent program RVCTP returned error

      Cause: RVCTP encountered an internal error. Parameters: RVCTP,BATCH,122227,

      Action: Note both this error number and the actions you are trying to perform. Contact your system admini
      RVTBM-007: Subroutine rvtbm_batch_mngr() returned error

      Cause: Subroutine rvtbm_batch_mngr() returned an internal error.

      Action: Note this error number and the actions you are trying to perform. Contact your system admini
      RVTBM-080: Subroutine rvtptcontrol() returned error

      Cause: Subroutine rvtptcontrol() returned an internal error.

      Action: Note this error number and the actions you are trying to perform. Contact your system administrator
      RVTLO-005: ORA-01403: no data found


      Cause: A SQL error has occurred in RVTLO. The SQL error is &LSQL_ERR.

      Action: Take note of both this error number and the actions you were t
      Concurrent Manager encountered an error while attempting to start your immediate concurrent program RVCTP. Routine &ROUTINE received a return code of failure.

      Contact your support representative.

      ---------------------------------------------------------------------------
      Current system time is 16-NOV-2010 13:05:40

      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...
        • 1. Re: RVCTP module: Receiving Transaction Processor
          user11984177
          please help to solve this issue.
          • 2. Re: RVCTP module: Receiving Transaction Processor
            Sandeep Gandhi, Consultant
            Try to bounce the receiving txn processor. In rare cases, bouncing the d/b also helps.
            • 3. Re: RVCTP module: Receiving Transaction Processor
              599546
              Hi,

              Thank you very much your reply,

              now i am getting below error which is showing in po_interface_errors table.

              Invalid shipment header identifier specified for ASN receive

              Cause: For an ASN receive the required shipment header id was not specified (SHIPMENT NUMBER=)

              Action: Provide a valid shipment header id


              can you plz help to solve this.
              • 4. Re: RVCTP module: Receiving Transaction Processor
                Sandeep Gandhi, Consultant
                Check if you have entered the ASN information for the receipt being performed.
                Sandeep Gandhi
                • 5. Re: RVCTP module: Receiving Transaction Processor
                  599546
                  Hi Sandeep,

                  thanks for your reply,

                  i am inserting the records using below script.

                  INSERT INTO RCV_HEADERS_INTERFACE
                  (
                  HEADER_INTERFACE_ID
                            ,GROUP_ID
                            ,PROCESSING_STATUS_CODE
                            ,RECEIPT_SOURCE_CODE
                  ,TRANSACTION_TYPE
                  -- ,RECEIPT_HEADER_ID
                            ,LAST_UPDATE_DATE
                            ,LAST_UPDATED_BY
                            ,LAST_UPDATE_LOGIN
                            ,CREATION_DATE
                            ,CREATED_BY
                            ,VENDOR_ID
                  ,VENDOR_SITE_ID
                            ,VALIDATION_FLAG
                            ,ATTRIBUTE12
                            -- ,SHIPMENT_NUM
                            ,EMPLOYEE_ID
                            ,BILL_OF_LADING
                            ,PACKING_SLIP
                            ,NUM_OF_CONTAINERS
                            ,GROSS_WEIGHT
                            ,GROSS_WEIGHT_UOM_CODE
                            ,WAYBILL_AIRBILL_NUM
                            ,COMMENTS
                            ,FREIGHT_TERMS
                            ,INVOICE_NUM
                            ,INVOICE_DATE
                            ,ATTRIBUTE1
                            ,ATTRIBUTE2
                            ,ATTRIBUTE3
                            ,ATTRIBUTE4
                            ,ATTRIBUTE6
                            ,ATTRIBUTE7
                            ,ATTRIBUTE8
                            ,ATTRIBUTE9
                            ,ATTRIBUTE10
                            ,ATTRIBUTE11
                  ,SHIPPED_DATE
                  ,EXPECTED_RECEIPT_DATE
                  -- ,RECEIPT_NUM
                  )
                       VALUES(l_header_interface_id
                       ,l_group_id
                            ,'BATCH' --'PENDING'
                            ,'VENDOR'
                            ,'NEW' --'RECEIVE'
                  -- ,H.SHIPMENT_HEADER_ID
                            ,sysdate
                            ,l_user_id
                            ,l_login_id
                  ,H.CREATION_DATE
                  ,H.CREATED_BY
                            ,H.VENDOR_ID
                  ,H.VENDOR_SITE_ID
                            ,'Y'
                            ,H.ATTRIBUTE12
                            -- ,l_sil_number
                            ,H.EMPLOYEE_ID
                            ,H.BILL_OF_LADING
                            ,H.PACKING_SLIP
                            ,H.NUM_OF_CONTAINERS
                            ,H.GROSS_WEIGHT
                            ,H.GROSS_WEIGHT_UOM_CODE
                            ,H.WAYBILL_AIRBILL_NUM
                            ,H.COMMENTS
                            ,H.FREIGHT_TERMS
                            ,H.INVOICE_NUM
                            ,H.INVOICE_DATE
                            ,H.ATTRIBUTE1
                            ,H.ATTRIBUTE2
                            ,H.ATTRIBUTE3
                            ,H.ATTRIBUTE4
                            ,H.ATTRIBUTE6
                            ,H.ATTRIBUTE7
                            ,H.ATTRIBUTE8
                            ,H.ATTRIBUTE9
                            ,H.ATTRIBUTE10
                            ,H.ATTRIBUTE11
                  ,H.SHIPPED_DATE
                  ,sysdate
                  -- ,11111111
                  );


                  INSERT INTO RCV_TRANSACTIONS_INTERFACE
                  (
                  INTERFACE_TRANSACTION_ID
                  ,GROUP_ID
                  ,LAST_UPDATE_DATE
                  ,LAST_UPDATED_BY
                  ,CREATION_DATE
                  ,CREATED_BY
                  ,LAST_UPDATE_LOGIN
                  ,TRANSACTION_TYPE
                  ,TRANSACTION_DATE
                  ,PROCESSING_STATUS_CODE
                  ,PROCESSING_MODE_CODE
                  ,TRANSACTION_STATUS_CODE
                  ,QUANTITY
                  ,UNIT_OF_MEASURE
                  ,ITEM_ID
                  ,UOM_CODE
                  ,INTERFACE_SOURCE_CODE
                  ,SHIPMENT_HEADER_ID
                  -- ,SHIPMENT_LINE_ID
                  --,USER_ENTERED_FLAG
                  ,SOURCE_DOCUMENT_CODE
                  ,DESTINATION_TYPE_CODE
                  ,PRIMARY_QUANTITY
                  ,PRIMARY_UNIT_OF_MEASURE
                  ,RECEIPT_SOURCE_CODE
                  ,EMPLOYEE_ID
                  ,PARENT_TRANSACTION_ID
                  ,PO_HEADER_ID
                  ,PO_RELEASE_ID
                  ,PO_LINE_ID
                  ,PO_LINE_LOCATION_ID
                  ,PO_DISTRIBUTION_ID
                  --,PO_REVISION_NUM
                  ,PO_UNIT_PRICE
                  ,CURRENCY_CODE
                  ,CURRENCY_CONVERSION_TYPE
                  ,CURRENCY_CONVERSION_RATE
                  ,CURRENCY_CONVERSION_DATE
                  ,VENDOR_ID
                  ,VENDOR_SITE_ID
                  ,TO_ORGANIZATION_ID
                  ,LOCATOR_ID
                  ,SHIP_TO_LOCATION_CODE
                  -- ,AUTO_TRANSACT_CODE
                  ,VALIDATION_FLAG
                  )
                  VALUES
                  (
                  l_transaction_id
                  ,l_group_id
                  ,sysdate
                  ,l_user_id
                  ,sysdate
                  ,l_user_id
                  ,l_login_id
                  ,'RECEIVE'
                  ,sysdate
                  ,'PENDING'
                  ,'BATCH'
                  ,'PENDING'
                  ,r.QUANTITY_SHIPPED
                  ,r.UNIT_OF_MEASURE
                  ,r.ITEM_ID
                  ,l_uom_code--UOM_CODE
                  ,'RCV'
                  ,l_header_interface_id --r.SHIPMENT_HEADER_ID            
                  -- ,r.SHIPMENT_LINE_ID
                  -- ,'Y' --USER_ENTERED_FLAG  
                  ,'PO' --SOURCE_DOCUMENT_CODE  
                  ,'RECEIVING' -- DESTINATION_TYPE_CODE
                  ,r.QUANTITY_SHIPPED --PRIMARY_QUANTITY              
                  ,r.PRIMARY_UNIT_OF_MEASURE --PRIMARY_UNIT_OF_MEASURE   
                  ,'VENDOR' -- RECEIPT_SOURCE_CODE -
                  ,r.EMPLOYEE_ID --EMPLOYEE_ID                         
                  ,-1 --PARENT_TRANSACTION_ID    -   
                  ,r.PO_HEADER_ID
                  ,r.PO_RELEASE_ID
                  ,r.PO_LINE_ID
                  ,r.PO_LINE_LOCATION_ID
                  ,r.PO_DISTRIBUTION_ID
                  --,r.PO_REVISION_NUM
                  ,r.UNIT_PRICE --PO_UNIT_PRICE
                  ,r.CURRENCY_CODE
                  ,r.RATE_TYPE -- CURRENCY_CONVERSION_TYPE -
                  ,r.RATE -- CURRENCY_CONVERSION_RATE
                  ,r.RATE_DATE -- CURRENCY_CONVERSION_DATE
                  ,r.VENDOR_ID
                  ,r.VENDOR_SITE_ID
                  ,r.TO_ORGANIZATION_ID --ORGANIZATION_ID
                  ,41
                  ,'GNE JEBEL ALI'
                  -- ,'DELIVER'
                  ,'Y'
                  );


                  can you plz suggest if i am wrong
                  • 6. Re: RVCTP module: Receiving Transaction Processor
                    599546
                    plz give me suggestions to solve the issue, please.
                    • 7. Re: RVCTP module: Receiving Transaction Processor
                      Sandeep Gandhi, Consultant
                      Check out the Receiving Open Interface Manual and the following addtional source of info on Metalink:

                      [559956.1|https://metalink.oracle.com/CSP/main/article?cmd=show&type=NOT&id=559956.1] Receiving Open Interface: Description of Features and Sample Scripts

                      [564723.1|https://metalink.oracle.com/CSP/main/article?cmd=show&type=NOT&id=564723.1] How To Diagnose An Issue in ROI Receiving Open Interface in 11.5.10 / R12

                      Also do not populate uom code. Sometimes that could cause problems.
                      • 8. Re: RVCTP module: Receiving Transaction Processor
                        Sandeep Gandhi, Consultant
                        Chk if this works (From http://itjaj.com/thread-859-1-1.html)

                        INSERT INTO RCV_HEADERS_INTERFACE
                        b ( HEADER_INTERFACE_ID , GROUP_ID , PROCESSING_STATUS_CODE , RECEIPT_SOURCE_CODE , TRANSACTION_TYPE , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATION_DATE , CREATED_BY , SHIPPED_DATE , VENDOR_NAME , EMPLOYEE_NAME , VALIDATION_FLAG , SHIP_TO_ORGANIZATION_CODE , EXPECTED_RECEIPT_DATE, AUTO_TRANSACT_CODE)
                        SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL, RCV_INTERFACE_GROUPS_S.NEXTVAL, 'PENDING', 'VENDOR', 'NEW', sysdate, 1, 1, sysdate, 1007881, sysdate, 'Advanced Network Devices', 'jones, karen d', 'Y', 'M1', --ship-to org code sysdate, 'RECEIVE' FROM DUAL;

                        INSERT INTO RCV_TRANSACTIONS_INTERFACE (INTERFACE_TRANSACTION_ID , HEADER_INTERFACE_ID , GROUP_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , TRANSACTION_TYPE , TRANSACTION_DATE , PROCESSING_STATUS_CODE , PROCESSING_MODE_CODE , TRANSACTION_STATUS_CODE , QUANTITY, UNIT_OF_MEASURE , AUTO_TRANSACT_CODE , RECEIPT_SOURCE_CODE , SOURCE_DOCUMENT_CODE , DOCUMENT_NUM , SHIP_TO_LOCATION_CODE , VALIDATION_FLAG , TO_ORGANIZATION_CODE , ITEM_NUM ,shipment_header_id ,shipment_line_id ) SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL, RCV_HEADERS_INTERFACE_S.CURRVAL, RCV_INTERFACE_GROUPS_S.CURRVAL, SYSDATE, 1, SYSDATE, 1007881, 1, 'RECEIVE', sysdate, 'PENDING', 'BATCH', 'PENDING', 54, Quantity 'Each', 'RECEIVE', 'VENDOR', 'PO', '12795', PO Number 'M1- Seattle', -- 'ship to location', 'Y', 'M1', 'CM13139' ,924686 ASN shipment_header_id ,614673 ASN shipment_line_id FROM DUAL;
                        • 9. Re: RVCTP module: Receiving Transaction Processor
                          599546
                          Hi Sandeep,


                          i inserted the mentined data, still i am getting same error.

                          Invalid shipment header identifier specified for ASN receive

                          Cause: For an ASN receive the required shipment header id was not specified (SHIPMENT NUMBER=37789.3)

                          Action: Provide a valid shipment header id


                          can you plz suggest.
                          • 10. Re: RVCTP module: Receiving Transaction Processor
                            Sandeep Gandhi, Consultant
                            Make sure the ASN you entered is valid. If it still does not work, you may have to raise an SR.