Issue - ORDM installation - 11g
We are trying to install ORDM in ORacle 11g. We are following the steps in the installation guide -
Page 26 of the latest installation guide - While doing the Deploy and execute the project. While executing step number 4 - "RBIA_INTRA_ETL_FLW" we are getting the following error -
Any help will be really appriciated
====
RBIA_INTRA_ETL_FLW:IS_DERIVED_SUCCESSFUL1
Error
RPE-01003: An infrastructure condition prevented the request from completing.
RBIA_INTRA_ETL_FLW:IS_DERIVED_SUCCESSFUL1
Error
RPE-01038: Failed to evaluate expression declare "$LOOP_DETECT$" NUMBER := 0;function "RBIA_INTRA_ETL_FLW" return VARCHAR2 is "ITEM_TYPE" VARCHAR2(4000) := (owbsys.wb_rt_task_variable.get_value(13133));"ITEM_KEY" VARCHAR2(4000) := (owbsys.wb_rt_task_variable.get_value(13135));"V_PROCESS_NO" NUMBER := (owbsys.wb_rt_task_variable.get_value(13138));"EVAL_LOCATION" VARCHAR2(4000) := (owbsys.wb_rt_task_variable.get_value(13136));function "IS_DERIVED_SUCCESSFUL" return VARCHAR2 is "WARNING" NUMBER := 2;"FUNCTION_NAME" VARCHAR2(4000) := (owbsys.wb_rt_task_variable.get_value(13286));"RETURN_RESULT_NUMBER" NUMBER := 1;"P_PROCESS_NO" NUMBER := (owbsys.wb_rt_task_variable.get_value(13291));"NUMBER_OF_ERRORS" NUMBER := 0;"SUCCESS" NUMBER := 1;"USE_RETURN_AS_STATUS" BOOLEAN := wb_rt_conversions.to_boolean(owbsys.wb_rt_task_variable.get_value(13289));"ERROR" NUMBER := 3;"PACKAGE_NAME" VARCHAR2(4000) := (owbsys.wb_rt_task_variable.get_value(13287));"OK" NUMBER := 1;"FAILURE" NUMBER := 3;"AUDIT_ID" NUMBER := 13285;"RETURN_CODE" NUMBER := 1;"ODB_STORE_UOID" VARCHAR2(4000) := (owbsys.wb_rt_task_variable.get_value(13288));"NUMBER_OF_WARNINGS" NUMBER := 0;"RETURN_RESULT" VARCHAR(64) := 'OK';"PARENT_AUDIT_ID" NUMBER := 13132;"OK_WITH_WARNINGS" NUMBER := 2;"IS_DERIVED_SUCCESSFUL" BOOLEAN := wb_rt_conversions.to_boolean(owbsys.wb_rt_task_variable.get_value(13290));begin "$LOOP_DETECT$" := "$LOOP_DETECT$" + 1;if "$LOOP_DETECT$" > 2 then raise_application_error(-20001, 'Loop detected calling "IS_DERIVED_SUCCESSFUL"');end if;return to_char(CASE WHEN ("IS_DERIVED_SUCCESSFUL"."IS_DERIVED_SUCCESSFUL" =FALSE) THEN 1 ELSE 0 END);end;begin "$LOOP_DETECT$" := "$LOOP_DETECT$" + 1;if "$LOOP_DETECT$" > 2 then raise_application_error(-20001, 'Loop detected calling "RBIA_INTRA_ETL_FLW"');end if;return "IS_DERIVED_SUCCESSFUL";end;begin :result := "RBIA_INTRA_ETL_FLW";end;. Please modify the expression, redeploy and retry again.
RBIA_INTRA_ETL_FLW:IS_DERIVED_SUCCESSFUL1
Error
ORA-06550: line 1, column 1537:
PLS-00487: Invalid reference to variable 'IS_DERIVED_SUCCESSFUL'
ORA-06550: line 1, column 1485:
PL/SQL: Statement ignored