Saturday, April 9, 2016

Installation Oracle Ebusiness Suite 12.2.5 using startCD 12.2.0.51

Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1)
- Instal ebs dari startCD versi 12.2.0.51

Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
- Apply patch database Database
Missing Bugfix: 21028698 -> Patch 22098146
Missing Bugfix: 21286665 -> Patch 21286665
Missing Bugfix: 21387964 -> Patch 21387964
Missing Bugfix: 21614112 -> Patch 21841318
Missing Bugfix: 21967332 -> Patch 21967332'


- Apply patch Oracle Forms and Reports
Missing Bugfix: 17353142 -> Patch 21539521
Missing Bugfix: 20643256 -> Patch 21539521
Missing Bugfix: 16041055 -> Patch 21539521
Missing Bugfix: 16910762 -> Patch 21539521
Missing Bugfix: 20270659 -> Patch 21539521
Missing Bugfix: 17372642 -> Patch 21539521
Missing Bugfix: 17566694 -> Patch 21539521
Missing Bugfix: 20240480 -> Patch 21539521
Missing Bugfix: 19304738 -> Patch 21539521
Missing Bugfix: 20391574 -> Patch 21539521
$ . ./fsauto.sh
$ cd /u02/titip_made/21539521
$ $ORACLE_HOME/OPatch/opatch apply

- Apply patch Oracle Fusion Middleware (FMW) - Web Tier.
Missing Bugfix: 21300463 -> Patch 22107540
$ . ./fsauto.sh
$ cd /u02/titip_made/22107540
$ export ORACLE_HOME=$IAS_ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch apply


- Apply patch Oracle Fusion Middleware (FMW) - oracle_common
Missing Bugfix: 21366277 -> Patch 21366277
Missing Bugfix: 21628307 -> Patch 21628307
$ export ORACLE_HOME=$FMW_HOME/oracle_common

- Apply patch Oracle WebLogic Server (WLS)
Missing Patch ID: 20780171 -- diganti 21984589
$ unzip p21984589_1036_Generic.zip ke $FMW_HOME/utils/bsu/cache_dir
$ cd $FMW_HOME/utils/bsu
$ sh bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=S28A -prod_dir=$FMW_HOME/wlserver_10.3
-- bsu.sh -remove -patchlist=Y5AP -prod_dir=$FMW_HOME/wlserver_10.3


Missing Patch ID: 11781879
Missing Patch ID: 13337000
Missing Patch ID: 13729611
Missing Patch ID: 17319481
Missing Patch ID: 19687084
Missing Patch ID: 19600486
Missing Patch ID: 20780171

[demomgr@laberp bsu]$ sh bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3
Checking for conflicts...
Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch EJUW is mutually exclusive and cannot coexist with patch(es): Y5AP,UITV,MRF8,YVFP,S28A,A6GS



Apply Consolidated Seed Table Upgrade Patch (Required)
$ . ./fsauto.sh
$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
$ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes
$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
$ . /u01/oracle/demo/fs1/EBSapps/appl/APPSdemo_laberp.env
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Patch 20745242 (R12.AD.C.Delta.7)
Patch 22123818:R12.AD.C
Patch 20784380 (R12.TXK.C.Delta.7)
Patch 22363475:R12.TXK.C
Patch 22495069:R12.TXK.C


$ . ./db.env
$ $ORACLE_HOME/appsutil/admin
$ cp adgrants $ORACLE_HOME/appsutil/admin
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>


$ . /u01/oracle/demo/fs1/EBSapps/appl/APPSdemo_laberp.env
$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
$ adop phase=apply patches=20745242 hotpatch=yes
$ adop phase=apply patches=22123818 hotpatch=yes
$ adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes
$ . <EBS_ROOT>/EBSapps.env run
$ autoconfig
$ perl <AD_TOP>/bin/admkappsutil.pl
$ cp <INST_TOP>/admin/out/appsutil.zip <RDBMS ORACLE_HOME>

$ cd <RDBMS ORACLE_HOME>
$ . ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env
$ cd <ORACLE_HOME>
$ unzip -o appsutil.zip

Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.5 Release Update Pack
$ . <INSTALL_BASE>/EBSapps.env run
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
SQL> alter system set optimizer_adaptive_features=false;
$ adop phase=apply apply_mode=downtime patches=19676458
SQL> alter system set optimizer_adaptive_features=true;
$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
$ adop phase=cleanup
$ adop phase=fs_clone


Section 9: Post-Update Steps
$ adop phase=apply patches=19676460 hotpatch=yes

Sunday, August 17, 2014

How to Change the Color and Look of PUI forms in Oracle E-business Suite

Sometimes, it becomes necessary to show different color schemes between Production and Non-Production instances of Oracle E-Business suite.

Different color scheme will showcase the obvious difference to the end-user, so that they will realize where they are .

Do the following:
a. Login to Oracle Applications as the System Administator responsibility.
b. Navigate to Profile > System.
c. Ensure that the Site display is checked.
d. Query up ‘Java Color Scheme’ for the profile.
e. Select the appropriate color under the Site column.
f. Save the selection.
g. Sign off and back on (or change responsibility) for your new color scheme to take effect.

Be aware that the ‘Java Color Scheme’ profile has no effect if ‘Java Look and Feel’ is set to GENERIC.