Client home /u01/app/oracle/product/19.19/PROD
Start execution of command /opt/cm/v12/test/1_hotfix_test/24.90011_CLOUD_141671_install_1_install.sh
Client home /u01/app/oracle/product/19.19/PROD
You specified version v12
Installation started at: 2024-10-10 20:07:13
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/JBPCI_MBA_20241010.sql:
___________________________________
Updating: /opt/cm/v12/test/sql/JBPCI_MBA_20241010.sql
- This is a new file, no information available on disk
- size (new file): 11420 bytes
- last modified (new file): 2024-10-10 15:25:32.0
- File: sql/2490011_1.sql:
__________________________
Updating: /opt/cm/v12/test/sql/2490011_1.sql
- This is a new file, no information available on disk
- size (new file): 7512 bytes
- last modified (new file): 2024-10-10 15:25:32.0
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-10_20_07_14.188/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-10-10_20_07_14.188/tempPtfcompx.sql"
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-10_20_07_14.188/PTFCompX.sh
Running dir /opt/cm/v12/test/sql
The number of groups of SQL scripts 2
The group 0
entry Name Update:2490011_1.sql@sql
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-10_20_07_14.188/2490011_1.sql.sh to run 2490011_1.sql
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-10_20_07_14.188/2490011_1.sql.sh
Running dir /opt/cm/v12/test/sql
Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-10-10_20_07_14.188/2490011_1.sql.sh
Wait for procedure starts
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 10 20:07:34 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.90011, Work Item 1
-- JBPCI_MBA Target Registration
-- ======================================================================
ERRORtput: No value for $TERM and no -T specified
USER is "DA"
test
USER is "DA"
test
USER is "DA"
test
-- ======================================================================
-- Started 2490011_1.sql Output in 2490011_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,040 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,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,432 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,292 61
===================================================
===================================================================================
== 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-10 20:07:50
special list (before special recompiling)
2024-10-10 20:07:51
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-10 20:07:52
special list (after special recompiling)
2024-10-10 20:07:53
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,040 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,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,432 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,292 61
==========================================================================
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 10-OCT-24 08.07.54.153570 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
-- ======================================================================
-- ======================================================================
-- Work Order 24.90011, Work Item 1
-- JBPCI_MBA Target Registration
-- ======================================================================
ERRORtput: No value for $TERM and no -T specified
USER is "DA"
test
USER is "DA"
test
USER is "DA"
test
-- ========================================================================================
-- === Started: JBPCI_MBA_20241010.sql Output in JBPCI_MBA_20241010.lst
-- ========================================================================================
-- ======================================================================
-- 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,040 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,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,432 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,292 61
===================================================
===================================================================================
== 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-10 20:08:09
special list (before special recompiling)
2024-10-10 20:08:10
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-10 20:08:11
special list (after special recompiling)
2024-10-10 20:08:12
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,040 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,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,432 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,292 61
==========================================================================
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 10-OCT-24 08.08.13.519883 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 Columns, Tables, Views, Other Objects
-- ======================================================================
-- ======================================================================
-- Create Tables
-- ======================================================================
-- ======================================================================
-- Add Columns
-- ======================================================================
-- ======================================================================
-- Register Table-Packages and Rebuild Automatically Created Packages
-- ======================================================================
-- ======================================================================
-- Install Package Headers
-- ======================================================================
-- ======================================================================
-- Install Views
-- ======================================================================
-- ======================================================================
-- Install Triggers
-- ======================================================================
-- ======================================================================
-- Install Package Bodies
-- ======================================================================
-- ======================================================================
-- Install/Update System Data
-- ======================================================================
Begin
*
ERROR at line 1:
ORA-20666: NO-ERROR-CODEUnable to find Tenant "MBABTEST"
ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
ORA-06512: at "UIG.DBK_SA_INFO", line 431
ORA-06512: at line 2
.=========================================================
. Dropping Temporary TABLES
.=========================================================
Table dropped.
drop table TMP_SDCODES
*
ERROR at line 1:
ORA-00942: table or view does not exist
drop table TMP_sddata_user_table
*
ERROR at line 1:
ORA-00942: table or view does not exist
.=========================================================
. Creating Temporary TABLES
.=========================================================
Table created.
Table created.
Table created.
================================================================
Creating Temporary INDEXES
================================================================
Index created.
Index created.
.=========================================================
. PROCESSING table DA.REPORTS_WITHIN_APPS
.=TMP=====================================================
1 row created.
Commit complete.
.=UPDATE==================================================
0 rows updated.
Commit complete.
.=INSERT==================================================
1 row created.
.=========================================================
Commit complete.
.=========================================================
. PROCESSED table DA.REPORTS_WITHIN_APPS
.=========================================================
.=========================================================
. PROCESSING table da.SDCODES
.=TMP=====================================================
1 row created.
Commit complete.
.=UPDATE==================================================
0 rows updated.
Commit complete.
.=INSERT==================================================
1 row created.
.=========================================================
Commit complete.
.=========================================================
. PROCESSED table DA.SDCODES
.=========================================================
.=========================================================
. PROCESSING table da.sddata_user_table
.=TMP=====================================================
1 row created.
Commit complete.
.=UPDATE===================================================
0 rows updated.
Commit complete.
.=INSERT===================================================
1 row created.
Commit complete.
.=========================================================
Commit complete.
.=========================================================
. PROCESSED table DA.sddata_user_table
.=========================================================
.=========================================================
. Dropping Temporary TABLES
.=========================================================
Table dropped.
Table dropped.
Table dropped.
PL/SQL procedure successfully completed.
no rows selected
REP REPORT_FILENAME REPORT_FILEDESC REPORT_USER REPORT_MO R R REPORT_FORMAT_GROUP REPORT_CGICMD_KE REPORT_EMAIL_SUBJECT
--- ------------------------------ ------------------------------ ------------------------------ --------- - - ------------------------------ ---------------- --------------------------------------------------------------------------------------------------------------------------------
REPORT_EMAIL_BODY
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
REPORT_FAX_COVER_PAGE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
REPORT__I REPORT__IU__CREATE_USER REPORT__I REPORT__IU__UPDATE_USER REPORT_ENGINE_LIST REPORT_TENANT_ID REPORT_LAST_SESSIONINFO REPORT_ORIG_SESSIONINFO
--------- ------------------------------ --------- ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
JB JBPCI_MBA MBA PCI Detail JB INV DA 10-OCT-24
10-OCT-24 DA JS 361T8ZO3M41058 V(),(),(SQL*Plus)db-tst-na02-oci-use01.cmiccloud.com
1 row selected.
-- ======================================================================
-- Update Data, Modify Table/Column Definitions
-- ======================================================================
-- ======================================================================
-- Data Correction Statements
-- ======================================================================
-- ======================================================================
-- Install Keys and Constraints
-- ======================================================================
-- ======================================================================
-- Install Indexes
-- ======================================================================
-- ======================================================================
-- Install Table and Column Comments
-- ======================================================================
-- ======================================================================
-- 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,040 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,172 TABLE
38,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,431 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,291 61
===================================================
===================================================================================
== 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-10 20:08:29
special list (before special recompiling)
2024-10-10 20:08:30
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-10 20:08:31
special list (after special recompiling)
2024-10-10 20:08:32
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,040 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,172 TABLE
38,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,431 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,291 61
==========================================================================
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 10-OCT-24 08.08.33.323117 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)
-- ====================================================================================================
-- ======================================================================
-- Update Menu Items in Treeview
-- ======================================================================
-- .
-- ========================================================================================
-- === Completed: JBPCI_MBA_20241010.sql Output in JBPCI_MBA_20241010.lst
-- ========================================================================================
-- .
-- ======================================================================
-- Update Data, Modify Table/Column Definitions
-- ======================================================================
-- ======================================================================
-- Data Correction Statements
-- ======================================================================
PL/SQL procedure successfully completed.
-- ======================================================================
-- Get the current 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,040 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,172 TABLE
38,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,431 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,291 61
===================================================
===================================================================================
== 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-10 20:08:48
special list (before special recompiling)
2024-10-10 20:08:49
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-10-10 20:08:51
special list (after special recompiling)
2024-10-10 20:08:51
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,040 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,172 TABLE
38,295 TABLE PARTITION
61,602 12 TRIGGER
270 TYPE
40,859 10 VIEW
-------- ********** --------
243,431 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
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 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 37 VIEW
-------- ********** --------
34,136 sum 37
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
391 VIEW
-------- ********** --------
544 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
301,291 61
==========================================================================
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 10-OCT-24 08.08.52.493289 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.
-- ======================================================================
-- 2490011_1.sql completed. Output in 2490011_1.LST
-- ======================================================================
not spooling currently
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.90011 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: 0
Informative Errors: 6
---------CRITICAL ERRORS---------
---------WARNINGS---------
---------INFORMATIONAL ISSUES---------
912 | *
913 | ERROR at line 1:
914 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "MBABTEST"
915 |
914 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "MBABTEST"
915 |
916 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
917 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
915 |
916 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
917 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
918 | ORA-06512: at line 2
916 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
917 | ORA-06512: at "UIG.DBK_SA_INFO", line 431
918 | ORA-06512: at line 2
919 |
928 | *
929 | ERROR at line 1:
930 | ORA-00942: table or view does not exist
931 |
934 | *
935 | ERROR at line 1:
936 | ORA-00942: table or view does not exist
937 |
===============================
End of Installation Log Review
===============================