Skip to Content
avatar image
Former Member

Deletion of APO Inbound and Outbound queues

Hi All,

We want to delete the APO Inbound queue and Outbound queues on weekly basis in Background , so that the job can be scheduled.

I know that there are 2 programs for this purpose :

RSTRFCIDS-delete inbound queues


RSTRFCQDS-delete outbound queues

But the issue with these programs, they are not taking GENERIC QUEUES ( Like we can't give * or C* in Queue name ). We hae many queues and its not possible to give all the queue names and scheule thousands of background jobs . ( One job for each queue name ) . So , is there any other solution where the program do accept generic queue names ?

Thanks a lot for your support !!!

Regards,

Venkata Emani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 03, 2014 at 06:28 PM

    Hi Venkata

    As suggested by other experts, deletion of queue is not advisable. If you are getting too many failed entries, then whole CIF design should be re-looked. Please also make sure that you have implemented housekeeping activities e.g. Delta report followed by manual correction of delta, CIF Monitoring and CIF postprocessing. A combination of these activities should minimize failed entries. Saving a queue is a better option than deletion so that you can analyze it later. If you still want to delete, probably its better to do it after reviewing the entries and using TCode SMQ1 or SMQ2.

    Thanks,

    Prasun

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Venkata

      You have reported that you are using only Demand Planning. So what are Master and Transaction data are you using for CIF? Are you trying to transfer forecast from APO DP to ECC as PIR?

      I belive your question on display of queue and queue failure is already answered by other experts. Delta report or postprocessing would help to reconcile data. However, if there is large number of errors, root cause might be inaccurate configuration or wrong Master data set-up. With only Demand Planning, I would not expect too many issues in CIF (I am assuming you are transferring very few transactional data).

      Thanks,

      Prasun

  • Feb 03, 2014 at 03:01 PM

    Hi Venkata,

    In a well-designed ERP/APO system, every queue is important and should be processed. Deletion of queues leads to system inconsistencies. I'm curious as to why you are deleting queues.

    Best regards,

    Mike

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2014 at 11:08 AM

    Hi Emani,

    By entering TID = *, all LUWs are deleted in all queues, and the entry under 'Delete queue' is no longer taken into account.

    Now delete the inconsistent TID directly from the delta queue SMQ1. Also see note 760113 and 763255 for the deletion.

    Queue name - This parameter is mandatory for performance reasons. The queue name designates the queue, in which the LUW to be deleted is located, which must be fully specified.

    Note: If a LUW is located in several queues, the specification of a single queue is sufficient, and the LUW is then also deleted from all of the other queues.

    Regards,

    R.Brahmankar

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2014 at 03:32 PM

    Hello Venkata

    Data Consistency is the ultimate aim of CIF.  As mentioned by other experts,  Deletion of queues leads to data inconsistencies.

    If there are in any unwanted queues getting created, then you should rather validate the integration models which is trying to transfer this unwanted data to APO. This should reduce number of such queues to some manageable number.

    For your requirement I think Tcode. /SAPAPO/CQ - SCM Queue Manager is more appropriate, where you can verify the Error Text and then based on that multiple queues can be deleted with a single click. Yes, this is requires a manual action.(not possible to do it bkgrd).

    Please let us know, reason for your requirement - why you are deleting CIF queues in such a high number.

    Thank you

    Satish Waghmare

    Add comment
    10|10000 characters needed characters exceeded