3237763 - S&OP Operator failing in method GET_SCM_OPER_TIME_PERIODS

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)”

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

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