Error: RUN_STORED_PROCEDURE in SAP BPC 10.

66 Views

Hi BPC Experts,

We are working on a SAP BPC Migration project.

Some packages that were wroking fine in SAP BPC 7.5 are not working in SAP BPC 10.

After the migration process we are facing an issue with packages that call a logic passing parameters, and in the script logic we execute the RUN_STORED_PROCEDURE instruction.

This is the DM script that we use to pass the parameters:

PROMPT(TEXT,%PRM_BEGIN_MONTH%,"Begin Month")

PROMPT(TEXT,%PRM_END_MONTH%,"End Month")

PROMPT(TEXT,%PRM_SOURCE_CAT%,"Select the source category")

PROMPT(TEXT,%PRM_DEST_CAT%,"Select the destination category")

BEGININFO(%LOGICPARAMETERS%)

*FUNCTION MY_SOURCE_CATEGORY = %PRM_SOURCE_CAT%

*FUNCTION MY_DEST_CATEGORY = %PRM_DEST_CAT%

*FUNCTION MY_BEGIN_MONTH = %PRM_BEGIN_MONTH%

*FUNCTION MY_END_MONTH = %PRM_END_MONTH%

*SELECT(%LISTOFPERIODS%,"[ID]",BS_MonthlyDate,"TIMEID BETWEEN (SELECT TIMEID FROM MBRBS_MonthlyDate WHERE ID IN ('MY_BEGIN_MONTH')) AND (SELECT TIMEID FROM MBRBS_MonthlyDate WHERE ID IN ('MY_END_MONTH'))")

ENDINFO

GLOBAL(FORMULASCRIPT,%LOGICPARAMETERS%)

This is the script logic that we use:

*RUN_STORED_PROCEDURE=AM_BPC_BILL_COPY_NETREV('MY_SOURCE_CATEGORY','MY_DEST_CATEGORY','MY_BEGIN_MONTH','MY_END_MONTH')

We have checked that the Stotred procedure is working properly, so the problem that we are facing is when passing the parameters from the DM prompt to the Script logic.

We have also modified the script logic syntax to put the variables with different combinations: %%, []... but we have not been able to make it work.

Any ideas??

Best regards and thanks in advance.