Run ETL task from sql

set serveroutput on;

——————- kick out asyn task ————————————–
DECLARE
P_TASK_ID VARCHAR2(200);
P_DOMAIN VARCHAR2(200);
P_STATUS NUMBER;
P_XML_RESULT XMLTYPE;
p_response varchar(4000);
p_res clob ;
BEGIN

select ‘task_test-abcdefg’ into p_Task_id from dual;
select ‘ETLORI’ into p_domain from dual;
etl_task_mgr.run_etl_task(p_task_id
, (more…)

Set up view for OWB processing

——————————————————–
—  DDL for View ETL_WB_RT_AUDIT_PARAMETERS
——————————————————–

CREATE OR REPLACE FORCE VIEW “USER_NAME”.”ETL_WB_RT_AUDIT_PARAMETERS” (“AUDIT_PARAMETER_ID”, “AUDIT_EXECUTION_ID”, “PARAMETER_NAME”, “PARAMETER_TYPE”, “PARAMETER_KIND”, “PARAMETER_MODE”, “PARAMETER_SCOPE”, “VALUE_MODE”, “BOUND_TO_ID”, “IS_REQUIRED”, “IS_FIXED”, “PARAMETER_UOID”, “VALUE_KIND”, “CLOB_VALUE”, “VALUE”, (more…)