Client home /u01/app/oracle/product/19.19/PROD
Start execution of command /opt/cm/v12/test/1_hotfix_test/24.89467_CLOUD_109582_install_1_install.sh
Client home /u01/app/oracle/product/19.19/PROD
You specified version v12
Installation started at: 2024-10-08 14:38:17
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
Warning: Issue 24.89467, has been installed 4 times on the application server while it is installed 1 times on the database!
- File: sql/2489467_2.sql:
__________________________
The new copy of the file "/opt/cm/v12/test/sql/2489467_2.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same!
Updating: /opt/cm/v12/test/sql/2489467_2.sql
- size (on disk): 9632 bytes
- last modified (on disk): 2024-09-26 16:23:06.0
- size (new file): 9632 bytes
- last modified (new file): 2024-09-26 16:23:06.0
Warning: The file was not modified.
- File: sql/2489467_1.sql:
__________________________
The new copy of the file "/opt/cm/v12/test/sql/2489467_1.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same!
Updating: /opt/cm/v12/test/sql/2489467_1.sql
- size (on disk): 8749 bytes
- last modified (on disk): 2024-09-06 16:52:34.0
- size (new file): 8749 bytes
- last modified (new file): 2024-09-06 16:52:34.0
Warning: The file was not modified.
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/tempPtfcompx.sql"
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/PTFCompX.sh
Running dir /opt/cm/v12/test/sql
The number of groups of SQL scripts 3
The group 0
entry Name Update:2489467_1.sql@sql
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/2489467_1.sql.sh to run 2489467_1.sql
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/2489467_1.sql.sh
Running dir /opt/cm/v12/test/sql
Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/2489467_1.sql.sh
Wait for procedure starts
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 8 14:38:45 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.89467, Work Item 1
-- Receipts Missing in Enter Voucher
-- ======================================================================
ERRORtput: No value for $TERM and no -T specified
USER is "DA"
test
USER is "DA"
test
USER is "DA"
test
-- ======================================================================
-- Started 2489467_1.sql Output in 2489467_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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
===================================================
===================================================================================
== 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-10-08 14:39:04
special list (before special recompiling)
2024-10-08 14:39:04
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-08 14:39:06
special list (after special recompiling)
2024-10-08 14:39:06
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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
==========================================================================
Objects with errors
========== =================== ==============================
Owner Type Object
========== =================== ==============================
DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE
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_SCPRELIM6FA5_OBJSEQ
DA TRIGGER DBT_AUTO_COLD_STORE_1389320892
DA TRIGGER DBT_AUTO_COLD_STORE_1389363935
DA TRIGGER DBT_AUTO_COLD_STORE_2456605959
DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE
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_EMP_AVAILFLT3_FATVIEW
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 08-OCT-24 02.39.08.231861 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)
-- ====================================================================================================
begin
*
ERROR at line 1:
ORA-20666: NO-ERROR-CODEUnable to find Tenant "CEITN"
ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
ORA-06512: at "UIG.DBK_SA_INFO", line 431
ORA-06512: at line 2
-- ======================================================================
-- Drop Obsolete Database Objects
-- ======================================================================
-- ======================================================================
-- Create Types
-- ======================================================================
-- ======================================================================
-- Create Tables
-- ======================================================================
Table created.
-- ======================================================================
-- 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
-- ======================================================================
-- ======================================================================
-- 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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
===================================================
===================================================================================
== 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-10-08 14:39:24
special list (before special recompiling)
2024-10-08 14:39:25
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-08 14:39:26
special list (after special recompiling)
2024-10-08 14:39:27
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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
==========================================================================
Objects with errors
========== =================== ==============================
Owner Type Object
========== =================== ==============================
DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE
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_SCPRELIM6FA5_OBJSEQ
DA TRIGGER DBT_AUTO_COLD_STORE_1389320892
DA TRIGGER DBT_AUTO_COLD_STORE_1389363935
DA TRIGGER DBT_AUTO_COLD_STORE_2456605959
DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE
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_EMP_AVAILFLT3_FATVIEW
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 08-OCT-24 02.39.28.611673 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.
-- ======================================================================
-- 2489467_1.sql completed. Output in 2489467_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
entry Name Update:2489467_2.sql@sql
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/2489467_2.sql.sh to run 2489467_2.sql
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/2489467_2.sql.sh
Running dir /opt/cm/v12/test/sql
Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_14_38_18.804/2489467_2.sql.sh
Wait for procedure starts
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 8 14:39:28 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.89467, Work Item 2
-- Receipts Missing in Enter Voucher
-- ======================================================================
ERRORtput: No value for $TERM and no -T specified
USER is "DA"
test
USER is "DA"
test
USER is "DA"
test
-- ======================================================================
-- Started 2489467_2.sql Output in 2489467_2.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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
===================================================
===================================================================================
== 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-10-08 14:39:45
special list (before special recompiling)
2024-10-08 14:39:46
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-08 14:39:47
special list (after special recompiling)
2024-10-08 14:39:48
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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
==========================================================================
Objects with errors
========== =================== ==============================
Owner Type Object
========== =================== ==============================
DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE
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_SCPRELIM6FA5_OBJSEQ
DA TRIGGER DBT_AUTO_COLD_STORE_1389320892
DA TRIGGER DBT_AUTO_COLD_STORE_1389363935
DA TRIGGER DBT_AUTO_COLD_STORE_2456605959
DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE
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_EMP_AVAILFLT3_FATVIEW
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 08-OCT-24 02.39.49.741346 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)
-- ====================================================================================================
begin
*
ERROR at line 1:
ORA-20666: NO-ERROR-CODEUnable to find Tenant "CEITN"
ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
ORA-06512: at "UIG.DBK_SA_INFO", line 431
ORA-06512: at line 2
-- ======================================================================
-- Drop Obsolete Database Objects
-- ======================================================================
-- ======================================================================
-- Create Types
-- ======================================================================
-- ======================================================================
-- Create Tables
-- ======================================================================
create table cmic_obj_backup.podetacc_2489467_2_tn as
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
-- ======================================================================
-- 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
-- ======================================================================
-- ======================================================================
-- 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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
===================================================
===================================================================================
== 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-10-08 14:40:05
special list (before special recompiling)
2024-10-08 14:40:06
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-08 14:40:07
special list (after special recompiling)
2024-10-08 14:40:08
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
17,800 INDEX
58,033 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,548 SYNONYM
18,173 TABLE
38,287 TABLE PARTITION
61,602 12 TRIGGER
266 TYPE
40,859 10 VIEW
-------- ********** --------
243,413 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,465 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,074 sum 1
230 JS80 INDEX
18 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
18 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
423 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
34,101 36 VIEW
-------- ********** --------
34,136 sum 36
8 REPORT_WRI INDEX
1 LOB
56 PACKAGE
56 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
393 VIEW
-------- ********** --------
548 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
147 INDEX PARTITION
74 LOB
147 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
51 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,854 sum
-------- --------
301,259 60
==========================================================================
Objects with errors
========== =================== ==============================
Owner Type Object
========== =================== ==============================
DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE
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_SCPRELIM6FA5_OBJSEQ
DA TRIGGER DBT_AUTO_COLD_STORE_1389320892
DA TRIGGER DBT_AUTO_COLD_STORE_1389363935
DA TRIGGER DBT_AUTO_COLD_STORE_2456605959
DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE
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_EMP_AVAILFLT3_FATVIEW
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 08-OCT-24 02.40.09.929506 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.
-- ======================================================================
-- 2489467_2.sql completed. Output in 2489467_2.LST
-- ======================================================================
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
The group 2
deployment dir /opt/cm/ias/j2ee/test/deployment/deploy
Case 4
Issue 24.89467 was successfully installed, but with warnings.
As specified with --no-deploy option, JSPs did not get deployed.
Deploy JSPs manually
Installation Log Review:
========================
---------SUMMARY---------
Critical Errors: 0
Warning Errors: 0
Informative Errors: 9
---------CRITICAL ERRORS---------
---------WARNINGS---------
---------INFORMATIONAL ISSUES---------
479 | *
480 | ERROR at line 1:
481 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "CEITN"
482 |
481 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "CEITN"
482 |
483 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
484 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
482 |
483 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
484 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
485 | ORA-06512: at line 2
483 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
484 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
485 | ORA-06512: at line 2
486 |
1324 | *
1325 | ERROR at line 1:
1326 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "CEITN"
1327 |
1326 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "CEITN"
1327 |
1328 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
1329 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
1327 |
1328 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
1329 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
1330 | ORA-06512: at line 2
1328 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
1329 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
1330 | ORA-06512: at line 2
1331 |
1343 | *
1344 | ERROR at line 1:
1345 | ORA-00955: name is already used by an existing object
1346 |
===============================
End of Installation Log Review
===============================