SAP AO not triggering Planning Sequence

[seudunur]

Hi ,

We have an input template with 3 queries and one planning sequence. Planning sequence has logic to calculate amounts based on some conditions. When the user enters the data in input template only that record is saved. When I execute the planning sequence using RSPLAN and save planning buffer data , all the calculated records are saved to the ADSO. This input template used to work as expected earlier , now its not triggering the planning sequence. any help is appreciated. We are using BPC embedded on BW 7.5 , AO 2.7 sp .9

[gregor_dieckmann]

Hi Sri,

there is now information how you configured the planning function in AO and when it is executed, e.g. based on an AO event, based on a button, based VBA code or is it a planning function on 'SAVE' configured in RSPLAN.

Regards,

Gregor

[seudunur]

Hi Gregor,

Thanks for the reply.

In AO planning sequence PS_1 is used and this Planning Sequence has one planning function .

When I enter Amount in AO , this record (only one record) is being saved. When I enter Amount in another cell , two records are being saved ( one record from planning function execution for the previous entry and one newly entered record).

Save is based on Button which has VBA code .I tried manually as well. same result.

Here ths VBA code.

For SAVE button:

Sub RunAllMacros()

Plan_Seq

Save

End Sub

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

Sub Plan_Seq()

Call Application.Run("SAPExecutePlanningSequence", "PS_2")

End Sub

---------

Sub Save()

If Range("N6") = "ERROR" Then

MsgBox ("Errors were found, data will not be saved")

Else

Call Application.Run("SAPExecuteCommand", "PlanDataSave")

End If

End Sub

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

[gregor_dieckmann]

Hi Sri,

is there a typo in your description of macro:

- description PS_1

- macro PS_2

As the query filter, filter user use in the planning sequence and maybe used variables are not described here it is not possible to analyze; if this worked earlier and you have not changed anything in the workbook and planning sequence you should open a ticket.

Regards,

Gregor