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 22.214.171.124.1 and later
Information in this document applies to any platform.
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"
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