SFDC Upgrade for impacts to existing custom integration (TLS1.1)

Introduction

The TLS protocol provides communications security over the Internet.The protocol allows client/server applications to communicate in a way that is designed to prevent eavesdropping, tampering, or message forgery. Now SFDC is going to upgrade the TLS 1.0 to 1.1.This may impact the existing custom integration.So need to apply patches to the SOA and JDeveloper.

Business Requirement:

Currently the integration between Oracle E-biz to SFDC is working under TLS 1.0.Now the version is going to be upgraded to 1.1.

After upgradation of TLS 1.1 , the existing integration system will not work.It may shown a error as "This version is no longer supported" or "Unsupported Clients" in SFDC Adapter.

Following are the 4 phases to achieve the TLS 1.1 or higher Http security upgradation in SFDC and SOA.

Phase (1) SFDC Change/Configuration:

Login to the SFDC and do the following steps

1.1) Upgrade TLS 1.0 to 1.1 in SFDC:

       Go to Critical Updates --> Click Activate next to "Require TLS 1.1 or higher..."

1.2) Generate WSDL file for SFDC

       Go to the API under Develop --> get the enterprise WSDL.

Phase (2) Weblogic, SOA and Jdeveloper Patch Application to upgrade the Instance for HTTP TLS1.1 or Higher:

2.1) Upgrade the java from 1.6.0_45 to 1.7.0_45 in (Weblogic + SOA) Server.

2.2) Apply the patch(22612527) for Both SOA(Run time) in the Server and Jdeveloper(Design time) in Desktop Only. (Ref:Oracle Doc ID 2112308.1)

• Apply the pre-requisite first, before applying the patch (22612527) refer README.txt.
• Note : This patch requires pre-requisite, Please check that also.Before applying Patch 22612527 , must correctly apply the prerequisite Patch 13866584 as per the readme. Be aware that patch 13866584 will not appear in the OPatch inventory since its installation is a copy/paste method.
• Apply the patch 11.1.1.7.0 version of 22612527 after step2.
• Correct the JAVA_HOME path in script file setDomainEnv.sh ,
• Also,have to add JAVA_OPTIONS in setDomainEnv.sh 
• Edit JAVA OPTIONS inside setDomainEnv.sh[cmd] under %domain_home_dir%/binfolder. Include the following java option: 

          {JAVA_OPTIONS} -Dhttps.protocols=TLSv1.0,TLSv1.1,TLSv1.2"
          export JAVA_OPTIONS 

• Restart the Weblogic& SOA server. 
• Please make sure -Dhttps.protocols="TLSv1.1,TLSv1.2" shows up server.outfile after server startup
• As you can see, the list is comma delimited. If you want support forversion 1.0 through 1.2, you would set the property:

         -Dhttps.protocols="TLSv1.0,TLSv1.1,TLSv1.2"

Phase (3) Server Changes/Configuration:

Login to the Console(http://url:port/console).Go to Server under Environment,choose the following server

3.1) Admin server:

       Under SSL enable tick mark in USE JSSE SSL parameter

       Hostname verification field is to be set to "None" on server side

3.2) SOA server: 

       Under SSL enable tick mark in USE JSSE SSL

       Hostname verification field is set to "None" on server side.

Phase (4) Create a SOA composite and deploy:

4.1)Open JDeveloper , create a SOA Composite according to the business requirement.

4.2)Deploy it in the server.

Integration Between Oracle E-Biz and SFDC ( Create/update an item in Oracle E-Biz )

Introduction

One of the most important business challenges is data consistency between sales data and financial and operational data. Oracle SOA Suite 11g provides a comprehensive suite of components for developing, securing, and monitoring service-oriented architecture (SOA). It also helps enterprise applications to plug into SaaS which is a software delivery model in which software and associated data are centrally hosted on the cloud. Salesforce, on the other hand is one such SaaS application using which we would exhibit how SOA can integrate with the cloud. 

Oracle ERP connect the Salesforce via SOA Suite 11g—suitable for customers who want to integrate item records with Salesforce product records. The goal is to consistently update the product information from Oracle E-Biz to SFDC.In case of any failure, an email will send through OracleE-Biz.

Business Requirement: 

1. Currently the business is getting an Item Data from Oracle E-biz and  then uploaded into SFDC manually.
2. So it should be a more automated process.The intention is to load new & changed item data from Oracle E-biz to SFDC through SOA 11g.

Prerequisites

(A)Oracle E-Biz

1.Create a two Custom Table

• Custom Table 1 (sfdc_item_intf) : Based on the business requirement  dump the record into the custom table 1 from Standard tables.
• Custom Table 2 (sfdc_soa_faulthandler) : Used to handle the SOA failure notification.

2. Create a DB trigger for the Custom table 1(sfdc_item_intf) and indicate it to custom table

3.For Email Notification, Create an E-mail alert program.Ensure Email indicator(any one column) in the Custom Table 2 (sfdc_soa_faulthandler) which is used to send a email of SOA fault to the respective users.

(B) SFDC 

1.Download WSDL file form Salesforce.com

• Login to your Salesforce.com account  (https://login.salesforce.com/) by providing the appropriate credentials. 
• Click on ‘user profile’ and select ‘setup’. 
• On the left hand pane navigate to ‘Develop’ -> ‘API’ 
• Under the Enterprise WSDL subsection click the ‘Generate Enterprise WSDL’ link. 
• Save this file by providing a suitable name(.wsdl) 

2.Certificates (SFDC certificate and Symantec certificate) add in KeyStore

  (A)The process of downloading SSL certificates varies for various browsers.We would display the same for Mozilla Firefox. 

• Click on the ‘lock’ sign that appears on the left side of the address bar. 
• Click on the ‘More Information’ then Click on the ‘View Certificate’ button on this page. 
• Click the Details tab. 
• Symantec Class 3 Secure Server CA –G4 and click on the ‘Export’ button and save it.
• *.salesforce.com and click on the ‘Export’ button and save it .

(B)Following steps to add certificates (SFDC certificate and Symantec certificate) in SOA keystore (we using Linux commands)

Weblogic server’s trust keystore location:

• To know the weblogic server’s trust keystore location, login to admin console  (http://url:port/console/) and get the keystore location from ‘Servers’ under ‘Environment’ subsection. 
• Next, we need to import this certificate from the authority into our weblogic server’s truststore.

Add the Certificates:

• Copy SFDC certificate and Symantec certificate and paste in keystore location.

Add the two SFDC certificates(one by one) in keystore

keytool -importcert -trustcacerts -alias  <<alias_Name>>  -file <<filename_with_extension(.crt)>> -keystoreDemoTrust.jks –storepass DemoTrustKeyStorePassPhrase

Verify the Certificate in DemoTrust.jks

“keytool -list -keystore DemoTrust.jks –storepass DemoTrustKeyStorePassPhrase “

3. Create a JNDI for Database Connnection (DBAdapter)

• Login to admin console  (http://url:port/console/). 
• Goto Domain Structure-->Services-->Data Sources --> Click New (Generic Data Source)
• Enter the Name : soaDB /  JNDI Name: jdbc/soaDB. Click Next 
• Enter the details of connection properties
• Click Next and Test Configuration.
• Choose Server  then Finish.
• Goto the Domain Structure then click Deployment , Click DBAdapter.
• Click Comfiguration --> Outbound Connection Pools --> Click NEW.
• Choose the outbound Connection Group. Click Next.
• Enter the JNDI Name as “ eis/DB/soaDB “ then Finish
• Again Select the Deployment --> Click the Checkbox of DBAdapter
• Update -->Next-->Finish

4.Create a CSF Key:

• Login to admin EM (http://url:port/em). 
• On the left hand side , click the Weblogic domain 
• Right Click on << Domain Name >> --> Security --> Credentials.
• Click Create Map --> Type SOA in Map Name --> OK.
• Click create key and Enter the following details.

          Select Map : SOA

          Key : SFDC_USER_KEY 

          Type : Password

          Username : << Enter the Salesforce Username>>

          Password: << Enter the Password+security token>> 

          Confirm Password: << Enter the Password+security token>>

Creating a SOA Composite

Following steps are to create a SOA Composite.

• We are using Jdeveloper 11.1.1.7 IDE to develop BPEL Process.
• Goto File --> New and select SOA Application and provide a suitable name to your application.
• Click Next and create a SOA project providing a suitable name to it as well.
• Click Next and choose the Composite Template as “Composite with BPEL Process”-->Finish.

1. BPEL Process:

• Enter the Name and choose the Template as “ Define Service Later”.Click Ok.

2.Database Adapter:

• Insert the DB adapter. Enter the Service Name --> Next
• Create a DB Connection 
• Choose operation type as  “Pool for new or Changes Records in a Table”-->Next
• Import table to choose the relevant table to map --> Next
• Select the Primary key -->Choose the required fields-->Next
• Choose “ Update a Field in the Table(Logical Delete)”-->Next.
• In this step, Logical delete --> once the DB gets updated, it indicate with the value of status field.
• Select the any status field in Logical Delete Field and put any value in Read Value.
• Click Next -->Finish.

3.Salesforce Adapter:

• In the right side (External Reference) -->Salesforce adapter
• Enter the Service Name --> Next
• Choose the WSDL File -->choose the authentication key and enter the SFDC credentials.
• Give the TEST CONNECTION -->Next
• In the Cloud Operation Configuration.Choose the following details,

            Operation Category: CORE

            SFDC Operation: Upsert

            Business Objects : << Select the SFDC Objects >>

• Choose AllOrNoneHeader and MruHeader -->Next --> Finish

4. Create a two more DBAdapter for failure notification

When the itemis created/update in Oracle E-Biz, through SOA it will create/update a record in SFDC.In case of any failure SOA reply the error to DB to know Error.So , create two DBAdapter to handle the fault notifications.

• DBAdapter1 : Import Custom Table (already used in previous DBAdapter) In Opertion type : choose “ Perform an Operation on a Table --> Update Only”
• DBAdapter2: Import Fault Handler Table (Create a table in OracleE-Biz)In Opertion type : choose “ Perform an Operation on a Table --> Insert or Update(Merge)”

5.Connect the Adapters.

Create an Activity in BPEL Process

• Right Click on BPEL -->Edit

• Drag the Receive from Component Palette and place in the Main section
• Connect the Receive1 and Left hand side DBADapter and Create Variable in Receive -->OK(as shown below)
• Drag the INVOKE and place under Receive.Then connect the invoke to SFDC Adapter on the right hand side 
• Drag the Transformation from Oracle Extension and place between RECEIVE1 and INVOKE1. 
• Edit the Transformation.Right Click on the SFDC(Target-Side) : externalIDFieldName --> Set Text-->Enter Text-->Enter the ExternalID.Then  map the required fields from source to target.
• Click SAVE.

• To capture the failure notification, we need too add the “CatchAll” .So choose it from main activity.
• Drag the INVOKE and place in CatchALL and connect to DBAdapter1
• Drag the Assign and place before the INVOKE1. Edit the Assign Activity and map the relevant fields. By using Expression get the SOA details.
• Drag Invoke place under Invoke2 ,Connect the Invoke3 and DBAdapter 2
• Drag Assign and place under Invoke2.Edit the Assign Activity to map the fields

Pictorial Representation of BPEL Process

Configuring the Application Server in JDeveloper:

• Click File-->New; Under Genral-->Connections-->Applicaion Server Connection-->Ok
• Enter the  connection Name --> Click
• Give the UserName and Password --> Next
• Give the Details of Congifuration(HostName,Weblogic Domain,Port,SSL Port)-->OK
• Click the Test Connection-->Check 9 of 9 tests successful-->Next.
• Save the Composite and deploy it in server.
• Open EM and click the composite under SOA folder which deployed in the sever.

Test Cases:

1.Create / Update an item in Oracle E-Biz. Check it in SFDC Product objects.

2.While create/ Update an item in Oracle E-Biz, In case of any SOA failure , the error notification is sent back to Oracle E-Biz.Then by using Oracle E-Biz mailing system it send the Error notification to the relevant users.

RTF Colour Template in BI Publisher

Introduction

We can  Colour our Custom RTF Template in Oracle 12.1.3 or later.

1.      The below example demonstrate how to set background Colour on every other row with different conditions in Bi Publisher.

2.   We can add more characters in “Advanced” tab rather than “Form Field Text” box.

Business Requirement

     This report is used to analyze the HR to find out the Salary Percentage of the Employees.  

Example:

The below example shows how to set a background Colour on every other row based on Employee Salary.

If Employee (SALARY>=4500 and SALARY<=100) then background Colour set to #ffffba

If Employee (SALARY>=4500) then background Colour set to   #baffc9

If Employee (SALARY<=500) then background Colour set to #ffb3ba    

If the above condition is not satisfied then background Colour is set to default Colour (i.e White)

We are using “when” and “otherwise” condition tag to handle background Colour.

<?choose:?> <?when:(SALARY<=4500 and SALARY >=2000)?> <?attribute@incontext:background-Colour;#ffffba?> <?end when?> <?when:(SALARY>=4500)?><?attribute@incontext:background-Colour;#baffc9?> <?end when?> <?when:(SALARY<=500)?><?attribute@incontext:background-Colour;#ffb3ba?><?end when?> <?end choose?>

Note: There is limit in BI Publisher to enter conditions in Form Field (i.e. 138 characters).

But in Advanced tab, we can enter 393 characters.

   

Sample RTF:

Last Name	First Name	Hire Date	Salary
F LAST_NAME li	FIRST_NAME li	HIRE_DATE li	SALARY li E

 

 Sample XML File:

Sample Output:

     a)      SALARY>=4500 and SALARY<=100

     b)     SALARY>=4500

                   

    c)      SALARY<=500

  

Oracle Application R12.2.6 fresh Implementation

High level Steps Involved to do the R12.2.6 Fresh Implementation upgrade steps are:

•  Install R12.2.0 with 12c Database using startcd 51.
•  Run ETCC in both database tier and Application tier to get the list of required patches and apply.
•  Upgrade to AD.C.8 and TXK.C.8
•  Apply the R12.2.6 upgrade patch
•  FS_CLONE for filesystem cloning
•  Apply the Help patch. 

Install R12.2.0 with 12c Database

1. Download EBS Installation Packages, Oracle E-Business Suite (12.2.0)

 p22066363_R12_GENERIC.zip

 V100052-01_1of3.zip

 V100052-01_2of3.zip

 V100052-01_3of3.zip

 V100059-01_1of2.zip

 V100059-01_2of2.zip

 V100060-01_1of3.zip

 V100060-01_2of3.zip

 V100060-01_3of3.zip

 V100061-01.zip

 V100102-01.zip

 V29856-01.zip

 V35802-01.zip

 V35803-01_1of3.zip

 V35803-01_2of3.zip

 V35803-01_3of3.zip

 V35804-01_1of2.zip

 V35804-01_2of2.zip

 V46095-01_1of2.zip

 V46095-01_2of2.zip

 V75792-01.zip

=============================================================================================

 2. Download EBS Installation Packages, Oracle E-Business Suite (12.2.6)

 V776670-01_10of10.zip

 V776670-01_1of10.zip

 V776670-01_2of10.zip

 V776670-01_3of10.zip

 V776670-01_4of10.zip

 V776670-01_5of10.zip

 V776670-01_6of10.zip

 V776670-01_7of10.zip

 V776670-01_8of10.zip

 V776670-01_9of10.zip

=============================================================================================

3. Create Stage

cd  /home/admin/Downloads/12.2.0/startCD/Disk1/rapidwiz/bin/

./buildStage.sh 

Oracle E-Business Suite Rapid Install

Version 12.2.0

Press Enter to continue...
Build Stage Menu
--------------------------------------------------------
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu

Enter your choice [4]: 1

Rapid Install Platform Menu

1. Oracle Solaris SPARC (64-bit)
2. Linux x86 (64-bit)
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu

Enter your choice [5]: 2

Running command:
……………..........
Specify the directory containing the zipped installation media:
/ebssetupfiles/EBS1226/

File list:
/ebssetupfiles/EBS1226/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat

Return to the Oracle Software Delivery Cloud and download them:
================================================================

Part number: V100053-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_1of2.zip
================================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_2of2.zip

================================================================

Part number: V100054-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2
File name: V100054-01.zip
================================================================

Part number: V100055-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3
File name: V100055-01.zip

================================================================

Part number: V100056-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4
File name: V100056-01.zip

================================================================

Part number: V100057-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5
File name: V100057-01.zip

================================================================

Part number: V100058-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6
File name: V100058-01.zip

================================================================

WARNING: Some of the required zip files have not yet been downloaded. Do you want to continue, and obtain them later? (Y)/N

Y

Since we are doing a fresh Install of R12.2 we do not require the files for VISION, so we can skip the above Warning message.

Note that: During creation of stage , enter to continue couple of times

=============================================================================================

 4.Start E-Business Installation / EBS 12.2.0 installation

   cd  /home/admin/Downloads/12.2.0/startCD/Disk1/rapidwiz

   ./rapidwiz
 

  Now follow the screens

Click on next 

Click on next 

Disable security updates via My Oracle Support and click on next button

Enter the Port values for both Filesystem1 and Filesystem2 and click on next 

Enter the values and click on next 

Choose the Suite licensing and click on next

Select the additional products and click on next

Select the additional products and click on next

Click on next

Choose the language and click on next

Enter the application node configuration details and click on next

Choose the Password and Click on next 

Click on next 

If we get Inventory related errors for database pre-install checks and/or for filesystems,  fix them as documented below ;

Database Pre-installchecks;

Create oraInst.loc file and point it to the inventory location, which can be ORACLE_BASE directory.
ORACLE_HOME=/u01/oracle/CRP/12.1.0
ORACLE_BASE=/u01/oracle/CRP

So the orainventory should be in ora base directory

Example:
$ cat /etc/oraInst.loc

inventory_loc=/u01/oracle/CRP/oraInventory
inst_group=dba
 
 For filesystem check error ;
chmod –R 777 /u01   (or any appropriate file permissions)

Click on next 

Click on next 

If we get the error for "Virtual directory" follow the below steps.

Error:

RW-50016: Error: - {0} was not created:

      File = {1}

Solution
=======
To implement the solution please perform following:

1. Please check whether the following two rpms are present:

a. compat-libstdc++-33-3.2.3-69.el6.i686.rpm
b. compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm

2. If not install them and perform relink as below:

$ adrelink.sh force=y "fnd FNDWRR.exe"

Stop all application services

3. Retry rapidwiz and then your installation will get completed successfully

Click on next 

After installation is completed we can connect to the EBS and check the version 12.2.0 and go for next step for 12.2.6 upgrade...

=============================================================================================

At this point, EBS 12.2.0 installation is complete, so we continue with the EBS 12.2.6 upgrade.

Run ETCC in both database tier and Application tier to get the list of required patches and apply.

5.PREPARING for 12.2.0 to 12.2.6 upgrade

APPLYING TECHNOLOGY PATCHES FOR 12.2.0 Oracle E-Business Suite Release 12.2.6 Readme Master Note

1 EBS Technology Codelevel Checker (ETCC) (Doc ID 1594274.1) 

Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers.

Download patch 17537119

Upload patch to DB and APP node 

For DB Node : 

mkdir –p $ORACLE_HOME/appsutil/etcc
copy all files in the patch to the directory “mkdir –p $ORACLE_HOME/appsutil/etcc”
cd $ORACLE_HOME/appsutil/etcc
./checkDBpatch.sh

Patch recommendation summary for Database

Patch 23595848

- Filename: p23595848_121020_Linux-x86-64.zip

Patch 18793246--

- Filename: p18793246_121020_Generic.zip

Patch 23745950--

- Filename: p23745950_121020_Linux-x86-64.zip

Patch 19591608

- Filename: p19591608_121020_Linux-x86-64.zip

Patch 19908836--

- Filename: p19908836_121020_Linux-x86-64.zip

Patch 24481723--

- Filename: p24481723_121020_Linux-x86-64.zip

Patch 22098146--

- Filename: p22098146_121020_Linux-x86-64.zip

Patch 21286665--

- Filename: p21286665_121020_Linux-x86-64.zip

Patch 21321429--

- Filename: p21321429_121020_Generic.zip

Patch 21387964--

- Filename: p21387964_121020_Linux-x86-64.zip

Patch 21864513--

- Filename: p21864513_121020_Linux-x86-64.zip

Patch 21904072--

- Filename: p21904072_121020_Linux-x86-64.zip

Patch 21967332

- Filename: p21967332_121020_Linux-x86-64.zip

Patch 22338374

- Filename: p22338374_121020_Linux-x86-64.zip

Patch 22496904--

- Filename: p22496904_121020_Linux-x86-64.zip

Patch 22731026--

- Filename: p22731026_121020_Generic.zip

Patch 23089357--

- Filename: p23089357_121020_Linux-x86-64.zip

Apply the above patches using opatch

Example: 

export PATH=$PATH:$ORACLE_HOME/OPatch

To Check the patch: 

opatch lsinventory | grep 19908836

cd 18793246

To Apply the Patch:

opatch apply

For APP Node : 

cd <ETCC patchdirectory> 

./checkMTpatch.sh

Patch recommendation summary

One or more products have bugfixes missing.

The default patch recommendations to install these missing bugfixes are:

Oracle Forms and Reports 10.1.2.3.0

Patch 22698265

- Filename: p22698265_101232_LINUX.zip

Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

Patch 22288381

- Filename: p22288381_111190_Generic.zip

Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

Patch 9905685

- Filename: p9905685_111190_Generic.zip

Patch 21366277

- Filename: p21366277_111190_Generic.zip

Patch 21628307

- Filename: p21628307_111190_Generic.zip

Oracle WebLogic Server (WLS) 10.3.6.0.7

Patch 20780171 [SU Patch [EJUW]: WLS PSU 10.3.6.0.12]

- Filename: p20780171_1036_Generic.zip

Patch 22323006 [SU Patch [DI8E]]

- Filename: p22323006_1036_Generic.zip

 EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR 161018 AND 160719

CheckMTpatch Apply

Connecting to database.

Database connection successful.

Oracle Forms and Reports

1.unzip Patch file

2.set Oracle home

  export Oracle Home = /u01/oracle/CRP/fs1/EBSapps/10.1.2.

3.set path

  export PATH=$ORACLE_HOME/OPatch:$PATH

4.opatch lsinventory|grep 22698265

5.cd 22698265

6.opatch apply

Oracle Fusion Middleware (FMW) - Web Tier

1.unzip Patch file

2.set Oracle home

  export Oracle Home = /u01/oracle/CRP/fs1/FMW_Home/webtier

3.set path

  export PATH=$ORACLE_HOME/OPatch:$PATH

4.opatch lsinventory|grep 22288381

5.cd 22288381

6.opatch apply

Oracle Fusion Middleware (FMW) - oracle_common

1.unzip Patch file

2.set Oracle home

  export Oracle Home = /u01/oracle/CRP/fs1/FMW_Home/oracle_common

3.set path

  export PATH=$ORACLE_HOME/OPatch:$PATH

4.opatch lsinventory|grep 9905685

5.cd 9905685

6.cd oui

7.opatch apply

Oracle WebLogic Server (WLS)

1. copy file (20780171)  to /u01/oracle/CRP/fs1/FMW_Home/util/bsu/cache_dir

2. unzip file (20780171)

3. check the .jar file

    ls -ltr *.jar

4. cd  /u01/oracle/CRP/fs1/FMW_Home/util/bsu

5. check the Display

    echo$DISPLAY

    echo$DISPLAY=:1:0

6 To apply the Patch
   . ./bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/
   cache_dir -patchlist=EJUW - prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
 

7.  To apply patches, first you have to apply patch number 20780171 but you may have conflict warning with the previous patches which has older PSU patches because 20780171 patch number is PSU 10.3.6.0.12 patch

we removed the below patches using following commands

 Delete the files - YSAP,BLTC,1LRI,VKXF,2GYW,CWGT,FCX7

   ./bsu.sh -remove -patchlist=Y5AP -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

   ./bsu.sh -remove -patchlist=BLTC -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

   ./bsu.sh -remove -patchlist=1LRI -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

   ./bsu.sh -remove -patchlist=VKXF -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

   ./bsu.sh -remove -patchlist=2GYW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

   ./bsu.sh -remove -patchlist=CWGT -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

   ./bsu.sh -remove -patchlist=FCX7 -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

8. Once again apply
  ./bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir -          patchlist=EJUW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

9. Run ETCC again to get the patch list

    13729611 [L34G]

    17319481 [N5FK]

    19259028 [TY4S]

    19687084 [8FBW]

    22128205 [GK5N]

    22323006 [DI8E]

9. Download the above patch list

10.Unzip patches.

11.To install the the patches using following commands

    bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir -               patchlist=L34G -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

    bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir -               patchlist=N5FK -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

    bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir -               patchlist=TYHS -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

    bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir -               patchlist=8FBW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

    bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir -               patchlist=GK5N -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

    bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir -               patchlist=DI8E -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

12. To check  the MTpatchlist again run the following

      ./checkMTpatch.sh

   Now you should get the message as "All required patches are present"

13. Download the Consolidated seed patches and AD C, TXK  and Postpatches

     
      Consolidated seed patches:
      p17204589_12.2.0_R12_GENERIC.zip

      p21900871_12.2.0_R12_GENERIC.zip
      AD C.8 patches:
      p21841299_R12.AD.C_R12_LINUX.zip

      p24578455_R12.AD.C_R12_GENERIC.zip

      p24494551_R12.AD.C_R12_GENERIC.zip

      p25025325_R12.AD.C_R12_GENERIC.zip
     TXK.C.8 patches:

      p18525466_R12.TXK.C_R12_GENERIC.zip

      p23569114_R12.TXK.C_R12_GENERIC.zip

      p23705992_R12.TXK.C_R12_GENERIC.zip

14. All Downloaded files are moved to /u01/oracle/CRP/fs_ne/EBSapps/Patch

15. Unzip the patch files.

=============================================================================================

6.Apply Consolidated Seed Table Upgrade Patch (Required)

sh$ADMIN_SCRIPTS_HOME/adstpall.sh

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes

Start up all application tier services.

=============================================================================================

Upgrade to AD.C.8 and TXK.C.8

7.Apply the R12.AD.C.Delta.8 and R12.TXK.C.Delta.8 Release Update Packs

Start up only the Oracle Weblogic Admin Server on the run edition application tier file system.

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

 AD.C

Usage:

**** Patch 21841299 ****

1. Create $ORACLE_HOME/appsutil/admin on the database server.

2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin  to that in patch directory.

3. Copy the higher version of adgrants.sql (UNIX) to

$ORACLE_HOME/appsutil/admin.

4. Set the environment to point to ORACLE_HOME on the database server.

5. Use SQL*Plus to run the script:

UNIX:

$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql<APPS schema name>

adop phase=apply patches=21841299 hotpatch=yes

Instructions for running AD Grants  *** check adgrants in patch 24494551.

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

Usage:

1. Create $ORACLE_HOME/appsutil/admin on the database server.

2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.

3. Copy the higher version of adgrants.sql (UNIX) to

$ORACLE_HOME/appsutil/admin.

4. Set the environment to point to ORACLE_HOME on the database server.

5. Use SQL*Plus to run the script:

UNIX:

$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql<APPS schema name>

adop phase=apply patches=24578455,24494551,25025325 merge=yes

TXK C

adop phase=apply patches=21830810 hotpatch=yes

adop phase=apply patches=18525466,23569114,23705992 hotpatch=yes merge=yes

After applying this patch, update all Database Tier Nodes with the code level provided by this patch, by performing the following steps :

**** After applying the above Patch 23705992 ***

1. On the Application Tier (as the APPLMGR user):

. Run AutoConfig on the RUN file system.

Note:

Customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfigtemplates provided via this patch before running AutoConfig.

. Source the environment variables for Oracle Applications

UNIX:

. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env

. Execute admkappsutil.pl utility to create the file appsutil.zip

perl<AD_TOP>/bin/admkappsutil.pl

This will create appsutil.zip in <INST_TOP>/admin/out

Note:

For exact details on how to run Autoconfig and how to create appsutil.zip, please refer to the Oracle E-Business Suite Setup Guide for Release 12.2.

2. On the Database Tier (as the ORACLE user):

. Source the environment variables for RDBMS ORACLE_HOME

UNIX:

cd <RDBMS ORACLE_HOME>

. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env

. Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>

. Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>

cd <ORACLE_HOME>

unzip -o appsutil.zip

3. Re-run adpreclone.pl on the database tier and on the primary node of the Application tier

Note:

Since new updates included in this patch have been applied to the system, adpreclone must be executed again in order to apply them into the clone directory structures used during cloning.

perl adpreclone.pl dbTier

perl adpreclone.pl appsTier

Migrate Latest Code to Database Tier

Update all database tier nodes with the latest code, by performing the following steps:

On the Application Tier (as the APPLMGR user):

Source the environment variables for Oracle E-Business Suite.

UNIX

$ . ./<APPL_TOP>/APPS<CONTEXT_NAME>.env

Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out.

$ perl<AD_TOP>/bin/admkappsutil.pl

On the Database Tier (as the ORACLE user):

Source the environment variables for RDBMS ORACLE_HOME.

UNIX

$ cd <RDBMS ORACLE_HOME>

$ . ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>  .env

Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.

Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.

$ cd <ORACLE_HOME>

$ unzip -o appsutil.zip

Run AutoConfig on <RDBMS ORACLE_HOME>.

Note: For more details, refer to Oracle E-Business Suite Setup Guide, Release 12.2.

Run AutoConfig on the run file system.

On the Application Tier (as the APPLMGR user):

Run AutoConfig on the run file system.

Note: Before running AutoConfig, customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfig templates provided via this patch.

Note: For exact details on how to run AutoConfig and how to create appsutil.zip, refer to the Oracle E-Business Suite Setup Guide, Release 12.2.

=============================================================================================

 Apply the R12.2.6 upgrade patch

8. Apply Oracle E-Business Suite 12.2.6 Release Update Pack

1.Source the run edition applications environment.

UNIX:

$.<INSTALL_BASE>/EBSapps.env run

2.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, WeblogicAdminServer 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.

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

UNIX:

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

b.Stop the Node Manager service on the run file system.

UNIX:

$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

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

UNIX:

adop phase=apply apply_mode=downtime patches=21900901

4.Start all application tier services on the run file system.

UNIX:

sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

FS_CLONE for filesystem cloning

5.Perform adop cleanup action.

     UNIX:

     adop phase=cleanup

6. Synchronize file systems

Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the other file system, to ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.

     UNIX:

     adop phase=fs_clone

================================================================================

Apply the Help patch. 

9.Post-Update Steps

Apply Oracle E-Business Suite Release 12.2.6 Online Help Patch 21900918 using adophotpatch mode on the run file system.

adop phase=apply patches=21900918 hotpatch=yes