Macro run in background does not save results

[nitin_thatte]

Hi Experts,

I have scheduled the standard SNP Macro Stock Below Safety Stock (DB Alert) in background. However it returns the spool list with the message

"No data has been changed; data must not be saved"

The same macro when run through planning book works fine and generates the alerts properly.

Please Help.

Thanks in advance.

Nitin Thatte

[former_member187488 · Accepted solution]

Hi,

I suppose this may because the standard macros (start, default) are not executed before the alert macro in your background job. Please notice that the standard macros are not executed automatically in the background. You'll need to schedule those macros before the alert macro.

Best Regards,

Ada

[nitin_thatte · Accepted solution]

Thanks Ada,

Do you mean to say that all default and level change macros have also to be scheduled in the background prior to Alert Macros?

Nitin

[former_member187488 · Accepted solution]

Hi Nitin,

Since the stock relevant macros are in the default group, you must schedule these macros before alert macro in background job. And since the stock relevnat macros based on the workday calculation macro which is in the start group, you'll also need to schedule this macro.

So if you're using standard SNP planning book, basicly you need to schedult the following macros by sequence:

1)Determine workdays

2)Stock balance

3)Safety Stk/Reorder Point/Targt Stock Lvl

4)The Alert macro

You can also create a collective macro for these macros and then schedule the collective macro only.

Normally I don't think the level-change macro is needed in this case. But it also denpends on your design of the planning book.

Best Regards,

Ada

[nitin_thatte · Accepted solution]

Hi Ada,

Problem Solved. The spool list still shows same message. But the alerts are generated.

Nitin Thatte

Edited by: Nitin Thatte on Sep 30, 2011 5:39 PM

[m_manimaran]

Hi,

Are you using the same aggregation level as your planning book selection? If not, change the aggregation level and try.

Regards,

Manimaran M.

[nitin_thatte]

Thanks for the reply.

The aggregation level is Location Product in Planning Book as well as in Macro.

Nitin Thatte

[m_manimaran]

Hi Nitin,

Please refer the SAP note 546079, this may give you some more idea.

Regards,

Manimaran M.