4 Replies Latest reply on Jan 7, 2015 7:27 AM by 2699043

    rcv_header_interface have processing status code ERROR

    2699043

      Hi,

       

      I'm trying to do a receiving for a complex PO but there is a error record in RCV_HEADER_INTERFACE table.

      I've checked the error through PO_INTERFACE_ERRORS tables, and it says the "group_id specified was not the group id that was expected"

       

      Any advise and idea on this pls?

       

      Really appreciate for your help, as this is an urgent issue.

       

      Thank you so much!

        • 1. Re: rcv_header_interface have processing status code ERROR
          Sanjay Desai EBS

          Hi,

           

          Try in the following way.

           

          Populate the column : GROUP_ID with RCV_INTERFACE_GROUPS_S.NEXTVAL in interface table : RCV_HEADERS_INTERFACE

          Populate the column : GROUP_ID with RCV_INTERFACE_GROUPS_S.CURRVAL in interface table : RCV_TRANSACTIONS_INTERFACE

           

           

          Store the value of sequence : RCV_INTERFACE_GROUPS_S into variable : V_GROUP_ID using :

           

           

          SELECT rcv_interface_groups_s.CURRVAL   INTO V_GROUP_ID FROM DUAL; 

           

           

          when you run the concurrent Prorgram : Receiving Transaction Processor , pass the parameter : Group Id (V_group_id) in the following way.

           

          v_request_id := FND_REQUEST.SUBMIT_REQUEST

                                 (

                                    application  => 'PO',

                                    program      => 'RVCTP',

                                    description  => 'RECEIVING TRANSACTION PROCESSOR FOR BAR CODE SYSTEM',

                                    start_time   =>  SYSDATE,

                                    sub_request  =>  FALSE,

                                    argument1    => 'BATCH',

                                    argument2    =>  v_group_id

                                 );

               COMMIT; 

           

          HTH

          • 2. Re: rcv_header_interface have processing status code ERROR
            2699043

            Hi,

             

            Thank you for your reply.

             

            By the way, I've did the following and run the Receiving Transaction Processor. Status remain "Error"

             

            Or pls advise if I have to do something else?

             

            Thank you

            • 3. Re: rcv_header_interface have processing status code ERROR
              PranitSaha

              You may find the error message in the PO_INTERFACE_ERRORS table to understand the root cause better.

               

              Sent from my iPhone

              • 4. Re: rcv_header_interface have processing status code ERROR
                2699043

                Hi,

                 

                I don't know why the error message in PO_INTERFACE_ERRORS is still the same as before

                 

                Error: The GROUP_ID specified is invalid.  The value specified (1525575) does not match the expected value (1525572).