ODI-17506: Variable has no value: PDGM_ARM.AP_PeriodName | FDMEE upgradation

User_5HF2M

Hello All,

While running the package AP Functional to FDMEE OI in ODI 12c (12.2.1) which is a part of FDMEE upgradation from ODI 11g. I am getting an error as below.

There is a variable name: AP_PeriodNum which has refresh query as below

SELECT TO_NUMBER(TO_CHAR(TO_DATE(SUBSTR(#PDGM_ARM.AP_PeriodName,1,3),'MM'),'MM'))

FROM DUAL

But on executing, it give below error.

 ODI-17506: Variable has no value: PDGM_ARM.AP_PeriodName

AP_PeriodName variable is also a refresh query but nothing is present in it. Not sure how it was taking value in ODI 11g.

Can someone please help on this?

Thanks!