Queues during MRP job run

[Former Member]

Hello All,

We daily observe heavy queues when MRP job runs which flow across to SCM system on daily basis. Let me explain you the scenario in brief: -

1. We calculate Final Forecast in Demand planning (APO) & send to ECC as PIR to inactive version. Then we have a standard job which copies those PIR from inactive to active version.

2. Then MRP runs on Distribution Centre & Local Warehouses levels

3. Followed by Deployment & TLB in APO.

4. FYI, we have active integration models for PIR, planned order, PO & PReqs,  Prod. Orders & Sales Order.

So we observe queues in system when PIRs are copied to active version ((step #1) & during MRP jobs runs (step #2). Its fine to have queues in system, but the number of queues varies from day to day. What could be the reason every day the number of queue count differ ?

If the number of queues is more, it takes lot more time to process which impacts Deployment & PO job & also the system performance when they last until business hours.

Please help.

Regards

Rahul Chitte

[satish_waghmare3 · Accepted solution]

Hello Rahul,

It is a good practice to monitor CIF Queue Manager /SAPAPO/CQ during heavy processing.

Housekeeping keeps CIF running smoothly. It is good practice to delete application logs in ECC and APO. The system does not delete the logs automatically.
Recommendation is to delete logs periodically by background job scheduling to prevent overflow of database which hampers data transfer via CIF
Transaction Code in ECC : CFGD    Report : RDELALOG
Transaction Code in APO : /SAPAPO/C6    Report : /SAPAPO/RDELLOG

Also please check with your BASIS team regarding the dialog work processes for the tRFC/qRFC.

Also check the MAXTIME/NRETRY/TDELAY parameters for the RFC destination.

One suggestion you can run this RSWAITSEC program to allow system to process all the CIF queues, before triggering your Deployment & PO jobs. This program will help create a time window if you are running the job in using automated batch schedule with inter-dependecies.

Hope this will help.

Thank you
Satish Waghmare

[satish_waghmare3 · Accepted solution]

Hey Rahul,

I forgot to mentioned about Deleting Change pointers using report RBDCPCLR.  If changes to master data are transferred periodically via ALE(Option 2), processed change pointers must be deleted regularly. Also completing this if your database system on ECC side is Oracle, then run report RBDCPIDXRE to reorganize the oracle indexes on tables BDCP and BDCPS.

And if post-processing is active, then clearing the obsolete/expired post-processing logs using /SAPAPO/CIF_POSTPROC_REORG.

All these Housekeeping things certainly helps in improving performance of CIF data transfer.

Hope this will help.

Thank you

Satish Waghmare