In mentioned below MOS tech note OLAP is mentioned as conditional. If its Installed in 11g Home then enable OLAP option in 12c home as well to avoid any issues.
Interoperability Notes Oracle EBS Release 12.0 or 12.1 with Oracle Database 12c Release 1 (220.127.116.11) (Doc ID 1930134.1)
X A H E E R
Thanks for getting back to me.
Yep I've learnt my lesson for next time, to avoid this sort of thing.
BEGIN dbms_aw.execute('aw delete FPA.FPAPJP'); END;
ERROR at line 1:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
ORA-37582: The EXPRESS AW version 11020003 is different than the Oracle version
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at line 1