SQL> @owbcollect.sql DATA COLLECTED ============== OWBCOLLECT.SQL 1.8.6 Collecting from host : mtcetl Platform : Solaris[tm] OE (64-bit) Instance Name : mtcedwp. Version 10.2.0.3.0 Collection time : 10-may-2011 07:28:32 OWB OWBRT_SYS.OWBRTPS ===================== KEY VALUE -------------------------------------------------------------------------- 10.2.0.1.31[1] /u02/app/oracle/product/owb10g OWB DESIGN REPOSITORIES ======================= OWNER INSTALLED_VERSION RELEASE CREATED_ON -------------------------------------------------------------------------- ATBI_OWBOWNER 10.2.0.2.0 10.2.0.1.31 19-MAY-08 OWB DESIGN REPOSITORY: USERS (If Multi User Environment) ======================================================== OWNER DESIGN REPOSITORY USER DESIGN REPOSITORY -------------------------------------------------------- ATBI_OWBOWNER OWF_MGR ATBI_OWBOWNER PS123 ATBI_OWBOWNER MWAHEED ATBI_OWBOWNER ATBI_RDS ATBI_OWBOWNER ATBI_RPSTRY ATBI_OWBOWNER ATBI_ODS ATBI_OWBOWNER ATBI_TDS ATBI_OWBOWNER ATBI_LDS ATBI_OWBOWNER ATBI_OWBUSER ATBI_OWBOWNER GUEST ATBI_OWBOWNER ATBI_DDS ATBI_OWBOWNER ATBI_ADS ATBI_OWBOWNER MASAD OWB RUNTIME REPOSITORIES / CONTROL CENTERS (WB_RTV_SERVICE_NODES) ================================================================= = OWNER NODE INST AVAILABLE ENABLED ACTIVE HOST PORT SERVICE_NAME RT_VERSION SERVER_SIDE_HOME --------------------------------------------------------------------------------------------------------------------------------------------- ATBI_OWBOWNER 1 1 Y 1 1 10.1.1.2 1521 MTCEDWP 10.2.0.2.0 /u02/app/oracle/product/owb10g OWB RUNTIME ACCESS USERS ======================== RUNTIME ACCESS USER CONNECTED TO RUNTIME ------------------------------------------------- No OWB Runtime Access Users installed OWB TARGETS =========== TARGET RTP/CONTROL CENTER SERVICE RT_VERSION ---------------------------------------------------------------------------------- ATBI_OWBUSER is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 ATBI_LDS is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 ATBI_ODS is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 ATBI_DDS is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 ATBI_TDS is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 ATBI_ADS is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 ATBI_RDS is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 ATBI_RPSTRY is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 PS123 is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 MWAHEED is serviced by rtp/cc ATBI_OWBOWNER 10.2.0.2.8 OWB DESIGN REPOSITORIES: SIZE ============================= ATBI_OWBOWNER cmpmmmclasses 23540 rows OWB DESIGN REPOSITORIES: STATISTICS DETECTION ============================================= ATBI_OWBOWNER Statistics detected on tables. ATBI_OWBOWNER Statistics detected on indexes. OWB RUNTIME REPOSITORIES / CONTROL CENTERS: SIZE ================================================ ATBI_OWBOWNER wb_rt_stores 16 rows PlatformSchema seeded correctly - wb_rt_platform_properties 272 rows Platform properties seeded correctly - wb_rt_audit_deployments 1933 rows - wb_rt_audit_executions 99104 rows - wb_rt_tasks 1017 rows - wb_rt_def_deployment_adapters 31 rows - wb_rt_def_execution_adapters 4 rows - wb_rt_def_execution_operators 52 rows - wb_rt_def_file_types 41 rows - wb_rt_def_object_types 414 rows - wb_rt_def_object_type_defs 170 rows - wb_rt_def_operator_results 243 rows - wb_rt_def_store_types 25 rows - wb_rt_def_store_type_params 199 rows - wb_rt_def_system_parameters 305 rows - wb_rt_def_impl_types 20 rows - wb_rt_def_system_parameters 305 rows - wb_rt_notify_queue_tab 92102 rows - wb_rt_audit 32330 rows - wb_rt_audit_messages 18367 rows - wb_rt_audit_message_lines 18996 rows - wb_rt_errors 9410 rows - wb_rt_feedback 15657246 rows - OWB RUNTIME REPOSITORIES / CONTROL CENTERS: STATISTICS DETECTION ================================================================ ATBI_OWBOWNER Statistics detected on tables. ATBI_OWBOWNER Statistics detected on indexes. OWB RUNTIME REPOSITORIES / CONTROL CENTERS: WB_RT_PLATFORM_REPOSITORY ===================================================================== PROPERTY_PATH PROPERTY_VALUE --------------------------------------------------------------------- RuntimePlatform Properties for ATBI_OWBOWNER --------------------------------------------------------------------- property.RuntimePlatform.0.uoid 4D909C704E895284E04400144F8EA6A2 property.RuntimePlatform.0.version 10.2.0.2.8 property.RuntimePlatform.0.min_service_version 10.2.0.2.0 property.RuntimePlatform.0.runtime_home %RTHOME% property.RuntimePlatform.0.platform_net_service_name property.RuntimePlatform.0.platform_net_host_name property.RuntimePlatform.0.recovery true property.RuntimePlatform.0.trace some property.RuntimePlatform.0.exceptions %RTHOME%/owb/log/ATBI_OWBOWNER.log property.RuntimePlatform.0.temp_dir_name %RTHOME%/owb/temp property.RuntimePlatform.0.messages %RTHOME%/owb/log/ATBI_OWBOWNER.log property.RuntimePlatform.0.purge_delay_hours 24 property.RuntimePlatform.0.purge_minimum_minutes 10 property.RuntimePlatform.0.service_command %RTHOME%/owb/bin/unix/run_service.sh property.RuntimePlatform.0.service_parameters %RTHOME% ATBI_OWBOWNER %HOST% %PORT% %SERVICE% property.RuntimePlatform.0.delete_all_job_on_complete false property.RuntimePlatform.0.logfile_max_size 0 property.RuntimePlatform.0.max_number_logfiles 10 property.RuntimePlatform.0.trace_control_on true property.RuntimePlatform.0.platform TRUE - --------------------------------------------------------------------- RuntimePlatform Properties SQLLDR for ATBI_OWBOWNER --------------------------------------------------------------------- property.RuntimePlatform.0.NativeExecution.SQLLoader.oracle_home_10g property.RuntimePlatform.0.NativeExecution.SQLLoader.oracle_home_8i property.RuntimePlatform.0.NativeExecution.SQLLoader.oracle_home_9i property.RuntimePlatform.0.NativeExecution.SQLLoader.oracle_home_default property.RuntimePlatform.0.NativeExecution.SQLLoader.sqlldr_exe_10g property.RuntimePlatform.0.NativeExecution.SQLLoader.sqlldr_exe_8i property.RuntimePlatform.0.NativeExecution.SQLLoader.sqlldr_exe_9i property.RuntimePlatform.0.NativeExecution.SQLLoader.sqlldr_exe_default - --------------------------------------------------------------------- RuntimePlatform Properties SQLPLUS for ATBI_OWBOWNER --------------------------------------------------------------------- property.RuntimePlatform.0.NativeExecution.SQLPlus.oracle_home_10g property.RuntimePlatform.0.NativeExecution.SQLPlus.oracle_home_8i property.RuntimePlatform.0.NativeExecution.SQLPlus.oracle_home_9i property.RuntimePlatform.0.NativeExecution.SQLPlus.oracle_home_default property.RuntimePlatform.0.NativeExecution.SQLPlus.sqlplus_exe_10g property.RuntimePlatform.0.NativeExecution.SQLPlus.sqlplus_exe_8i property.RuntimePlatform.0.NativeExecution.SQLPlus.sqlplus_exe_9i property.RuntimePlatform.0.NativeExecution.SQLPlus.sqlplus_exe_default - RUN_SERVICE.SH / RUN_SERVICE.BAT ================================ RUNTIME REPOSITORY RUN_SERVICE -------------------------------------------------------- Unable to read run_service.sh / run_service.bat, because instance parameter utl_file_dir is not set to * . See OWB Installation and Configuration Guide: A.2 Parameters for the Runtime Repository Database Instance. . OWB WB_RT_SERVICE_JOB_LOGS (last 10 entries) =========================================== TIME_STAMP MESSAGE ------------------------------------------------------------------------------------- ATBI_OWBOWNER ------------------------------------------------------------------------------------- 24-feb-2011 13:15:55 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -automatic 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER LOCALHOST 1521 MTCEDWP" 24-feb-2011 13:21:55 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -automatic 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER LOCALHOST 1521 MTCEDWP" 24-feb-2011 13:27:56 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -automatic 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER LOCALHOST 1521 MTCEDWP" 24-feb-2011 13:33:57 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -automatic 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER LOCALHOST 1521 MTCEDWP" 25-mar-2011 13:20:07 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -automatic 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER LOCALHOST 1521 MTCEDWP" 07-apr-2011 10:38:07 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -automatic 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER LOCALHOST 1521 MTCEDWP" 28-apr-2011 12:05:00 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -automatic 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER LOCALHOST 1521 MTCEDWP" 06-may-2011 00:56:58 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -manual 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER 10.1.1.2 1521 MTCEDWP" 06-may-2011 01:23:52 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -manual 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER 10.1.1.2 1521 MTCEDWP" 09-may-2011 14:04:02 /u02/app/oracle/product/owb10g/owb/bin/unix/run_service.sh . -manual 1 /u02/app/oracle/product/owb10g ATBI_OWBOWNER 10.1.1.2 1521 MTCEDWP" . ------------------------------------------------------------------------------------- OWB LOCATIONS REGISTERED ============================================================================================================ LOCATION TYPE VERSION PARAMETER VALUE ------------------------------------------------------------------------------------------------------------------ ------------------------ Locations for ATBI_OWBOWNER ------------------------ ATBI_ADS_LOCATION Oracle Database 10.2 ConnectAs ATBI_ADS - - - Host MTCETL - - - Port 1521 - - - Schema ATBI_ADS - - - Service MTCEDWP ATBI_BATCH_LOCATION Oracle Workflow 2.6.4 Host 10.1.1.2 - - - Port 1521 - - - Schema OWF_MGR - - - Service MTCEDWP ATBI_DDS_LOCATION Oracle Database 10.2 ConnectAs ATBI_DDS - - - Host MTCETL - - - Port 1521 - - - Schema ATBI_DDS - - - Service MTCEDWP ATBI_LDS_LOCATION Oracle Database 10.2 ConnectAs ATBI_LDS - - - Host MTCETL - - - Port 1521 - - - Schema ATBI_LDS - - - Service MTCEDWP ATBI_ODS_LOCATION Oracle Database 10.2 ConnectAs ATBI_ODS - - - Host MTCETL - - - Port 1521 - - - Schema ATBI_ODS - - - Service MTCEDWP ATBI_RDS_LOCATION Oracle Database 10.2 ConnectAs ATBI_RDS - - - Host MTCETL - - - Port 1521 - - - Schema ATBI_RDS - - - Service MTCEDWP ATBI_RPSTRY_LOCATION Oracle Database 10.2 ConnectAs ATBI_RPSTRY - - - Host MTCETL - - - Port 1521 - - - Schema ATBI_RPSTRY - - - Service MTCEDWP ATBI_TDS_LOCATION Oracle Database 10.2 ConnectAs ATBI_TDS - - - Host MTCETL - - - Port 1521 - - - Schema ATBI_TDS - - - Service MTCEDWP ATHEER_SCH_LOCATION1 Oracle Database 10.2 ConnectAs ATBI_TDS - - - Host 10.1.1.2 - - - Port 1521 - - - Schema ATBI_TDS - - - Service MTCEDWP DWH_SHEDULER_LOC Oracle Database 10.2 ConnectAs ATBI_TDS - - - Host 10.1.1.2 - - - Port 1521 - - - Schema ATBI_TDS - - - Service MTCEDWP LOG_FILE_LOCATION File System 0 RootPath /u02/atheerbi/BACKUP SMS_TMP_FILES_LOCATION File System 0 RootPath /u02/atheerbi/CONSOLIDATE SRC_FILES_LOCATION File System 0 RootPath /u02/atheerbi/CONSOLIDATE TEST_PFLOW_LOCATION1 Oracle Workflow 2.6.4 Host 10.1.1.2 - - - Port 1521 - - - Schema OWF_MGR - - - Service MTCEDWP TMP_FILES_LOCATION File System 0 RootPath /u02/atheerbi/CONSOLIDATE . ORACLE WORKFLOW =============== OWNER VERSION ---------------------------- OWF_MGR 2.6.4.0.0 RDBMS: V$VERSION ================ BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0 Production TNS for Solaris: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production RAC: Real Application Cluster (view gv$instance, gv$active_instances) ===================================================================== RAC: This is not a Real Application Cluster. RDBMS: DBA_REGISTRY =================== COMP_NAME STATUS VERSION ---------------------------------------- ---------- ------------ OLAP Catalog VALID 10.2.0.3.0 Oracle interMedia VALID 10.2.0.3.0 Oracle XML Database VALID 10.2.0.3.0 Oracle Data Mining VALID 10.2.0.3.0 Oracle Expression Filter VALID 10.2.0.3.0 Oracle Rules Manager VALID 10.2.0.3.0 Oracle Workspace Manager VALID 10.2.0.1.0 Oracle Database Catalog Views VALID 10.2.0.3.0 Oracle Database Packages and Types VALID 10.2.0.3.0 JServer JAVA Virtual Machine VALID 10.2.0.3.0 Oracle XDK VALID 10.2.0.3.0 Oracle Database Java Packages VALID 10.2.0.3.0 OLAP Analytic Workspace VALID 10.2.0.3.0 Oracle OLAP API VALID 10.2.0.3.0 Some components of DBA_REGISTRY do not have the same version as the instance 10.2.0.3.0 COMP_NAME VERSION ---------------------------------------- ------------ Oracle Workspace Manager 10.2.0.1.0 RDBMS: JAVA VIRTUAL MACHINE =========================== COMP_NAME STATUS VERSION ---------------------------------------- ---------- ------------ JServer JAVA Virtual Machine VALID 10.2.0.3.0 Oracle XDK VALID 10.2.0.3.0 Oracle Database Java Packages VALID 10.2.0.3.0 RDBMS: NUMBER OF JAVA OBJECTS PER SCHEMA ======================================== OWNER COUNT(*) ------------------------------ ---------- SYS 15751 ATBI_OWBOWNER 164 EXFSYS 42 ORDSYS 1454 RDBMS INVALID OBJECTS: JAVA =========================== All JAVA objects in the instance are valid RDBMS INVALID OBJECTS: NOT JAVA OBJECTS ======================================= OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ------------------------------ ------------------- ------- ATBI_ADS ADS_ACTVTY_FCT_LD PACKAGE INVALID ADS_ACTVTY_FCT_LD PACKAGE BODY INVALID ADS_AVTVTY_LOAD PACKAGE BODY INVALID ADS_DELETE_ACTVTY_CB_DATA PACKAGE INVALID ADS_DELETE_ACTVTY_CB_DATA PACKAGE BODY INVALID ADS_EDR_FCT_LD PACKAGE INVALID ADS_EDR_FCT_LD PACKAGE BODY INVALID ADS_LD_SBSCRBR_STATUS_FACT_MAP PACKAGE INVALID ADS_LD_SBSCRBR_STATUS_FACT_MAP PACKAGE BODY INVALID ADS_MNTHLY_CL_LNGTH_CUBE_LD PACKAGE INVALID ADS_MNTHLY_CL_LNGTH_CUBE_LD PACKAGE BODY INVALID ADS_MNTHLY_STTS_FCT_LD PACKAGE INVALID ADS_MNTHLY_STTS_FCT_LD PACKAGE BODY INVALID ADS_SBSCRBR_FCT_LD PACKAGE INVALID ADS_SBSCRBR_FCT_LD PACKAGE BODY INVALID ADS_SBS_STTS_FCT_LD PACKAGE INVALID ADS_SBS_STTS_FCT_LD PACKAGE BODY INVALID ADS_SUBSCRIBER_STATUS_FACT_LD PACKAGE BODY INVALID ADS_TOPPOP_CB_LD PACKAGE INVALID ADS_TOPPOP_CB_LD PACKAGE BODY INVALID BKP_ADS_EDR_FCT_LD PACKAGE INVALID BKP_ADS_EDR_FCT_LD PACKAGE BODY INVALID COPY_OF_ADS_EDR_FCT PACKAGE INVALID COPY_OF_ADS_EDR_FCT PACKAGE BODY INVALID GET_ACTIVITY FUNCTION INVALID GET_DT_KY FUNCTION INVALID P_DEL_ACTVTY_CUBE_DATA PROCEDURE INVALID P_DEL_ACTVTY_CUBE_TEMP_DATA PROCEDURE INVALID TEST PACKAGE INVALID TEST PACKAGE BODY INVALID TEST_ADS_LD_ACTVTY_CB_CDR PROCEDURE INVALID ATBI_DDS ACTVTY_DIM_LD PACKAGE BODY INVALID CHRNG_RVNU_BRKP_DIM_LD PACKAGE BODY INVALID CLNG_CLD_OPRTRS_DIM_LD PACKAGE BODY INVALID DT_DIM DIMENSION INVALID DT_DIM_MAP PACKAGE BODY INVALID DT_DIM_V VIEW INVALID DT_DM_V VIEW INVALID SDS_V VIEW INVALID SUBSCRIBER_DIM_MAP PACKAGE INVALID SUBSCRIBER_DIM_MAP PACKAGE BODY INVALID V_MSM_OPRTR_DIM VIEW INVALID ATBI_LDS ACTVTY_LKP_LD PACKAGE INVALID ACTVTY_LKP_LD PACKAGE BODY INVALID ACTVTY_LKP_LD_TRF PACKAGE INVALID ACTVTY_LKP_LD_TRF PACKAGE BODY INVALID ACTVT_TARIF_LKP_LD PACKAGE INVALID ACTVT_TARIF_LKP_LD PACKAGE BODY INVALID CHRG_RVN_LKP_LD PACKAGE INVALID CHRG_RVN_LKP_LD PACKAGE BODY INVALID CHRG_TM_BRK_LK_LD PACKAGE INVALID CHRG_TM_BRK_LK_LD PACKAGE BODY INVALID CLNG_CLD_OPRTR_LKP PACKAGE BODY INVALID CL_LNGTH_BRKP_LKP_LD PACKAGE INVALID CL_LNGTH_BRKP_LKP_LD PACKAGE BODY INVALID CL_TP_ACTVTY PROCEDURE INVALID DMB_RT_GRP_LKP PACKAGE BODY INVALID DRMNCY_PRD_BRKP_LKP_LD PACKAGE INVALID DRMNCY_PRD_BRKP_LKP_LD PACKAGE BODY INVALID DW_KY_GNRTR FUNCTION INVALID EDR_TP_LDP_LD PACKAGE INVALID EDR_TP_LDP_LD PACKAGE BODY INVALID EQUIP_FEE_LKP PACKAGE BODY INVALID HRLY_BRKP_LKP_LD PACKAGE INVALID HRLY_BRKP_LKP_LD PACKAGE BODY INVALID LCTN_LKP_LD PACKAGE INVALID LCTN_LKP_LD PACKAGE BODY INVALID LCTN_RLTNSHPS_LKP_LD PACKAGE INVALID LCTN_RLTNSHPS_LKP_LD PACKAGE BODY INVALID LDS_PROCS PACKAGE BODY INVALID OPRTR_LKP_LD PACKAGE INVALID OPRTR_LKP_LD PACKAGE BODY INVALID RVNU_BRKP_LKP_LD PACKAGE INVALID RVNU_BRKP_LKP_LD PACKAGE BODY INVALID RVNU_CMPNT_LKP_LD PACKAGE INVALID RVNU_CMPNT_LKP_LD PACKAGE BODY INVALID SBSCRBR_STTS_LKP_LD PACKAGE INVALID SBSCRBR_STTS_LKP_LD PACKAGE BODY INVALID SBSCRBR_TPS_LKP_LD PACKAGE INVALID SBSCRBR_TPS_LKP_LD PACKAGE BODY INVALID TM_BRKP_LKP_LD PACKAGE INVALID TM_BRKP_LKP_LD PACKAGE BODY INVALID TRF_PRFL_LKP_LD PACKAGE BODY INVALID ATBI_ODS EXECUTE_LD_JOB PACKAGE BODY INVALID EXECUTE_LD_JOB2 PACKAGE BODY INVALID EXECUTE_LD_JOB_PARALLEL PACKAGE BODY INVALID EXEC_LD_JOB PROCEDURE INVALID EXEC_LD_JOB2 PROCEDURE INVALID EXEC_LD_JOB3 PROCEDURE INVALID EXEC_LD_JOB4 PROCEDURE INVALID LD_CRMUSERINFO_MAP PACKAGE BODY INVALID LD_SBSCRBR_CONN_FEE_MAP PACKAGE INVALID LD_SBSCRBR_CONN_FEE_MAP PACKAGE BODY INVALID LD_SBSCRBR_FEE_DATA_MAP PACKAGE INVALID LD_SBSCRBR_FEE_DATA_MAP PACKAGE BODY INVALID LOAD_SBSCRBR_FEE_DATA PROCEDURE INVALID ODS_IN_CDR_LD PACKAGE BODY INVALID ODS_IN_EDR_LD PACKAGE INVALID ODS_IN_EDR_LD PACKAGE BODY INVALID ODS_IN_SBSCRBR_HIST_LD PACKAGE INVALID ODS_IN_SBSCRBR_HIST_LD PACKAGE BODY INVALID ODS_IN_SBSCRBR_UPDATE PACKAGE INVALID ODS_IN_SBSCRBR_UPDATE PACKAGE BODY INVALID ODS_IN_SMS_LD PACKAGE INVALID ODS_IN_SMS_LD PACKAGE BODY INVALID ODS_LD_POST_PAID_SRC PACKAGE BODY INVALID ODS_LD_SBSCRBR_FEE_DATA PACKAGE INVALID ODS_LD_SBSCRBR_FEE_DATA PACKAGE BODY INVALID ODS_POSTPAID_INT_VOICE PACKAGE INVALID ODS_POSTPAID_INT_VOICE PACKAGE BODY INVALID ODS_POSTPAID_MTSMS PACKAGE INVALID ODS_POSTPAID_MTSMS PACKAGE BODY INVALID ODS_POSTPAID_SMS PACKAGE INVALID ODS_POSTPAID_SMS PACKAGE BODY INVALID ODS_POSTPAID_VAS_DATA PACKAGE INVALID ODS_POSTPAID_VAS_DATA PACKAGE BODY INVALID ODS_POSTPAID_VOICE_DATA PACKAGE INVALID ODS_POSTPAID_VOICE_DATA PACKAGE BODY INVALID ODS_POST_PAID_MAP PACKAGE BODY INVALID ODS_PREPAID_MTCALLS PACKAGE INVALID ODS_PREPAID_MTCALLS PACKAGE BODY INVALID ODS_PREPAID_MTSMS PACKAGE INVALID ODS_PREPAID_MTSMS PACKAGE BODY INVALID ODS_SBSCRBR_CLEANUP PACKAGE INVALID ODS_SBSCRBR_CLEANUP PACKAGE BODY INVALID ODS_SBSCRBR_LCS_UPDATE PACKAGE INVALID ODS_SBSCRBR_LCS_UPDATE PACKAGE BODY INVALID ODS_SBSCRBR_SRVC_FEE_LD PACKAGE BODY INVALID POST_PAID_ADS_LD_ACTVTY_CB_CDR PROCEDURE INVALID POST_PAID_ADS_LD_ACTVTY_CB_SMS PROCEDURE INVALID SBSCRBR_FEE_TEST PACKAGE BODY INVALID SBSCRBR_LCS_UPDATE_BKP14JUL08 PROCEDURE INVALID TMP_EXEC_SBSCRBR_DATA PROCEDURE INVALID ATBI_OLAP ADS_LD_ACTVTY_CB_CDR PROCEDURE INVALID ATBI_OWBOW OWB_COMPPARAM_MV MATERIALIZED VIEW INVALID ATBI_OWBUS ALL_RT_AUDIT_DEPLOYMENTS SYNONYM INVALID ALL_RT_AUDIT_EXECUTIONS SYNONYM INVALID ALL_RT_AUDIT_EXECUTION_PARAMS SYNONYM INVALID ALL_RT_AUDIT_EXEC_FILES SYNONYM INVALID ALL_RT_AUDIT_EXEC_MESSAGES SYNONYM INVALID ALL_RT_AUDIT_LOCATIONS SYNONYM INVALID ALL_RT_AUDIT_LOCATION_FILES SYNONYM INVALID ALL_RT_AUDIT_LOCATION_MESSAGES SYNONYM INVALID ALL_RT_AUDIT_OBJECTS SYNONYM INVALID ALL_RT_AUDIT_SCRIPT_FILES SYNONYM INVALID ALL_RT_AUDIT_SCRIPT_MESSAGES SYNONYM INVALID ALL_RT_AUDIT_SCRIPT_RUNS SYNONYM INVALID ALL_RT_INSTALLATIONS SYNONYM INVALID ALL_RT_OBJECTS SYNONYM INVALID ALL_RT_TASK_PARAMETERS SYNONYM INVALID INTERACTIONEXECUTE SYNONYM INVALID INTERACTIONEXECUTEBUILD SYNONYM INVALID NAME_ADDR SYNONYM INVALID OWB$CDC$GET_LAST_DAY_LB SYNONYM INVALID OWB$CDC$GET_LAST_DAY_UB SYNONYM INVALID OWB$CDC$GET_LAST_MONTH_LB SYNONYM INVALID OWB$CDC$GET_LAST_MONTH_UB SYNONYM INVALID OWB$CDC$GET_LAST_WEEK_LB SYNONYM INVALID OWB$CDC$GET_LAST_WEEK_UB SYNONYM INVALID OWB$CDC$GET_LATEST_UB SYNONYM INVALID OWB$CDC$GET_TXNS_START_TIME SYNONYM INVALID OWBRTPS_KEY_TO_INSTANCE SYNONYM INVALID OWBRTPS_KEY_TO_VERSION SYNONYM INVALID OWBRTPS_KEY_TO_VERSION_STRING SYNONYM INVALID OWBXMLTK SYNONYM INVALID OWB_MATCH_MERGE SYNONYM INVALID OWB_TIMESERIES SYNONYM INVALID WB SYNONYM INVALID WBRTTIME SYNONYM INVALID WB_ABORT SYNONYM INVALID WB_ANALYZE_SCHEMA SYNONYM INVALID WB_ANALYZE_TABLE SYNONYM INVALID WB_CAL_MONTH_NAME SYNONYM INVALID WB_CAL_MONTH_OF_YEAR SYNONYM INVALID WB_CAL_MONTH_SHORT_NAME SYNONYM INVALID WB_CAL_QTR SYNONYM INVALID WB_CAL_WEEK_OF_YEAR SYNONYM INVALID WB_CAL_YEAR SYNONYM INVALID WB_CAL_YEAR_NAME SYNONYM INVALID WB_COMPILE_PLSQL SYNONYM INVALID WB_DATE_FROM_JULIAN SYNONYM INVALID WB_DAY_NAME SYNONYM INVALID WB_DAY_OF_MONTH SYNONYM INVALID WB_DAY_OF_WEEK SYNONYM INVALID WB_DAY_OF_YEAR SYNONYM INVALID WB_DAY_SHORT_NAME SYNONYM INVALID WB_DECADE SYNONYM INVALID WB_DISABLE_ALL_CONSTRAINTS SYNONYM INVALID WB_DISABLE_ALL_TRIGGERS SYNONYM INVALID WB_DISABLE_CONSTRAINT SYNONYM INVALID WB_DISABLE_TRIGGER SYNONYM INVALID WB_ENABLE_ALL_CONSTRAINTS SYNONYM INVALID WB_ENABLE_ALL_TRIGGERS SYNONYM INVALID WB_ENABLE_CONSTRAINT SYNONYM INVALID WB_ENABLE_TRIGGER SYNONYM INVALID WB_HOUR12 SYNONYM INVALID WB_HOUR12MI_SS SYNONYM INVALID WB_HOUR24 SYNONYM INVALID WB_HOUR24MI_SS SYNONYM INVALID WB_IS_DATE SYNONYM INVALID WB_IS_NUMBER SYNONYM INVALID WB_IS_SPACE SYNONYM INVALID WB_JULIAN_FROM_DATE SYNONYM INVALID WB_MI_SS SYNONYM INVALID WB_OLAP_AW_GET_SOLVE_ID SYNONYM INVALID WB_OLAP_AW_PRECOMPUTE SYNONYM INVALID WB_OLAP_AW_REMOVE_SOLVE_ID SYNONYM INVALID WB_OLAP_AW_SET_SOLVE_ID SYNONYM INVALID WB_OLAP_LOAD_CUBE SYNONYM INVALID WB_OLAP_LOAD_DIMENSION SYNONYM INVALID WB_RTU_TRANSACTION_HANDLER SYNONYM INVALID WB_RTV_DP_BUS_ATTR_MAPS SYNONYM INVALID WB_RTV_DP_BUS_RULE_STATS SYNONYM INVALID WB_RTV_DP_BUS_TABLE_STATS SYNONYM INVALID WB_RTV_DP_COLUMNINFO SYNONYM INVALID WB_RTV_DP_COLUMNSTATS SYNONYM INVALID WB_RTV_DP_CONFIGSTATS SYNONYM INVALID WB_RTV_DP_CONSTRAINTINFO SYNONYM INVALID WB_RTV_DP_CONSTRAINTSTATS SYNONYM INVALID WB_RTV_DP_DEBUG SYNONYM INVALID WB_RTV_DP_DOMAINVALUES SYNONYM INVALID WB_RTV_DP_ERRORHANDLER SYNONYM INVALID WB_RTV_DP_FDVALUES SYNONYM INVALID WB_RTV_DP_FKCARDINALITY SYNONYM INVALID WB_RTV_DP_FKCONFIG SYNONYM INVALID WB_RTV_DP_FKVALUES SYNONYM INVALID WB_RTV_DP_FKVALUES_V SYNONYM INVALID WB_RTV_DP_PARTITION_METADATA SYNONYM INVALID WB_RTV_DP_PATTERNVALUES SYNONYM INVALID WB_RTV_DP_RDNTVALUES SYNONYM INVALID WB_RTV_DP_TABLEINFO SYNONYM INVALID WB_RTV_DP_TABLESTATS SYNONYM INVALID WB_RT_CONCAT SYNONYM INVALID WB_RT_CONSTANTS SYNONYM INVALID WB_RT_CONVERSIONS SYNONYM INVALID WB_RT_DQ SYNONYM INVALID WB_RT_GETERROR SYNONYM INVALID WB_RT_GETERRORWITHNAME SYNONYM INVALID WB_RT_GETPARTITIONPROPERTIES SYNONYM INVALID WB_RT_GET_ELAPSED_TIME SYNONYM INVALID WB_RT_GET_JOB_METRICS SYNONYM INVALID WB_RT_GET_LAST_EXECUTION_TIME SYNONYM INVALID WB_RT_GET_MAP_RUN_AUDIT_ID SYNONYM INVALID WB_RT_GET_NUMBER_OF_ERRORS SYNONYM INVALID WB_RT_GET_NUMBER_OF_WARNINGS SYNONYM INVALID WB_RT_GET_PARENT_AUDIT_ID SYNONYM INVALID WB_RT_GET_RETURN_CODE SYNONYM INVALID WB_RT_GET_START_TIME SYNONYM INVALID WB_RT_INTEGER_VERSION_NUMBER SYNONYM INVALID WB_RT_IS_PLATFORM_REPOSITORY SYNONYM INVALID WB_RT_MAPAUDIT SYNONYM INVALID WB_RT_MAPAUDIT_UTIL SYNONYM INVALID WB_RT_MAPAUDIT_UTIL_INVOKER SYNONYM INVALID WB_RT_MINIMUM_SERVICE_VERSION SYNONYM INVALID WB_RT_MODE SYNONYM INVALID WB_RT_MODE_CNT SYNONYM INVALID WB_RT_PATTERN_ANALYSIS SYNONYM INVALID WB_RT_PROFILE_SERVICE SYNONYM INVALID WB_RT_SCRIPTPROCESSOR SYNONYM INVALID WB_RT_STATE_VARIABLE SYNONYM INVALID WB_RT_TASK_VARIABLE SYNONYM INVALID WB_RT_TF_MAP_OPERATIONS SYNONYM INVALID WB_RT_TRANSACTION_HANDLER SYNONYM INVALID WB_RT_UPDATEPROPERTIES SYNONYM INVALID WB_TO_DATE SYNONYM INVALID WB_TO_NUMBER SYNONYM INVALID WB_TRUNCATE_TABLE SYNONYM INVALID WB_WEEK_OF_MONTH SYNONYM INVALID WB_XML_LOAD SYNONYM INVALID WB_XML_LOAD_F SYNONYM INVALID ATBI_RDS AGGREGATION_REPORT_VW VIEW INVALID BKP_RDS_DLY_ACTVTY_SMRY_LD PACKAGE BODY INVALID FINANCE_REVENUE_REPORT VIEW INVALID GET_ACTIVITY_TYPE FUNCTION INVALID LD_MNTHLY_ACTVTY_SMRY PROCEDURE INVALID LD_MNTH_INT_CLS_SMRY PROCEDURE INVALID LD_RDS_VS_RV_BRKP_SMRY PROCEDURE INVALID NEW_LD_MNTHLY_ACTVTY_SMRY PROCEDURE INVALID P_DEL_DLY_ACTVTY_SMRY PROCEDURE INVALID RDS_ACTVTY_CB_LD PACKAGE BODY INVALID RDS_DLY_ACTVTY_SMRY_LD_TMP PACKAGE BODY INVALID RDS_MNTHLY_ACTVTY_SMRY_LD PACKAGE BODY INVALID RDS_MNTHLY_CL_LNGTH_CB_LD PACKAGE BODY INVALID RDS_MNTHLY_INT_CLS_SMRY_LD PACKAGE BODY INVALID RDS_MNTHLY_STSTCS_FACT_LD PACKAGE BODY INVALID RDS_TOPUP_CB_LD PACKAGE BODY INVALID RDS_VOICE_SMS_RV_BRKP_SMRY_LD PACKAGE BODY INVALID REVENUE_REPORT MATERIALIZED VIEW INVALID ROAMING_DETAIL_REPORT VIEW INVALID VAS_GPRS VIEW INVALID VAS_IVR VIEW INVALID VAS_MMS VIEW INVALID VAS_SMS VIEW INVALID ATBI_RPSTR FILES_DUPLICATION_CHECK PACKAGE INVALID FILES_DUPLICATION_CHECK PACKAGE BODY INVALID FILES_SEQ_CHECK_PROC PACKAGE INVALID FILES_SEQ_CHECK_PROC PACKAGE BODY INVALID FLS_DPLCTN_CHCK PACKAGE INVALID FLS_DPLCTN_CHCK PACKAGE BODY INVALID FLS_MSNG_SQNC_CHCK PACKAGE INVALID FLS_MSNG_SQNC_CHCK PACKAGE BODY INVALID GET_BATCH_STATUS FUNCTION INVALID GET_clsd_BSN_DT FUNCTION INVALID IN_CDR_DPLCTN_CHCK PACKAGE INVALID IN_CDR_DPLCTN_CHCK PACKAGE BODY INVALID IN_CDR_SQNCS_LD PACKAGE INVALID IN_CDR_SQNCS_LD PACKAGE BODY INVALID IN_MSNG_SQNC_CHCK PACKAGE INVALID IN_MSNG_SQNC_CHCK PACKAGE BODY INVALID RECONCILIATION_UTILITY PACKAGE BODY INVALID ATBI_TDS BKPTDS_SBSCRBR_DATA_LO_3 PACKAGE INVALID BKPTDS_SBSCRBR_DATA_LO_3 PACKAGE BODY INVALID CHR_P1_CDR_FL_PRCNG PACKAGE BODY INVALID CHR_P2_CDR_FL_PRCNG PACKAGE BODY INVALID CLD_OPR FUNCTION INVALID CONSOLIDATED_ADS PROCEDURE INVALID COPY_OF_CRG_LD_MT_PREPAID_C_4 PACKAGE INVALID COPY_OF_CRG_LD_MT_PREPAID_C_4 PACKAGE BODY INVALID COPY_OF_CRG_LD_MT_PREPAID_S_3 PACKAGE INVALID COPY_OF_CRG_LD_MT_PREPAID_S_3 PACKAGE BODY INVALID COPY_OF_CRG_LD_MT_PREPAID_S_4 PACKAGE INVALID COPY_OF_CRG_LD_MT_PREPAID_S_4 PACKAGE BODY INVALID COPY_OF_CRG_LD_VAS_SCR PACKAGE INVALID COPY_OF_CRG_LD_VAS_SCR PACKAGE BODY INVALID COPY_OF_LD_MT_PSTN_PREPOST PACKAGE INVALID COPY_OF_LD_MT_PSTN_PREPOST PACKAGE BODY INVALID CRG_LD_MMSGRPS_SCR PACKAGE INVALID CRG_LD_MMSGRPS_SCR PACKAGE BODY INVALID CRG_LD_MT_PRETPAID_SMS_SRC PACKAGE INVALID CRG_LD_MT_PRETPAID_SMS_SRC PACKAGE BODY INVALID CRG_LD_P1_CDR PACKAGE BODY INVALID CRG_LD_P2_CDR PACKAGE BODY INVALID CRG_LD_P3_CDR PACKAGE BODY INVALID CRG_LD_P4_CDR PACKAGE BODY INVALID CRG_LD_P5_CDR PACKAGE BODY INVALID CRG_LD_VAS_SCR PACKAGE INVALID CRG_LD_VAS_SCR PACKAGE BODY INVALID CRG_TDS_LD_VAS_PREPAID PACKAGE INVALID CRG_TDS_LD_VAS_PREPAID PACKAGE BODY INVALID CRG_TDS_MMSGPRS_PREPAID PACKAGE INVALID CRG_TDS_MMSGPRS_PREPAID PACKAGE BODY INVALID DELCDR27AUG PROCEDURE INVALID DELETE_CHAR_COL_MTCALL_PREP PROCEDURE INVALID DELETE_CHAR_COL_MTSMS_PREP PROCEDURE INVALID DEL_19JULY_PROC PROCEDURE INVALID DEL_PREPAID_PROC PROCEDURE INVALID DEL_PREPAID_PROC1 PROCEDURE INVALID DLMT_REC_JOB PACKAGE INVALID DLMT_REC_JOB PACKAGE BODY INVALID FIX_LNGTH_REC_JOB PACKAGE INVALID FIX_LNGTH_REC_JOB PACKAGE BODY INVALID GET_ATHEER_OPERATORS FUNCTION INVALID HIST_LD_CDR_MAP PACKAGE BODY INVALID HST_CRG_LD_MMSGRPS_SCR PACKAGE INVALID HST_CRG_LD_MMSGRPS_SCR PACKAGE BODY INVALID HST_CRG_LD_MT_PREPAID_CALLS PACKAGE INVALID HST_CRG_LD_MT_PREPAID_CALLS PACKAGE BODY INVALID HST_CRG_LD_MT_PREPAID_SMS PACKAGE INVALID HST_CRG_LD_MT_PREPAID_SMS PACKAGE BODY INVALID HST_CRG_LD_VAS_SCR PACKAGE INVALID HST_CRG_LD_VAS_SCR PACKAGE BODY INVALID HST_LD_INTRNT_POSTPAID_VOICE PACKAGE INVALID HST_LD_INTRNT_POSTPAID_VOICE PACKAGE BODY INVALID HST_LD_MT_POSTPAID_SMS_SRC PACKAGE INVALID HST_LD_MT_POSTPAID_SMS_SRC PACKAGE BODY INVALID HST_LD_POSTPAID_GPRSMMS PACKAGE INVALID HST_LD_POSTPAID_GPRSMMS PACKAGE BODY INVALID HST_LD_POSTPAID_SMS_SRC PACKAGE INVALID HST_LD_POSTPAID_SMS_SRC PACKAGE BODY INVALID HST_LD_POSTPAID_VASD_SRC PACKAGE INVALID HST_LD_POSTPAID_VASD_SRC PACKAGE BODY INVALID HST_LD_POSTPAID_VOICE_SRC PACKAGE INVALID HST_LD_POSTPAID_VOICE_SRC PACKAGE BODY INVALID INSERTCDR15JULY10 PROCEDURE INVALID INSERTPART PROCEDURE INVALID INSERTTEMPCDR PROCEDURE INVALID INSERTTEMPCDRAUG2010 PROCEDURE INVALID INSERT_ACUBEHIST PROCEDURE INVALID INSERT_ACUBEHIST22AUG PROCEDURE INVALID IN_CDR_FL_PRCNG PACKAGE BODY INVALID LD_CRG_DATES PROCEDURE INVALID LD_CRM_USER_INFO PACKAGE INVALID LD_CRM_USER_INFO PACKAGE BODY INVALID LD_POSTPAID_GPRSMMS_SRC_MAP PACKAGE INVALID LD_POSTPAID_GPRSMMS_SRC_MAP PACKAGE BODY INVALID LD_RVNU_BRKP_SMRY PROCEDURE INVALID LOADING_HIST_DATA PACKAGE BODY INVALID MISSING_DATA_LOAD_MAP PACKAGE BODY INVALID NEW_LD_POSTPAID_VOICE_DATA PACKAGE BODY INVALID ORG_CDR_REC_LD_JB PACKAGE INVALID ORG_CDR_REC_LD_JB PACKAGE BODY INVALID P1_SMS_FL_PRCNG PACKAGE BODY INVALID PDELHISTOCT PROCEDURE INVALID P_APR_RECONCILATION PROCEDURE INVALID P_DEL_ACTVTY_CUBE_DATA PROCEDURE INVALID P_DEL_ACTVTY_CUBE_HIST PROCEDURE INVALID P_DEL_CDR_DATA PROCEDURE INVALID P_LC_DETAILS_HIST_MISSING_DATA PROCEDURE INVALID P_LC_DETAILS_HIST_TEST PROCEDURE INVALID P_LOAD_CDR_TEMP_DATA PROCEDURE INVALID P_LOAD_CDR_TEMP_DATA2 PROCEDURE INVALID P_LOAD_CDR_TEMP_DATA3 PROCEDURE INVALID P_LOAD_MISS_LC_DET_DATA PROCEDURE INVALID P_UPDATE_LC_DETAILS_HIST_DATA PROCEDURE INVALID RECONCILE_CAT_DATA PACKAGE INVALID RECONCILE_CAT_DATA PACKAGE BODY INVALID RECON_VIEWS PACKAGE BODY INVALID REVERSE_ATHEER_FLOW PACKAGE BODY INVALID TABS_DATA PACKAGE BODY INVALID TDS_IN_CDR_LOC_UPDATE PACKAGE INVALID TDS_IN_CDR_LOC_UPDATE PACKAGE BODY INVALID TDS_IN_PREPAID_ORG_CDR_LD PACKAGE INVALID TDS_IN_PREPAID_ORG_CDR_LD PACKAGE BODY INVALID TDS_IN_SBSCRBR_INFO_LD PACKAGE INVALID TDS_IN_SBSCRBR_INFO_LD PACKAGE BODY INVALID TDS_LD_POSTPAID_GPRSMMS_DATA PACKAGE INVALID TDS_LD_POSTPAID_GPRSMMS_DATA PACKAGE BODY INVALID TDS_NTNL_RMNG_MAP PACKAGE BODY INVALID TDS_P1_PREPAID_ORG_SMS_LD PACKAGE INVALID TDS_P1_PREPAID_ORG_SMS_LD PACKAGE BODY INVALID TDS_P2_PREPAID_ORG_SMS_LD PACKAGE INVALID TDS_P2_PREPAID_ORG_SMS_LD PACKAGE BODY INVALID TDS_POSTPAID_CDR_MAP PACKAGE BODY INVALID TDS_SBSCRBR_DATA_LOAD_MAP PACKAGE INVALID TDS_SBSCRBR_DATA_LOAD_MAP PACKAGE BODY INVALID TDS_SBSCRBR_SRVC_FEE_LD PACKAGE INVALID TDS_SBSCRBR_SRVC_FEE_LD PACKAGE BODY INVALID TEST_BATCH PACKAGE BODY INVALID TEST_CHARGEONCE PACKAGE BODY INVALID TEST_DELETE PROCEDURE INVALID TEST_P2_CDR_FL_PRCNG PACKAGE BODY INVALID TEST_TDS_P2_PREPAID_ORG__3 PACKAGE INVALID TEST_TDS_P2_PREPAID_ORG__3 PACKAGE BODY INVALID TKNORT_RAWMSISDN PACKAGE BODY INVALID UAT_CALL_TYPE FUNCTION INVALID UPDATE_INCDR_LOC_ID PROCEDURE INVALID UPD_INCDR_CNTRY_CD PROCEDURE INVALID ATHEERDBA COLUMN_UPDATION PROCEDURE INVALID COLUMN_VALIDATION PROCEDURE INVALID FILES_COMPARISON PROCEDURE INVALID P1 PROCEDURE INVALID P_DEL_ACTVTY_CUBE_DATA PROCEDURE INVALID P_LC_DETAILS PROCEDURE INVALID P_LC_DETAILS_MAIN PROCEDURE INVALID P_LOAD_LC_DATA1 PROCEDURE INVALID P_MAIN PROCEDURE INVALID BILAL ALTERIND PROCEDURE INVALID CAT_NAMES_LOADING PROCEDURE INVALID CAT_PROC PROCEDURE INVALID DAILY_BATCH_OPEN PROCEDURE INVALID DAILY_RECONCILATION PROCEDURE INVALID FILES_COMPARISON PROCEDURE INVALID FILES_COMPARISON_JUNE PROCEDURE INVALID LOAD_MONTHLY_UET_TABLE PROCEDURE INVALID RDS_RECONCILATION PROCEDURE INVALID RECONSILATION_RDS PROCEDURE INVALID ROAMINGTABSVIEW_RECONCILATION PROCEDURE INVALID TABSDATA_RECONCILATION PROCEDURE INVALID TABSVIEW_RECONCILATION PROCEDURE INVALID VAS_RECONCILATION PROCEDURE INVALID FRAJA EUL5_NAMED_ELEMS VIEW INVALID MKHAN ADJUSTED_DATA PROCEDURE INVALID BACKUP_MMS_RATE_23JUN FUNCTION INVALID BKP_P_LC_DETAILS PROCEDURE INVALID GET_COUNTRY FUNCTION INVALID GET_DORM_SMRY PROCEDURE INVALID LOAD_SUBSCRIBER PROCEDURE INVALID OSC_VAS_UPD FUNCTION INVALID TEST_GET_MONTHLY_CALL_LENGHT PROCEDURE INVALID T_GET_MONTHLY_CALL_LENGHT_CUBE PROCEDURE INVALID MYAHYA COLUMN_VALIDATION PROCEDURE INVALID DBM_TAP_IN_TEST PROCEDURE INVALID GET_ACTVTY_TYPE FUNCTION INVALID GET_TABS_DATA PACKAGE BODY INVALID LC_DETAILS_JUL_DIFF PROCEDURE INVALID LOADING_HIST_DATA PACKAGE BODY INVALID MISSING_LC_DETAILS_HIST_DATE PROCEDURE INVALID P_CDR_P1_TMP_PHASE_1 PROCEDURE INVALID P_CREATE_BTMP_INDEX PROCEDURE INVALID P_DBM_CDR_HEAD PROCEDURE INVALID P_GET_SOURCE_FILES_INFO PROCEDURE INVALID P_LC_DETAILS_HIST_DATA PROCEDURE INVALID P_LC_DETAILS_HIST_TEST PROCEDURE INVALID P_LOAD_CDR_HIST PROCEDURE INVALID P_LOAD_DAILY_SUBSCRIBER_DATA PROCEDURE INVALID P_LOAD_DLY_ACTVTY_SMRY_DATA PROCEDURE INVALID P_LOAD_HIST_DATA PROCEDURE INVALID P_LOAD_LC_DETAILS_HIST_DATA PROCEDURE INVALID P_MISS_LC_DETAILS_HIST PROCEDURE INVALID P_MISS_LC_DETAIL_HIST PROCEDURE INVALID P_MISS_LC_DETAIL_HIST1 PROCEDURE INVALID P_PREPAID_SMS_DATA PROCEDURE INVALID P_UPDATE_ACTVTY_CUBE_HIST PROCEDURE INVALID P_UPDATE_LC_DETAILS_HIST_DATA PROCEDURE INVALID RECONCILE_CAT_DATA PACKAGE INVALID RECONCILIATION PACKAGE BODY INVALID REVERSE_ATHEER_FLOW PACKAGE BODY INVALID PUBLIC CDR SYNONYM INVALID CDR_POST_PAID SYNONYM INVALID CRG_EDR SYNONYM INVALID DBMS_XSLPROCESSOR SYNONYM INVALID UAT_CAT_SRC SYNONYM INVALID UAT_CDR SYNONYM INVALID UAT_CDR_CAT SYNONYM INVALID UAT_EDR_CFT SYNONYM INVALID UAT_SRC_CFT SYNONYM INVALID SYS COLUMN_UPDATION PROCEDURE INVALID COLUMN_VALIDATION PROCEDURE INVALID P_CDR_HEAD PROCEDURE INVALID P_LOAD_LC_DATA1 PROCEDURE INVALID UFAROOQ ACTVTY_DIM_GPRS VIEW INVALID AGGREGATION_REPORT VIEW INVALID DWH_MONTHLY_LOAD PROCEDURE INVALID GET_LOADING_DT FUNCTION INVALID OPERATOR_DETAILS_VW VIEW INVALID UAT_LOAD_WEEK1_CRG PROCEDURE INVALID VAS_SMSGPRS VIEW INVALID USALEEM NSN_REPORT PROCEDURE INVALID XDB DBMS_XSLPROCESSOR PACKAGE BODY INVALID RDBMS INSTANCE PARAMETERS ========================= NAME VALUE ------------------------------------------------ --------------- aq_tm_processes 0 cluster_database FALSE cluster_database_instances 1 compatible 10.2.0.3.0 db_block_size 16384 db_cache_size 0 db_writer_processes 2 dbwr_io_slaves 0 disk_asynch_io TRUE java_pool_size 0 job_queue_processes 10 large_pool_size 0 lock_sga FALSE log_buffer 4194304 log_checkpoint_timeout 1800 o7_dictionary_accessibility FALSE open_cursors 300 optimizer_mode ALL_ROWS parallel_adaptive_multi_user TRUE parallel_automatic_tuning FALSE pga_aggregate_target 12884901888 query_rewrite_enabled TRUE remote_login_passwordfile EXCLUSIVE resource_manager_plan service_names mtcedwp sga_target 4294967296 shared_pool_size 0 statistics_level TYPICAL undo_management AUTO utl_file_dir workarea_size_policy AUTO aq_tm_processes value is 0 Should be >= 1 RDBMS DATABASE PARAMETERS ========================= PARAMETER VALUE ------------------------------ ----------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 10.2.0.3.0 RDBMS DBA_JOBS ============== SCHEMA_USER WHAT LAST_DATE NEXT_DATE --------------- -------------------------------------------------- -------------------- -------------------- ATBI_OWBOWNER wb_rti_service_job.check_service(1); 10-MAY-2011 07:24:19 10-MAY-2011 07:30:19 ATBI_RPSTRY ATBI_RPSTRY.RECONCILIATION_UTILITY.LOAD_RECONCILE_ 01-JAN-4000 00:00:00 DETAILS_CAT (TEMP /* VARCHAR2 */ ); OWF_MGR FND_SVC_COMPONENT.EXECUTE_REQUEST (p_component_req 09-MAY-2011 11:51:11 10-MAY-2011 11:51:11 uest_id => 1); OWF_MGR declare errbuf varchar2(4000); retcode varchar2(40 10-MAY-2011 03:43:48 10-MAY-2011 07:43:48 00); begin WF_BES_CLEANUP.CLEANUP_SUBSCRIBERS(errb uf, retcode); end; UFAROOQ begin 09-MAY-2011 15:01:12 10-MAY-2011 15:01:12 ATBI_RPSTRY.reconciliation_utility.EXECUTE_RECONCI LE_DAILY_TAB; end; UFAROOQ begin 10-MAY-2011 04:59:03 10-MAY-2011 08:59:03 ATBI_RPSTRY.reconciliation_utility.EXECUTE_RECONCI LE_DAILY_RDS; End; UFAROOQ begin 06-MAY-2011 00:00:03 13-MAY-2011 00:00:00 ATBI_RPSTRY.reconciliation_utility.Execute_RECONCI LE_MISSING_TABS; end; UFAROOQ begin 10-MAY-2011 01:00:01 11-MAY-2011 01:00:00 update atbi_rpstry.execution_logs v set v.status = 'Broken',v.end_time = sysdate where v.status = 'START' and (sysdate - start_time)*86400/60/60 > 48; commit; end; - Number of jobs scheduled in DBA_JOBS: 8 / Value of job_queue_processes: 10 RDBMS DBA_JOBS_RUNNING ====================== - No jobs running at 10-may-2011 07:28:48 eos (end of section) SQL> spool off