Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.90147_CLOUD_387416_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-09-27 21:41:38 The following directories are used: CMiC Home: "/opt/cm", as specified in /home/oracle/.cms/cms.conf. Oracle Home: "D:/as10g2/midtier", default value. JSP Oracle Home: "/u01/app/oracle/midtierjsp", as specified in /home/oracle/.cms/cms.conf. Mobile Oracle Home: "/u01/app/oracle/midtiermobile", as specified in /home/oracle/.cms/cms.conf. Oracle Client Home: "/u01/app/oracle/product/19.19/PROD", as specified in /home/oracle/.cms/cms.conf. /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc7.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc6.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc8.jar Connection string: jdbc:oracle:oci:da/********@test - File: sql/2490147_1.sql: __________________________ Updating: /opt/cm/v12/test/sql/2490147_1.sql - This is a new file, no information available on disk - size (new file): 7510 bytes - last modified (new file): 2024-09-27 11:43:28.0 - File: sql/NOR0001_BUDGSUM_20240927.sql: _________________________________________ Updating: /opt/cm/v12/test/sql/NOR0001_BUDGSUM_20240927.sql - This is a new file, no information available on disk - size (new file): 13599 bytes - last modified (new file): 2024-09-27 11:43:28.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-09-27_21_41_39.146/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-09-27_21_41_39.146/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-09-27_21_41_39.146/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2490147_1.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-09-27_21_41_39.146/2490147_1.sql.sh to run 2490147_1.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-09-27_21_41_39.146/2490147_1.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-09-27_21_41_39.146/2490147_1.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 27 21:42:04 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 24.90147, Work Item 1 -- New Views NOR0001_BUDGSUM -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2490147_1.sql Output in 2490147_1.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== PL/SQL procedure successfully completed. Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 9,580 INDEX 57,752 INDEX PARTITION 340 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 9,948 TABLE 38,016 TABLE PARTITION 28,779 22 TRIGGER 266 TYPE 16,206 12 VIEW -------- ********** -------- 169,216 sum 35 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 3,237 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 4,846 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 11,609 8 VIEW -------- ********** -------- 11,644 sum 8 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 394 VIEW -------- ********** -------- 549 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 196,356 44 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-09-27 21:42:25 special list (before special recompiling) 2024-09-27 21:42:25 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-09-27 21:42:27 special list (after special recompiling) 2024-09-27 21:42:28 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 9,580 INDEX 57,752 INDEX PARTITION 340 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 9,948 TABLE 38,016 TABLE PARTITION 28,779 22 TRIGGER 266 TYPE 16,206 12 VIEW -------- ********** -------- 169,216 sum 35 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 3,237 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 4,846 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 11,609 8 VIEW -------- ********** -------- 11,644 sum 8 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 394 VIEW -------- ********** -------- 549 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 196,356 44 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401K7JYA_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_EMP_AVAILFLT3_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_INVRGCODED7JYA_OBJSE DA TRIGGER DBTI_UETD_INVRGCODEDFLT3_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE7JYA_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_I_IUD_CHKDISTKOFX_FATVIEW DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_CHKDISTKOFX_FATVIEW DA VIEW UETD_CHKDISTKOFX_OUTER_VIEW DA VIEW UETD_CHKDISTKOFX_VIEW DA VIEW UETD_EMP_AVAILKOFX_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW DA VIEW UETD_EMP_AVAILKOFX_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 27-SEP-24 09.42.30.357942 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-04e SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install VWT files or Create Synonyms for TN tables -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install or Update System Data -- ====================================================================== . . . -- ========================================================================================== -- ===== Started: NOR0001_BUDGSUM_20240927.sql -- ========================================================================================== . -- ====================================================================== -- ===== -- ===== STEP 0a: DA grants to CMIC_REPORT_VIEWS with grant option -- ===== -- ====================================================================== . -- =================================================================================== -- ===== -- ===== STEP 0b: CMIC_REPORT_VIEWS grants to CMIC_REPORT_WRITER with grant option -- ===== -- =================================================================================== . -- ====================================================================== -- ===== -- ===== STEP 2: CREATE ANY REQUIRED CMIC_REPORT_WRITER VIEWS -- ===== -- ====================================================================== . -- ====================================================================== -- ===== package spec: CMIC_REPORT_WRITER.DBK_NOR0001_BUDGSUM -- ====================================================================== .------------------------------------------------------- prompt -- ===== DDL for Package DBK_NOR0014_CONTFCST ------------------------------------------------------- GRANT EXECUTE ON "CMIC_REPORT_WRITER"."DBK_NOR0001_BUDGSUM" TO "DA" WITH GRANT OPTION * ERROR at line 1: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself . -- ====================================================================== -- ===== package body: CMIC_REPORT_WRITER.DBK_NOR0001_BUDGSUM -- ====================================================================== . -- ====================================================================== -- ===== view: CMIC_REPORT_WRITER.NOR0001_BUDGSUM_VW -- ====================================================================== SP2-0734: unknown command beginning "left outer..." - rest of line ignored. SP2-0734: unknown command beginning "ON phs.JH..." - rest of line ignored. SP2-0734: unknown command beginning "AND phs.J..." - rest of line ignored. SP2-0734: unknown command beginning "AND phs.j..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning "WHERE pcs...." - rest of line ignored. SP2-0734: unknown command beginning "AND pcs.J..." - rest of line ignored. SP2-0042: unknown command "GROUP BY" - rest of line ignored. SP2-0734: unknown command beginning "pcs.COMPAN..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", c.COMP_L..." - rest of line ignored. SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. SP2-0734: unknown command beginning ", cust.CUS..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. SP2-0042: unknown command ", 'H'" - rest of line ignored. SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. SP2-0042: unknown command ", 'H'" - rest of line ignored. SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. SP2-0042: unknown command ", 'Y'" - rest of line ignored. SP2-0734: unknown command beginning ", CATEGOR..." - rest of line ignored. SP2-0042: unknown command ", NULL)" - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. SP2-0042: unknown command ", 'Y'" - rest of line ignored. SP2-0734: unknown command beginning ", CATEGOR..." - rest of line ignored. SP2-0042: unknown command ", NULL)" - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. SP2-0734: unknown command beginning "ORDER BY ..." - rest of line ignored. SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. SP2-0042: unknown command ", 'H'" - rest of line ignored. SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. SP2-0042: unknown command ", 'Y'" - rest of line ignored. SP2-0734: unknown command beginning ", CATEGOR..." - rest of line ignored. SP2-0044: For a list of known commands enter HELP and to leave enter EXIT. SP2-0042: unknown command ", NULL)" - rest of line ignored. 1 CREATE OR REPLACE VIEW CMIC_REPORT_WRITER.NOR0001_BUDGSUM_VW( 2 COMPANY_CODE 3 , COMP_LOGO 4 , JOB_CODE 5 , JOB_NAME 6 , CUST_NAME 7 , PHASE_CODE 8 , PHASE_NAME 9 , CATEGORY_CODE 10 , CATEGORY_NAME 11 , CONTRACTOR_CODE 12 , CONTRACTOR_NAME 13 , REVENUE_ORIGINAL_BUDGET 14 , REVENUE_CHG_ORD_EXTERNAL 15 , REVENUE_CHG_ORD_INT_EXT 16 , REVENUE_CURRENT_BUDGET 17 , REVENUE_PREPENDING_CHG_ORD 18 , REVENUE_PENDING_CHG_ORD 19 , REVENUE_PROJECTED 20 , REVENUE_CHG_ORD_PROCEEDING 21 , REVENUE_CHG_ORD_NON_PROCEEDING 22 ) 23 AS 24 ----------------------------------------------------------------------------------------- 25 -- DDL for View CMIC_REPORT_WRITER.NOR0001_BUDGSUM_VW 26 -- Author: Anne Krainer,Impact Integrated Technology Inc. 27 -- Date: 2024-07-29 28 -- Purpose: Field's Budget and Cost Status Query Rolled up by ctrl phase/category 29 ------------------------------------------------------------------------------------------ 30 WITH CONTRACTOR_NAMES AS ( 31 select DISTINCT 32 JBCD_COMP_CODE 33 --, JBCD_CONT_CODE 34 , jbcd_bill_job_code 35 , JBCD_BILL_PHS_CODE 36 , JBCD_BILL_CAT_CODE 37 , DECODE(JBCD_SELF_PERFORMED_INV_FLAG, 'Y', JBCD_COMP_CODE, JBCD_VEN_CODE) JBCD_CONTRACTOR_CODE 38 , DECODE(JBCD_SELF_PERFORMED_INV_FLAG, 'Y', COMP_NAME,NVL(BP.BP_AKA_NAME,BP.BP_NAME) ) AS JBCD_CONTRACTOR_NAME --same as PM meeting minutes/notes 39 FROM cmic_report_views.jbcontdet 40 JOIN cmic_report_views.company ---company_by_tenant_v 41 ON JBCD_COMP_CODE = COMP_CODE 42 LEFT OUTER JOIN CMIC_REPORT_VIEWS.BPVENDORS 43 ON JBCD_COMP_CODE = BPVEN_COMP_CODE 44 AND JBCD_VEN_CODE = BPVEN_BP_CODE 45 LEFT OUTER JOIN CMIC_REPORT_VIEWS.BPARTNERS BP 46 ON BPVEN_BP_CODE = BP_CODE 47 WHERE JBCD_COMP_CODE = sys_context('CMIC', 'P_COMP_CODE') 48 AND jbcd_bill_job_code = sys_context('CMIC', 'P_JOB_CODE') 49 order by 50 JBCD_COMP_CODE 51 --, JBCD_CONT_CODE 52 , jbcd_bill_job_code 53 , JBCD_BILL_PHS_CODE 54 , JBCD_BILL_CAT_CODE 55 ) 56 SELECT 57 pcs.COMPANY_CODE 58 , c.COMP_LOGO_FILE_ON_WEB AS COMP_LOGO 59 , pcs.JOB_CODE 60 , pcs.JOB_NAME 61 , cust.CUST_NAME 62 , DECODE(sys_context('CMIC', 'P_PHS_LVL' ) 63 , 'H' 64 , DECODE(phs.jhp_ctrl_code, 'ALL', phs.jhp_code, phs.jhp_ctrl_code) 65 , phs.jhp_code) 66 AS Ctrl_or_Phase_Code 67 , DECODE(sys_context('CMIC', 'P_PHS_LVL' ) 68 , 'H' 69 , DECODE(phs.jhp_ctrl_code, 'ALL', phs.jhp_name, ctrl.jhp_name) 70 , phs.jhp_name) 71 AS Ctrl_or_Phase_Name 72 , DECODE(sys_context('CMIC', 'P_DISP_CAT' ) 73 , 'Y' 74 , CATEGORY_CODE 75 , NULL) 76 AS Category_Code 77 , DECODE(sys_context('CMIC', 'P_DISP_CAT' ) 78 , 'Y' 79 , CATEGORY_NAME 80 , NULL) 81 AS CATEGORY_NAME 82 , JBCD_CONTRACTOR_CODE 83 , JBCD_CONTRACTOR_NAME 84 , SUM(NVL(REVENUE_ORIGINAL_BUDGET,0)) REVENUE_ORIGINAL_BUDGET 85 , SUM(NVL(REVENUE_CHG_ORD_EXTERNAL,0)) REVENUE_CHG_ORD_EXTERNAL 86 , SUM(NVL(COST_CHG_ORD_INTERNAL_TRANSFER,0)) REVENUE_CHG_ORD_INT_EXT 87 , SUM(NVL(REVENUE_CURRENT_BUDGET,0)) REVENUE_CURRENT_BUDGET 88 , SUM(NVL(REVENUE_PREPENDING_CHG_ORD,0)) REVENUE_PREPENDING_CHG_ORD 89 , SUM(NVL(REVENUE_PENDING_CHG_ORD,0)) REVENUE_PENDING_CHG_ORD 90 , SUM(NVL(REVENUE_PROJECTED,0)) REVENUE_PROJECTED 91 , SUM(NVL(REVENUE_CHG_ORD_PROCEEDING,0)) REVENUE_CHG_ORD_PROCEEDING 92 ,SUM(NVL(REVENUE_CHG_ORD_NON_PROCEEDING,0)) REVENUE_CHG_ORD_NON_PROCEEDING 93 from cmic_report_views.jc_job_phs_cat_summary pcs 94 JOIN cmic_report_views.company c 95 ON pcs.COMPANY_CODE = c.comp_code 96 JOIN cmic_report_views.jcjob j --security view 97 ON pcs.COMPANY_CODE = j.JOB_COMP_CODE 98 AND pcs.JOB_CODE = j.JOB_CODE 99 LEFT OUTER JOIN cmic_report_views.customer cust 100 ON j.job_cust_code = cust.cust_code 101 LEFT OUTER JOIN CONTRACTOR_NAMES 102 ON pcs.COMPANY_CODE = JBCD_COMP_CODE 103 AND pcs.JOB_CODE = JBCD_BILL_JOB_CODE 104 AND pcs.PHASE_CODE = JBCD_BILL_PHS_CODE 105 AND pcs.CATEGORY_CODE = JBCD_BILL_CAT_CODE 106 join cmic_report_views.JCJOBHPHS phs 107 ON pcs.COMPANY_CODE = phs.JHP_COMP_CODE 108 AND pcs.JOB_CODE = phs.JHP_JOB_CODE 109* AND pcs.PHASE_CODE = phs.jhp_code , DECODE(phs.jhp_ctrl_code, 'ALL', phs.jhp_name, ctrl.jhp_name) * ERROR at line 69: ORA-00904: "CTRL"."JHP_NAME": invalid identifier . -- ====================================================================== -- ===== show errors view CMIC_REPORT_WRITER.NOR0001_BUDGSUM_VW -- ====================================================================== No errors. . -- ====================================================================== -- ===== grants CMIC_REPORT_WRITER.NOR0001_BUDGSUM_VW -- ====================================================================== GRANT READ ON CMIC_REPORT_WRITER.NOR0001_BUDGSUM_VW TO DA WITH GRANT OPTION * ERROR at line 1: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself . -- ========================================================================================== -- ===== Completed: NOR0001_BUDGSUM_20240927.sql -- ========================================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Get the current State of the Database -- ====================================================================== -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 9,580 INDEX 57,752 INDEX PARTITION 340 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 9,948 TABLE 38,016 TABLE PARTITION 28,779 22 TRIGGER 266 TYPE 16,206 12 VIEW -------- ********** -------- 169,216 sum 35 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 3,237 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 4,846 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 11,609 8 VIEW -------- ********** -------- 11,644 sum 8 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 394 VIEW -------- ********** -------- 549 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 196,356 44 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-09-27 21:42:52 special list (before special recompiling) 2024-09-27 21:42:52 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-09-27 21:42:54 special list (after special recompiling) 2024-09-27 21:42:55 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 9,580 INDEX 57,752 INDEX PARTITION 340 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 9,948 TABLE 38,016 TABLE PARTITION 28,779 22 TRIGGER 266 TYPE 16,206 12 VIEW -------- ********** -------- 169,216 sum 35 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 3,237 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 4,846 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 11,609 8 VIEW -------- ********** -------- 11,644 sum 8 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 394 VIEW -------- ********** -------- 549 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 196,356 44 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401K7JYA_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_EMP_AVAILFLT3_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_INVRGCODED7JYA_OBJSE DA TRIGGER DBTI_UETD_INVRGCODEDFLT3_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE7JYA_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_I_IUD_CHKDISTKOFX_FATVIEW DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_CHKDISTKOFX_FATVIEW DA VIEW UETD_CHKDISTKOFX_OUTER_VIEW DA VIEW UETD_CHKDISTKOFX_VIEW DA VIEW UETD_EMP_AVAILKOFX_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW DA VIEW UETD_EMP_AVAILKOFX_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 27-SEP-24 09.42.56.908798 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-04e SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2490147_1.sql completed. Output in 2490147_1.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.90147 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 31 Informative Errors: 3 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- 563 | -- ===== view: CMIC_REPORT_WRITER.NOR0001_BUDGSUM_VW 564 | -- ====================================================================== 565 | SP2-0734: unknown command beginning "left outer..." - rest of line ignored. 566 | SP2-0734: unknown command beginning "ON phs.JH..." - rest of line ignored. 564 | -- ====================================================================== 565 | SP2-0734: unknown command beginning "left outer..." - rest of line ignored. 566 | SP2-0734: unknown command beginning "ON phs.JH..." - rest of line ignored. 567 | SP2-0734: unknown command beginning "AND phs.J..." - rest of line ignored. 565 | SP2-0734: unknown command beginning "left outer..." - rest of line ignored. 566 | SP2-0734: unknown command beginning "ON phs.JH..." - rest of line ignored. 567 | SP2-0734: unknown command beginning "AND phs.J..." - rest of line ignored. 568 | SP2-0734: unknown command beginning "AND phs.j..." - rest of line ignored. 566 | SP2-0734: unknown command beginning "ON phs.JH..." - rest of line ignored. 567 | SP2-0734: unknown command beginning "AND phs.J..." - rest of line ignored. 568 | SP2-0734: unknown command beginning "AND phs.j..." - rest of line ignored. 569 | SP2-0044: For a list of known commands enter HELP 569 | SP2-0044: For a list of known commands enter HELP 570 | and to leave enter EXIT. 571 | SP2-0734: unknown command beginning "WHERE pcs...." - rest of line ignored. 572 | SP2-0734: unknown command beginning "AND pcs.J..." - rest of line ignored. 570 | and to leave enter EXIT. 571 | SP2-0734: unknown command beginning "WHERE pcs...." - rest of line ignored. 572 | SP2-0734: unknown command beginning "AND pcs.J..." - rest of line ignored. 573 | SP2-0042: unknown command "GROUP BY" - rest of line ignored. 572 | SP2-0734: unknown command beginning "AND pcs.J..." - rest of line ignored. 573 | SP2-0042: unknown command "GROUP BY" - rest of line ignored. 574 | SP2-0734: unknown command beginning "pcs.COMPAN..." - rest of line ignored. 575 | SP2-0044: For a list of known commands enter HELP 575 | SP2-0044: For a list of known commands enter HELP 576 | and to leave enter EXIT. 577 | SP2-0734: unknown command beginning ", c.COMP_L..." - rest of line ignored. 578 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 576 | and to leave enter EXIT. 577 | SP2-0734: unknown command beginning ", c.COMP_L..." - rest of line ignored. 578 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 579 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 577 | SP2-0734: unknown command beginning ", c.COMP_L..." - rest of line ignored. 578 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 579 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 580 | SP2-0734: unknown command beginning ", cust.CUS..." - rest of line ignored. 578 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 579 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 580 | SP2-0734: unknown command beginning ", cust.CUS..." - rest of line ignored. 581 | SP2-0044: For a list of known commands enter HELP 581 | SP2-0044: For a list of known commands enter HELP 582 | and to leave enter EXIT. 583 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 584 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 583 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 584 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 585 | SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. 586 | SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. 584 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 585 | SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. 586 | SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. 587 | SP2-0044: For a list of known commands enter HELP 587 | SP2-0044: For a list of known commands enter HELP 588 | and to leave enter EXIT. 589 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 590 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 589 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 590 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 591 | SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. 592 | SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. 590 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 591 | SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. 592 | SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. 593 | SP2-0044: For a list of known commands enter HELP 593 | SP2-0044: For a list of known commands enter HELP 594 | and to leave enter EXIT. 595 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 596 | SP2-0042: unknown command ", 'Y'" - rest of line ignored. 595 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 596 | SP2-0042: unknown command ", 'Y'" - rest of line ignored. 597 | SP2-0734: unknown command beginning ", CATEGOR..." - rest of line ignored. 598 | SP2-0042: unknown command ", NULL)" - rest of line ignored. 599 | SP2-0044: For a list of known commands enter HELP 600 | and to leave enter EXIT. 601 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 602 | SP2-0042: unknown command ", 'Y'" - rest of line ignored. 601 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 602 | SP2-0042: unknown command ", 'Y'" - rest of line ignored. 603 | SP2-0734: unknown command beginning ", CATEGOR..." - rest of line ignored. 604 | SP2-0042: unknown command ", NULL)" - rest of line ignored. 605 | SP2-0044: For a list of known commands enter HELP 606 | and to leave enter EXIT. 607 | SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. 608 | SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. 606 | and to leave enter EXIT. 607 | SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. 608 | SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. 609 | SP2-0734: unknown command beginning "ORDER BY ..." - rest of line ignored. 607 | SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. 608 | SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. 609 | SP2-0734: unknown command beginning "ORDER BY ..." - rest of line ignored. 610 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 608 | SP2-0734: unknown command beginning ", JBCD_CON..." - rest of line ignored. 609 | SP2-0734: unknown command beginning "ORDER BY ..." - rest of line ignored. 610 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 611 | SP2-0044: For a list of known commands enter HELP 611 | SP2-0044: For a list of known commands enter HELP 612 | and to leave enter EXIT. 613 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 614 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 612 | and to leave enter EXIT. 613 | SP2-0734: unknown command beginning ", pcs.JOB_..." - rest of line ignored. 614 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 615 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 614 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 615 | SP2-0042: unknown command ", 'H'" - rest of line ignored. 616 | SP2-0734: unknown command beginning ", DECODE(p..." - rest of line ignored. 617 | SP2-0044: For a list of known commands enter HELP 617 | SP2-0044: For a list of known commands enter HELP 618 | and to leave enter EXIT. 619 | SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. 620 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 618 | and to leave enter EXIT. 619 | SP2-0734: unknown command beginning ", phs.jhp_..." - rest of line ignored. 620 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 621 | SP2-0042: unknown command ", 'Y'" - rest of line ignored. 620 | SP2-0734: unknown command beginning ", DECODE(s..." - rest of line ignored. 621 | SP2-0042: unknown command ", 'Y'" - rest of line ignored. 622 | SP2-0734: unknown command beginning ", CATEGOR..." - rest of line ignored. 623 | SP2-0044: For a list of known commands enter HELP ---------INFORMATIONAL ISSUES--------- 552 | * 553 | ERROR at line 1: 554 | ORA-01749: you may not GRANT/REVOKE privileges to/from yourself 555 | 736 | * 737 | ERROR at line 69: 738 | ORA-00904: "CTRL"."JHP_NAME": invalid identifier 739 | 751 | * 752 | ERROR at line 1: 753 | ORA-01749: you may not GRANT/REVOKE privileges to/from yourself 754 | =============================== End of Installation Log Review ===============================