Symptom
You are running S&OP operator and you observe the execution failing with the bellow errors:
“Error in SCM Job Execution in method GET_SCM_OPER_TIME_PERIODS”
“sql processing error: "SAPHANADB"."/IBP/CL_SCM_OPER_UTIL=>GET_SCM_OPER_TIME_PERIODS": line 446 col 7 (at pos 23677): Cannot execute null SQL string (NullConversion exception): line 446 col 7 (at pos 23677)”
Read more...
Environment
- SAP Supply Chain Management (SCM)
- SAP Integrated Business Planning (SCM-IBP)
Product
Keywords
Heuristic, finite heuristic, FH, Optimizer, shelf life, Exception 1: CX_AMDP_EXECUTION_FAILED in /IBP/CL_SCM_OPER_UTIL -> GET_SCM_OPER_TIME_PERIODS #447 (/IBP/CL_SCM_OPER_UTIL=========CM002), sql processing error: "SAPHANADB"."/IBP/CL_SCM_OPER=>RUN_SCM_NORM_CHOREO_BATCH#stb2#20220624135715": line 19 col 3 (at pos 995): "SAPHANADB"."/IBP/CL_SCM_OPER=>RUN_SCM_NORM_CHOREO_BATCH": line 105 col 7 (at pos 4509): sql processing error: "SAPHANADB"."/IBP/CL_SCM_OPER_UTIL=>GET_SCM_OPER_TIME_PERIODS": line 446 col 7 (at pos 23677): Cannot execute null SQL string (NullConversion exception): line 446 col 7 (at pos 23677) in /IBP/CL_SCM_OPER_UTIL=>GET_SCM_OPER_TIME_PERIODS #447, job , KBA , SCM-IBP-SUP , Supply , SCM-IBP-SUP-OPT , Supply Optimizer , SCM-IBP-SUP-ALG , Algorithms , SCM-IBP-SUP-FH , Finite Heuristic , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.