My Oracle Support Banner

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 DECEMBER 03, 2021

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" failed because child step "Global Variable Refresh" 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.