Hi All,
Recently did Production BI Apps installation. When I execute initial domain load plan, I am facing the below issue immediately at refresh variable step itself.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ODI-1519: Serial step "Start Load Plan (InternalID:390520)" failed because child step "Global Variable Refresh (InternalID:391520)" is in error.
ODI-1529: Refresh of variable "BIAPPS.13P_CALENDAR_ID" failed :
select CASE WHEN 'Global Variable Refresh' in (select distinct group_code from C_PARAMETER_VALUE_FORMATTER_V where PARAM_CODE= '13P_CALENDAR_ID')
THEN (select param_value
from C_PARAMETER_VALUE_FORMATTER_V
where PARAM_CODE= '13P_CALENDAR_ID'
and group_code='Global Variable Refresh'
and datasource_num_id = '#BIAPPS.WH_DATASOURCE_NUM_ID')
ELSE
(select param_value from C_GL_PARAM_VALUE_FORMATTER_V where PARAM_CODE= '13P_CALENDAR_ID' and datasource_num_id = '#BIAPPS.WH_DATASOURCE_NUM_ID')
END
from Dual
942:42000:java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Probable cause: Few objects(synonyms) are missing in BIACOMP schema & not configured properly during BI Apps Installation.
Is there any way to fix this issue without reverting or re doing the installation?
Any suggestion would be more helpful us.
Thanks in Advance,
Sekar