3472975 - IBP – Error in Excel, Projected Stock App or Planning runs after setup IBP_CONSUMPTION for OBP.

After following the documentation according to below help page to use IBP_CONSUMPTION for forecast consumption:

Configuration of the IBP_CONSUMPTION Function

1 - In attempt to open Forecast Input Key Figures in Excel UI, it returns the below error:

 “SQL execution error

Error with sub-query task 0000 PLAREA __BASELINE”

And/or,

2 - There are an error when opening Projected Stock App.

And/or,

3 - Planning jobs are failing.

Then after reviewing the troubleshooting from help page:

Troubleshooting

Error still happening.

• SAP Supply Chain Management (SCM)
• SAP Integrated Business Planning (SCM-IBP)

OBP, Order-Based Planning, CONSUMPTIONMODE, SQL execution error, Error with sub-query task 0000, IBP_CONSUMPTION, Calculation Scenario Backend Access. , KBA , SCM-IBP-TDS , OBP Planning Area and external keyfigures , SCM-IBP-BF-ADV , Advanced Simulation , SCM-IBP-RM-PLG , Planning , SCM-IBP-CAL , Configured Calculations , Problem