OBIA 11g -BIACM: Load Plan Error - ORA-12514 TNS: listener does not currently know of service requested in connect descriptor

(Doc ID 2239869.1)

Last updated on JUNE 21, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

On: Oracle Business Intelligence Application

Running a load plan through BIACM

Getting below erro while running the Load.

"ODI-1519 Error Message ODI-1519: Serial step "Start Load Plan (InternalID:30024650)" failed because child step "Global Variable Refresh (InternalID:30025650)" 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
0:66000:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor"

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms