Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.86377_CLOUD_289861_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-06-21 03:06:09 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/SVC_BUDG_REP_20240620.sql: ______________________________________ Updating: /opt/cm/v12/test/sql/SVC_BUDG_REP_20240620.sql - This is a new file, no information available on disk - size (new file): 20661 bytes - last modified (new file): 2024-06-20 13:51:50.0 - File: sql/2486377_1.sql: __________________________ Updating: /opt/cm/v12/test/sql/2486377_1.sql - This is a new file, no information available on disk - size (new file): 7520 bytes - last modified (new file): 2024-06-20 13:51:50.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-21_03_06_10.464/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-06-21_03_06_10.464/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-21_03_06_10.464/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2486377_1.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-21_03_06_10.464/2486377_1.sql.sh to run 2486377_1.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-21_03_06_10.464/2486377_1.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-06-21_03_06_10.464/2486377_1.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 21 03:06:23 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.86377, Work Item 1 -- Revised View SVC_Client_Budg_Rpt -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2486377_1.sql Output in 2486377_1.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial 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 7,604 INDEX 51,230 INDEX PARTITION 55 JOB 258 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 1 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,946 TABLE 33,644 TABLE PARTITION 20,825 19 TRIGGER 266 TYPE 10,346 VIEW -------- ********** -------- 140,244 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 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 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 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 6,201 18 VIEW -------- ********** -------- 6,236 sum 18 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 -------- -------- 159,997 40 =================================================== =================================================================================== == 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-06-21 03:06:33 special list (before special recompiling) 2024-06-21 03:06:34 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-21 03:06:35 special list (after special recompiling) 2024-06-21 03:06:35 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 7,604 INDEX 51,230 INDEX PARTITION 55 JOB 258 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 1 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,946 TABLE 33,644 TABLE PARTITION 20,825 19 TRIGGER 266 TYPE 10,346 VIEW -------- ********** -------- 140,244 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 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 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 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 6,201 18 VIEW -------- ********** -------- 6,236 sum 18 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 -------- -------- 159,997 40 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE BODY DBK_AP_CHQPRT DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 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_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 21-JUN-24 03.06.37.058184 AM -04:00 Flag value=P DBK_patch_flag.show_flag=P.P CMiC CLOUD R12 - V12-019-2-HF-CLD-01c 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: SVC_BUDG_REP_20240620.sql -- ========================================================================================== -- ====================================================================== -- ===== view: CMIC_REPORT_WRITER.SVC_CLIENT_BUDG_RPT -- ====================================================================== --select * from options * ERROR at line 35: ORA-00928: missing SELECT keyword SP2-0734: unknown command beginning ", purchase..." - rest of line ignored. ) * ERROR at line 31: ORA-00933: SQL command not properly ended SP2-0734: unknown command beginning ", orig_bud..." - rest of line ignored. ) * ERROR at line 13: ORA-00933: SQL command not properly ended SP2-0734: unknown command beginning ", changes_..." - rest of line ignored. SP2-0042: unknown command ")" - rest of line ignored. SP2-0734: unknown command beginning ", po_commi..." - rest of line ignored. ) * ERROR at line 17: ORA-00933: SQL command not properly ended SP2-0734: unknown command beginning ", po_commi..." - rest of line ignored. ) * ERROR at line 13: ORA-00933: SQL command not properly ended SP2-0734: unknown command beginning ", current_..." - rest of line ignored. SP2-0042: unknown command "union all" - rest of line ignored. ) * ERROR at line 13: ORA-00933: SQL command not properly ended SP2-0734: unknown command beginning ", current_..." - rest of line ignored. ) * ERROR at line 17: ORA-00933: SQL command not properly ended SP2-0734: unknown command beginning ", union_un..." - rest of line ignored. ) * ERROR at line 46: ORA-00933: SQL command not properly ended No errors. COMMENT ON COLUMN cmic_report_writer.svc_client_budg_rpt.cbr_commitment_amount IS 'Commitment Amount' * ERROR at line 1: ORA-00904: "CBR_COMMITMENT_AMOUNT": invalid identifier COMMENT ON COLUMN cmic_report_writer.svc_client_budg_rpt.cbr_owner_commitment_amount IS 'Owner Commitment Amount' * ERROR at line 1: ORA-00904: "CBR_OWNER_COMMITMENT_AMOUNT": invalid identifier -- ========================================================================================== -- ===== drop view cmic_report_views.svc_client_budg_rpt (if it exists) -- ========================================================================================== -- ========================================================================================== -- ===== create cmic_report_views.svc_client_budg_rpt -- ========================================================================================== . --> Created View CMIC_REPORT_VIEWS.SVC_CLIENT_BUDG_RPT -- ========================================================================================== -- ===== grants on cmic_report_views.svc_client_budg_rpt -- ========================================================================================== -- ========================================================================================== -- ===== Verify cmic_report_views.svc_client_budg_rpt exists -- ========================================================================================== -- ========================================================================================== -- ===== Completed: svc_client_budg_rpt.sql -- ========================================================================================== 1* GRANT READ ON CMIC_REPORT_VIEWS.svc_client_budg_rpt TO CMIC_BI_RUNTIME WITH GRANT OPTION -- ====================================================================== -- 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 7,604 INDEX 51,230 INDEX PARTITION 55 JOB 258 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 1 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,946 TABLE 33,644 TABLE PARTITION 20,825 19 TRIGGER 266 TYPE 10,346 VIEW -------- ********** -------- 140,244 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 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 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 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 6,201 18 VIEW -------- ********** -------- 6,236 sum 18 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 -------- -------- 159,997 40 =================================================== =================================================================================== == 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-06-21 03:06:51 special list (before special recompiling) 2024-06-21 03:06:51 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-21 03:06:52 special list (after special recompiling) 2024-06-21 03:06:52 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 7,604 INDEX 51,230 INDEX PARTITION 55 JOB 258 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 1 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,946 TABLE 33,644 TABLE PARTITION 20,825 19 TRIGGER 266 TYPE 10,346 VIEW -------- ********** -------- 140,244 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 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 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 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 6,201 18 VIEW -------- ********** -------- 6,236 sum 18 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 -------- -------- 159,997 40 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE BODY DBK_AP_CHQPRT DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 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_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 21-JUN-24 03.06.54.556288 AM -04:00 Flag value=P DBK_patch_flag.show_flag=P.P CMiC CLOUD R12 - V12-019-2-HF-CLD-01c SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2486377_1.sql completed. Output in 2486377_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.86377 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: 8 Informative Errors: 10 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- 511 | 512 | 513 | SP2-0734: unknown command beginning ", purchase..." - rest of line ignored. 514 | ) 518 | 519 | 520 | SP2-0734: unknown command beginning ", orig_bud..." - rest of line ignored. 521 | ) 525 | 526 | 527 | SP2-0734: unknown command beginning ", changes_..." - rest of line ignored. 528 | SP2-0042: unknown command ")" - rest of line ignored. 527 | SP2-0734: unknown command beginning ", changes_..." - rest of line ignored. 528 | SP2-0042: unknown command ")" - rest of line ignored. 529 | SP2-0734: unknown command beginning ", po_commi..." - rest of line ignored. 530 | ) 534 | 535 | 536 | SP2-0734: unknown command beginning ", po_commi..." - rest of line ignored. 537 | ) 541 | 542 | 543 | SP2-0734: unknown command beginning ", current_..." - rest of line ignored. 544 | SP2-0042: unknown command "union all" - rest of line ignored. 549 | 550 | 551 | SP2-0734: unknown command beginning ", current_..." - rest of line ignored. 552 | ) 556 | 557 | 558 | SP2-0734: unknown command beginning ", union_un..." - rest of line ignored. 559 | ) ---------INFORMATIONAL ISSUES--------- 508 | * 509 | ERROR at line 35: 510 | ORA-00928: missing SELECT keyword 511 | 515 | * 516 | ERROR at line 31: 517 | ORA-00933: SQL command not properly ended 518 | 522 | * 523 | ERROR at line 13: 524 | ORA-00933: SQL command not properly ended 525 | 531 | * 532 | ERROR at line 17: 533 | ORA-00933: SQL command not properly ended 534 | 538 | * 539 | ERROR at line 13: 540 | ORA-00933: SQL command not properly ended 541 | 546 | * 547 | ERROR at line 13: 548 | ORA-00933: SQL command not properly ended 549 | 553 | * 554 | ERROR at line 17: 555 | ORA-00933: SQL command not properly ended 556 | 560 | * 561 | ERROR at line 46: 562 | ORA-00933: SQL command not properly ended 563 | 567 | * 568 | ERROR at line 1: 569 | ORA-00904: "CBR_COMMITMENT_AMOUNT": invalid identifier 570 | 573 | * 574 | ERROR at line 1: 575 | ORA-00904: "CBR_OWNER_COMMITMENT_AMOUNT": invalid identifier 576 | =============================== End of Installation Log Review ===============================