TracBrowser: R_12_2_6_Upgrade.txt

Oracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)

Section 6: Apply the Latest AD and TXK Delta Release Update Packs
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

        Section 2: Apply Required Database Patches and Update Database Initialization Parameters— Done
        Section 3: Apply the R12.AD.C.Delta.9 and R12.TXK.C.Delta.9 Release Update Packs
        3.1 Path A — Upgrade and New Installation Customers
        New Installation Customers
        
        Weblogic PSU — Running
        Footnote 1 - This is the 10.3.6.0.161018 PSU. When applying a PSU all conflicting patches (including overlays and previous PSUs) would need to be removed. For a list of bug fixes included in this PSU, refer to My Oracle Support Knowledge Document 2194102.1, Oracle WebLogic Server Patch Set Update 10.3.6.0.161018 Fixed Bugs List.

13729611 (see Footnote 2)       Z9PC    13729611
17319481 (see Footnote 2)       9KCT    17319481
19259028 (see Footnote 2)       
KRDE

19259028
19687084 (see Footnote 2)       NJVF    19687084
22323006        DI8E    22323006
23743997 (see Footnote 1)       K25M    23743997 — PSU (running)
24608998 (see Footnote 2)       QMJP    13337000, 21562338

Known Issue Installing Oracle WebLogic Server Patches

When using the bsu.sh (or bsu.cmd on Microsoft Windows) script to install an Oracle WebLogic Server patch, you may receive an out of memory error for either "GC overhead limit" or "Java heap space". In such a case, run the commands shown below.

Source the Oracle E-Business Suite Release 12.2 environment
Change directory to $FMW_HOME/utils/bsu
Back up the existing copy of bsu.sh (or bsu.cmd on Microsoft Windows)
$ cp bsu.sh bsu.sh_backup
Open bsu.sh (or bsu.cmd on Microsoft Windows) in a text editor such as vi and change the line: 
MEM_ARGS="-Xms256m -Xmx512m"
on UNIX to:
MEM_ARGS="-Xms512m -Xmx1024m -XX:+UseParallelGC"
on Microsoft Windows to:
set MEM_ARGS=-Xms512m -Xmx1024m -XX:+UseParallelGC
Save the modified bsu.sh (or bsu.cmd on Microsoft Windows) file and exit the editor
Run the patch installation procedure again.


After you have run ETCC as applicable, proceed to the installation steps below.

        3.1.2 Run Installation Steps
        . <RUN_BASE>/EBSapps/appl/APPS<CONTEXT_NAME>.env
        sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
        Unzip patches and run adgrants.
        unzip Patch 25178222 (R12.AD.C.Delta.9)
        unzip Patch 25180736 (R12.TXK.C.Delta.9)
        Execute adgrants by following the instructions in the readme of Patch 25178222 (R12.AD.C.Delta.9).— 
        Note - Do not merge Patch 25178222 with any other patches.
On the run edition application tier file system, apply Patch 25178222 (R12.AD.C.Delta.9) in hotpatch mode.
        adop phase=apply patches=25178222 hotpatch=yes
        § ou should periodically check this Document 1617461.1 on My Oracle Support for updates.

4.1 Critical AD Patches

All Customers

Patch 25250923:R12.AD.C
Patch 24481010:R12.AD.C
Patch 25615812:R12.AD.C

4.2 Critical TXK Patches

Patch 25874936:R12.TXK.C
Patch 25983583:R12.TXK.C
Patch 25994411:R12.TXK.C
Patch 26182372:R12.TXK.C

apply any applicable AD patches as a comma-separated list of patches. 
adop phase=apply patches= 25250923,24481010,25615812 hotpatch=yes merge=yes

use hotpatch mode to apply Patch 25180736 (R12.TXK.C.Delta.9) (plus any additional critical patches – see note box).
adop phase=apply patches=25180736,25874936,25983583,25994411,26182372 hotpatch=yes merge=yes

Section 5: Update Database Tier to Latest Code

On the application tier (as the APPLMGR user):
. <EBS_ROOT>/EBSapps.env run
perl <AD_TOP>/bin/admkappsutil.pl

On the database tier (as the ORACLE user):
. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env
Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.
cd <ORACLE_HOME>
unzip -o appsutil.zip
$ sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh

Run AutoConfig on the run file system.
Run AutoConfig on all application tier nodes (as the APPLMGR user) by executing the applicable command:
 sh <INST_TOP>/admin/scripts/adautocfg.sh



Section 7: Perform Pre-Update Steps (Conditional)

Customer Relationship Management tasks:
Oracle Mobile Field Service customers: (Document 2188514.1)
Drop user mobileadmin cascade;


Supply Chain Management tasks:
Oracle Install Base (Document 1681308.1)
SELECT DISTINCT sub_type_id
FROM csi_txn_sub_types
WHERE ib_txn_type_code ='WBADI';

R12.2.x customers currently having sub_type_id = 10357, 102 and txn_type_code = WBADI in csi_ib_txn_types and csi_source_ib_types tables should apply the following datafix to correct Installed Base Transaction SubTypes data

1. Delete sub_type_id = 10357 record for ib_txn_type_code = 'WBADI' using the following script:

select to_char(csit.creation_date,'DD-MON-YYYY')
from  csi_ib_txn_types citt ,csi_source_ib_types csit
where csit.sub_type_id = citt.sub_type_id
and citt.sub_type_id = 10357
and citt.ib_txn_type_code = 'WBADI';

delete from csi_ib_txn_types
where sub_type_id = 10357
and ib_txn_type_code = 'WBADI';

delete from csi_source_ib_types
where sub_type_id in (select sub_type_id from csi_ib_txn_types where sub_type_id = 10357 and ib_txn_type_code = 'WBADI' );

commit;
2. Delete newly created seeded Transaction SubTypes through csitxnst.ldt with sub_type_id > 10000 using the following script:

delete from csi_ib_txn_types
where to_char(creation_date,'DD-MON-YYYY') = <Date from above query1>
and seeded_flag = 'Y' 
and sub_type_id > 10000; 

delete from csi_source_ib_types
where to_char(creation_date,'DD-MON-YYYY') = <Date from above query1>
and seeded_flag = 'Y' 
and sub_type_id > 10000; 

commit;
3. If user-defined Transaction SubTypes were created before applying a patch that provides the bad version of csitxnst.ldt, there are chances to corrupt these existing sub types data. The following needs to be done:

    a. Compare user_defined Transaction SubTypes data on patched and non-patched environments. Run the following SQLs on both environments and compare output to identify the differences:

select * from csi_ib_txn_types
where seeded_flag = 'N';

select * from csi_source_ib_types
where seeded_flag = 'N';
   b. If there is any data corruption, then log a Service Request and provide output of the SQLs in step 3-a to get a datafix for the corrupted data from Oracle Installed Base Development.



Oracle Landed Cost Management

If you have a lower version of the file(s) than the one below and have done customization, create a back-up of your file(s) under a location outside both APPL_TOPs or under $APPL_TOP_NE/../log.

Package Name    File Version
INL_CUSTOM_PUB  INLPCUSB.pls 
120.6.12020000.7

INLPCUSS.pls 
120.5.12020000.6
After applying the Oracle E-Business Suite 12.2.6 Release Update Pack, redo the customization in the new version of the specification and the body. For more information, refer to My Oracle Support Knowledge Document 1211843.1, How to Proceed for Customizing LCM Hooks INLPCUSB.pls.


Oracle Warehouse Management

If you have a lower version of the file(s) listed below or you have performed customizations on any of these packages, create a back-up of your file(s) under $APPL_TOP_NE/.

Package Name    File Version
WMS_LABEL_CUSTOM_PKG    WMSLACPB.pls
120.0.12020000.3

WMSLACPS.pls
120.1.12020000.5
WMS_XDOCK_CUSTOM_APIS_PUB       WMSXDCAS.pls
120.2.12020000.5

WMSXDCAB.pls
120.1.12020000.3
WMS_RE_Custom_PUB       WMSPPPUS.pls
120.6.12020000.4

WMSPPPUB.pls
120.5.12020000.2
After applying the Oracle E-Business Suite 12.2.6 Release Update Pack, redo the customization in the new version of the specification and the body.


Section 8: Apply Oracle E-Business Suite 12.2.6 Release Update Pack

8.1 Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.6 Release Update Pack

Source the run edition applications environment.

$ . <INSTALL_BASE>/EBSapps.env run

Stop the Oracle Weblogic Admin Server and Node Manager services.

Applying the patch in downtime mode requires all application tier services to be down. Therefore, Weblogic AdminServer and Node Manager that were started previously when applying the latest Release Update Packs for AD and TXK for Release 12.2 need to be shut down.

Stop the Oracle Weblogic Admin Server on the run file system.

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

Stop the Node Manager service on the run file system.

$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop


Apply Oracle E-Business Suite 12.2.6 Release Update Pack Patch 21900901 on the run edition application environment, using downtime mode.

$ adop phase=apply apply_mode=downtime patches=21900901

Start all application tier services on the run file system.

$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

Perform adop cleanup action.

adop phase=cleanup

Synchronize file systems

adop phase=fs_clone



Section 9: Post-Update Steps

Apply Oracle E-Business Suite Release 12.2.6 Online Help

dop phase=apply patches=21900918 hotpatch=yes