Oracle E-Business Suite upgrade from 12.1.1 to 12.2.7

This is a step by step upgrade of EBS 12.1.1 to EBS 12.2.7. EBS 12.2.7 was released on September, 8^th 2017 and more details can be found under https://blogs.oracle.com/stevenchan/oracle-e-business-suite-1227-now-available.

There is no direct upgrade path from EBS 12.1.1 to EBS 12.2.7. Release 12.1.1 customers must first upgrade to EBS 12.2 before applying 12.2.7.

The following is a summary of the steps for each category:

1.Prepare the Database

2.Upgrade the database to the minimum version or latest certified version

3.Migrate to a new platform (optional)

4.Apply the latest database patches

5.Lay Down the Oracle E-Business Suite Release 12.2 File System

6.Use Rapid Install to lay down the file system and technology stack

7.Apply the latest application tier technology stack patches

8.Upgrade to Release 12.2.0

9.Apply the latest AD upgrade patch and Oracle E-Business Suite Consolidated Upgrade Patch (CUP)

10.Apply the latest Oracle E-Business Suite pre-install patches

11.Apply the 12.2 merged upgrade driver

12.Run Rapid Install in 'configure' mode

13.Enable Online Patching

14.Apply the latest Online Patching Readiness Report Patch

15.Apply required updates to custom code according to the readiness reports

16.Apply the enablement patch

17.Upgrade to the latest code

18.Apply the latest AD-TXK RUP

19.Apply the latest Oracle E-Business Suite Release 12.2 Release Update Pack (RUP)

Note: You must apply the 12.2.3 or later Release Update Pack (RUP) to your existing Release 12.2 system for production use.

RUPs are released periodically. Each one is cumulative and delivers error corrections and system updates, not only for the most current release update pack, but also for all the RUPs that precede it. Oracle highly recommends that when planning your upgrade you plan to upgrade to the latest RUP available.

You can keep current on the latest release information, as well as new RUP announcements and other updates that may affect your upgrade by reviewing the latest version of Oracle Applications Release Notes Release 12.2.0.

20.Complete post-upgrade steps

21.Apply the latest security patches

22.Apply all recommended patches

23.Apply NLS patches (conditional)

24.Deploy custom code, external integrations and third-party integrations

25.Perform advanced configurations

26.Scale up and/or scale out (add additional managed servers, add application tier nodes, add RAC nodes, and so on)

Note: The upgrade process is performed with one application tier and one database tier. If you are using an Oracle RAC environment, then you should run the Release 12.2 upgrade on a single Oracle RAC node. The reason for upgrading with a single Oracle RAC node is that most of the elapsed time in the upgrade will be taken by jobs running DML (INSERT, UPDATE, DELETE). These jobs use multiple workers and parallel servers, which typically attempt to access the same objects and blocks concurrently. The consequent additional communication between cluster nodes (and associated cluster waits) significantly outweigh any gains from using the additional CPU's to increase throughput. Scaling out is a post-upgrade step.

27.Secure configurations

28.DMZ configuration

29.Disaster recovery setup

30.Reporting environment setup

31.Perform product specific tasks

Some products include tasks that must be performed after the upgrade is complete. The main project steps can be segregated as below:

Phase 1      

• Upgrade the database on the existing EBS 12.1: apps DBA team      
• Execute a functional test: EBS functional team

Phase 2      

• Install all application pre-upgrade patches: apps DBA team      
• Verify the instance: EBS functional team

Phase 3      

• Execute all functional pre-upgrade tasks including customizations: functional team      
• Perform a full system backup: System and apps DBA team   

 Phase 4      

• Apply localization and 12.2 pre-upgrade patches: apps DBA team      
• Upgrade to 12.2.0: apps DBA team      
• Enable online patching: apps DBA team      
• Apply tech stack patches: apps DBA team      
• Upgrade to 12.2.6/12.2.7: apps DBA team      
• Perform all post-upgrade tasks: apps DBA and functional teams      
• Application function test cases: core business users.

So without further delay, let’s jump to the steps.

I had an EBS 12.1.1 running with Database 11.1.0.7. As part of the process, the database has to be first upgraded to minimum version(11.2.0.4) or latest certified version.

 I have upgraded the database first to 12.1.0.2.

You can refer to my blog on how to upgrade http://samappsdba.blogspot.in/2017/01/ebs-db-11107-upgrade-to-12c-12102.html

Now my current environment is

EBS -12.1.1 running with Database-12.1.0.2

Now the upgrade process:-

1. Back up database, Oracle E-Business Suite, and customizations (recommended): Note: Shut down the database with the NORMAL option. You may not be able to restore it from the backup if you use the IMMEDIATE or ABORT option.

2. If there any customizations, take a backup of those and customized help files(HTML)

3. If you have customized forms with Oracle Forms 6i, then upgrade them to Oracle Forms 10i after the upgrade

4. Drop event alert triggers in custom schemas (conditional):

To drop all event alert database triggers in custom schemas, run the alrdtrig.sql script,

located in $ALR_TOP/patch/115/sql. Re-create the triggers after the upgrade is

complete.

5. Review sizes of old and new tablespaces (required): Make sure you allocate sufficient tablespace. For guidelines, see Oracle E-Business Suite Release 12.2: Upgrade Sizing and Best Practices (Doc ID: 1597531.1).

6. Migrate Existing Objects to New Tablespace Model (recommended): Oracle E-Business Suite Release 12 environments contain the new Oracle Applications Tablespace Model (OATM). This model is based on database object type rather than product affiliation, making it simpler to manage and requiring far fewer tablespaces and operating system files. If you previously upgraded your environment from Release 11i to Release 12, then the upgrade process created tablespaces for all new products, configured the database for the new tablespace model, and created new objects. However, it did not automatically migrate your existing objects. If you have not already done so, Oracle strongly recommends that you use the Tablespace Migration Utility to perform this migration now. Note that this utility is not supported for use after you enable Online Patching, so you cannot perform the migration after your environment is upgraded to Release 12.2. If you choose not to migrate to OATM now, then you must continue to manage your tablespaces separately. For more information, see the Oracle E-Business Suite Setup Guide, Release 12.2.

7. Gather SYS, Fixed Object and Dictionary Statistics (required)

login as sysdba

begin  

dbms_stats.gather_schema_stats(      'SYS',      options=>'GATHER STALE',      estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,      method_opt => 'FOR ALL COLUMNS SIZE AUTO',      cascade => TRUE); end; /

2. Fixed Object and Dictionary Statistics

8. Gather schema statistics (required)

9. Install JRE on the database tier (conditional)

10. Reset init.ora parameters (required)

Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)

Additional Database Initialization Parameters For Oracle E-Business Suite Release 12.2

SQL> ALTER SYSTEM SET recyclebin = OFF scope=spfile;

System altered.

SQL>  show parameter service

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

service_names                        string      PROD

SQL> alter system set service_names=PROD,ebs_patch scope=spfile;

System altered.

SQL>  alter system set local_listener='PROD_LOCAL' scope=spfile;

System altered.

SQL>  alter system set local_listener='PROD_LOCAL' scope=spfile;

System altered.

Set SQLNET.ALLOWED_LOGON_VERSION=8 in the oracle_home/network/admin/sqlnet.ora file.

Restart your database

Human Resource Management (HRMS)

SQL>  SELECT package_name,object_name,argument_name,data_type FROM all_arguments WHERE (package_name,object_name) IN (SELECT call_package,call_procedure FROM hr_api_hook_calls) AND data_type = 'LONG';

PACKAGE_NAME

--------------------------------------------------------------------------------

OBJECT_NAME

--------------------------------------------------------------------------------

ARGUMENT_NAME

--------------------------------------------------------------------------------

DATA_TYPE

------------------------------

PSB_HR_POPULATE_DATA_PVT

INSERT_POSITION_TXN_INFO

P_COMMENTS

LONG

Changed long to CLOB

Ref : https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T580873.htm#T609999

Stage Creation (Root user)

R12.2: How to Create the Stage in Preparation for Installation (Doc ID 1596433.1)

This should be done using the latest startCD. At the time of writing this blog, the latest one is startCD51.

Build the stage

[root@ebs1 bin]# sh buildStage.sh

                     Copyright (c) 2002, 2013 Oracle Corporation

                        Redwood Shores, California, USA

                       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:

/u01/stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /u01/stage/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64

Specify the directory containing the zipped installation media:

/u01/stage

File list:

/u01/stage/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat

The set of zip files is complete.

Unzip command is: /u01/stage/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o

Press Enter to continue...

Archive:  /u01/stage/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14272383/p14272383_1036_Generic.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/20484781/p20484781_111190_Generic.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/16241466/p16241466_10123_LINUX.zip

                     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]: 2

         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

Directory /u01/stage/TechPatches

Stage Builder will now stage the one-off patches for Linux_x64...

Press Enter to continue...

Press Enter to continue...

Archive:  /u01/stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip

Finished copying additional patches.

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]:4

Now, start the rapidwiz process.

Now layout EBS 12.2 file system using existing Oracle Home

I will be updating the full steps here once i get time. Meanwhile, please contact me over my email samratsinha05@gmail.com if you want the complete step by step document. 

:

References:-

Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)
https://docs.oracle.com/cd/E26401_01/doc.122/e48839.pdf-upgrade guide
Best Practices for Minimizing Oracle E-Business Suite Release 12.1.3 and 12.2.n Upgrade Downtime (Doc ID 1581549.1)

R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)
Upgrade Advisor: E-Business Suite (EBS) Upgrade from 12.0/12.1 to 12.2.x (Doc ID 1593640.1)
Oracle E-Business Suite Reducing Downtime Upgrading to 12.1/12.2 (Doc ID 1578187.1)

Oracle Database is getting older now

For those who are not aware, Oracle Database 12C release 2 which is 12.2.0.1 is in market for months now. Previously, Oracle used to release their products based on PSUs and BPs. A few weeks ago, it has now been changed to RURs (Release Update Revisions) and RUs (Release Updates) beginning with Oracle Database 12.2.

So what it means for us. There won't be 12.2.0.2 anymore or 13C. Instead, it will be named as Oracle 18 and so on. Thus Oracle is getting older day by day now..:)

Keep learning

References:
https://mikedietrichde.com/2017/08/10/thoughts-new-oracle-database-release-schedule/

https://mikedietrichde.com/2017/08/09/news-new-oracle-database-release-schedule/

Oracle EBS 12.2.6 Single Sign on using OID, OAM 11G

Before directly jumping down to the steps, let us find some differences between the integrations of OAM/OID with EBS 12.2 and EBS 12.1

In EBS 12.2, it has the built in Weblogic techstack which has drastically modified the steps on how it integrates with FMW products such as OAM. Thus in a nutshell, steps have been reduced when we integrate EBS 12.2 with OAM/OID.

In EBS 12.1, the high level steps are as follows:

     1. Install EBS 12.1.X

     2. Install separate Weblogic and top of it OID/OAM

     3. Install OHS 11g server and install Webgate on top of it

     4. Install another welogic server and accessgate on top of it

     5. Integrate webgate, accessgate to work with EBS and OID/OAM

                          Images are from Overview of Single Sign-On Integration Options for Oracle E-Business Suite (Doc ID 1388152.1)

      In EBS 12.2, the high level steps are as follows

     1. Install EBS 12.2.X

     2. Install separate Weblogic and top of it OID/OAM

     3. R12.2 has built in OHS 11g and weblogic server. 

     4. Deploy and configure webgate on top of R12.2 OHS 11g

     5. Deploy and configure accessgate on a separate managed server on top of r12.2 weblogic.

     6. Integrate webgate, accessgate to work with EBS and OID/OAM

Images are from Overview of Single Sign-On Integration Options for Oracle E-Business Suite (Doc ID 1388152.1)

 Let’s brush up some basics first before going into the installation

Oracle Internet Directory (OID)

Oracle Internet Directory (OID) is Lightweight Directory Access Protocol (LDAP) server from Oracle where all enterprise users are stored. Users in OID are synchronized with users in EBusiness Suite (EBS) using Directory Integration Platform (DIP). Oracle Access Manager(OAM) should use OID (or Oracle Virtual Directory- OVD pointing to this OID) as its identity store for authentication.

Directory Integration Platform (DIP)

Directory Integration Platform (DIP) 11g is J2EE application deployed on WebLogic server and used for provisioning/synchronization of users/groups across other LDAP servers and applications. DIP consists of two type of engine, Synchronization and Provisioning. Synchronization component is used to sync users/groups between OID and other LDAP servers like Microsoft Active Directory (MS-AD) or IBM Directory Server. Provisioning is used to sync OID with applications like EBS, Portal, and Collaboration Suite. For user synchronization between OID and EBS, DIP uses its provisioning component.

Oracle Directory Services Manager (ODSM)

Oracle Directory Services Manager (ODSM) is a web application deployed on WebLogic server and used to manage OID using web browser. Using ODSM you can configure/manage OID, and create/delete users/groups.

Oracle WebLogic Server (WLS)

Oracle WebLogic Server (WLS) is J2EE Application Server from Oracle. WebLogic Domain is logical component in which all resources (Admin Server, Managed Server, Java Database Connectivity(JDBC), Java Messaging Server(JMS)) are deployed/configured. WebLogic Domain consists of one and only one Admin Server and zero or more managed server. 

Oracle Access Manager (OAM)

Oracle Access Manager is a J2EE application deployed on Weblogic Server and used as Authentication & Authorization Server. OAM Server consists of OAM Server deployed on WebLogic Managed Server (default port 14100). There is OAM-Proxy server running in background on default port 5575. Agents (WebGate) connect to OAM-Proxy Port. OAMConsole is web application deployed on WebLogic Admin Server (default port 7001). OAM Console application is used to manage configuration, and define/manage policies, authentication schemes.

OAM Configuration is stored in XML file (oam-config.xml) on server and contains all OAM configuration like server name, port, webgate details, and audit store details. If we want to change the admin server port, then we need to shut down admin server and managed server first, then we need to change the listen port under config.xml file and start the admin, managed servers to take the new port. OAM Policy Store is a repository (database) which stores policy (details like which URL is protected and using what authentication/authorization schemes)

Oracle HTTP Server (OHS)

Oracle HTTP Server is a Web Server from Oracle on which Web Gate is deployed. Users are redirected from EBS Middle Tier to this server for authentication (URL of this server is configured in EBS Profile option “Application Authentication Agent”). OHS acts as proxy server to WebLogic Server on which EBS AccessGate (EBS-AG) is deployed. This OHS server also has mod_wl_ohs configured to forward request to WebLogic Server where Oracle EBusiness Suite AccessGate (EBS-AG) is deployed. E-Business Suite R12 comes with its own OHS server, OHS server mentioned here is different OHS server than one shipped with EBS R12 technology stack. 

Web Gate

Web Gate is a web server plug-in (deployed with WebServer like Apache, OHS, IHS) which intercepts user's request and send it to Oracle Access Manager Server to check if user is authenticated/authorized to access requested resource. Web Gate is installed on same machine as WebServer (OHS) and webgate configuration settings are pointed OHS configuration file(httpd.conf). For Web Gate to work an instance of Web Gate must be configured in OAM Server using Remote Registration (REG) utility or OAMConsole and Web Gate must be installed with OHS using same user as OHS.

Oracle E-Business Suite Access Gate

EBS AccessGate (EBS-AG) is a Java EE Application that maps a Single Sign-On user (authenticated via OAM) to an Oracle E-Business Suite user (stored in FND_USER table), and creates E-Business Suite session for that user. EBS-AG is deployed on WebLogic Server using ANT script which creates a web application and JDBC connection to EBS Database. Login Page for E-Business Suite is also configured as part of EBS AG.

Profile Option

Profile Option is used in E-Business Suite to update behavior of environment. Profile option which are used in Oracle E-Business Suite are Application SSO Type and Application

Authentication Agent

Application SSO Type (APPS_SSO) - This profile option can be set only at site level from one of four values SSWA, Portal, SSWA w/SSO or Portal w/SSO. To inform E-Business Suite that Single Sign-On is configured and redirect user to Single Sign-On Page and not to Local Login page, set this profile option to either SSWA w/SSO or Portal w/SSO

Application Authentication Agent (APPS_AUTH_AGENT) – 

When this profile option is set with "Application SSO Type", user is redirected page generated from this profile option. Lets assume value of profile option "Application SSO Type" is set to http://ohsserver:ohsport/ebsauth_dev/,  then user will be redirected to page http://ohsserver:ohsport/ebsauth_dev/OAMLogin.jsp. Value of profile option "Application Authentication Agent " is set to format http://server:port/<context_root> where server is name of server where Oracle HTTP Server (OHS) with Web Gate is installed, port is OHS Listen Port and context_root is context root defined during AccessGate configuration.

Request Flow for E-business Suite integrated with OAM/OID

1.User access E-Business Suite URL http://<ebs_mid_tier>:<ebs_ohs_port> or http://<ebs_mid_tier>:<ebs_ohs_port/OA_HTML/AppsLogin . EBS checks

that profile option “Application SSO Type” is set to Portal w/SSO or SSWA w/SSO

(w/SSO signifies that EBS is integrated with Single Sign-On Server).

2.EBS then check value of profile option “Application Authentication Agent” (value is set to  

http://<ohs_with_wg>:<ohs_with_wg:port>/<context_root>/ , where <context_root>

is value set during E-Business Suite Access Gate Deployment) and redirect user to value

set for “Application Authentication Agent”.

3.Web Gate deployed with OHS server then check if any token (Cookie) is available in user session 

and forwards this request to OAM server for validation.

4.OAM server will then check authentication URL configured for Web Gate (Host:Port or Host  

Identifier) and redirect user to authentication page configured by authentication

URL. User will then type username/password, which OAM will validate against OAM’s

identity store (Oracle Internet Directory). Oracle Internet Directory will validate

username and password against UID (login attribute) and userPassword (password

attribute)

5.On successful authentication OAM will forward response back to WebGate with generate

Cookie

6.Web Gate will then redirect user to E-Business Suite Access Gate for user validation or user 

Mapping

7.E-Business Suite Access Gate will take this user ID and map/validate against user in 

EBusinessSuite (FND_USER)

8. On successful validation response is returned back to Web Gate

9. Web Gate will forward response to user

10.User with token/cookie from WebGate/Access Gate to E-Business Middle Tier

11. E-Business Suite Middle Tier will generate E-Business Suite specific cookie to user and in subsequent requests, user talks directly to Oracle E-Business Suite until explicit log out or timeout

   Note: User in E-Business Suite (FND_USER) are synchronized with Oracle Internet Directory using Directory Integration Platform’s Provisioning Framework

Steps to integrate Oracle EBS R12 with OAM for Single Sign-On

Assumptions:

1. 12.1.0.2 database

2. JDK-6u45 for OAM and JDK-1.7.0_141 for OID

3. Weblogic server 10.3.6

4. RCU 11g

5. Oracle Identitiy management 11.1.1.9

6. Oracle access management 11.2.0.3

7. EBS 12.2.6

If you need the step by step document, please contact me at samratsinha05@gmail.com.

Adop phase=prepare failing with error [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on ebs1

As part of EBS 12.2.6 integration with OID, i was trying to run adop phase=prepare in the patch file system and i encountered the below error

[UNEXPECTED]Error occurred running "perl /u01/r12/application/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/r12/application/fs1/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml -patchctxfile=/u01/r12/application/fs2/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml -phase=prepare -logloc=/u01/r12/application/fs_ne/EBSapps/log/adop/3/20170226_034703/prepare/validate/ebs1 -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on ebs1


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 1 (Fail)



The detailed error was




Use of uninitialized value $result in split at /u01/r12/application/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/r12/application/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.



The solution is mentioned in one of the metalink note:Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)

[applmgr@ebs1 validations]$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Sun Feb 26 04:34:29 2017

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';

no rows selected

SQL>
[applmgr@ebs1 application]$ . ./EBSapps.env

  E-Business Suite Environment Information
  ----------------------------------------
  RUN File System           : /u01/r12/application/fs1/EBSapps/appl
  PATCH File System         : /u01/r12/application/fs2/EBSapps/appl
  Non-Editioned File System : /u01/r12/application/fs_ne


  DB Host: ebs1.oracle.com  Service/SID: PROD


  E-Business Suite Environment Setting
  ------------------------------------
  - Enter [R/r] for sourcing Run File System Environment file, or
  - Enter [P/p] for sourcing Patch File System Environment file, or
  - Enter anything else to exit

  Please choose the environment file you wish to source [R/P]:P

  Sourcing the PATCH File System ...

[applmgr@ebs1 application]$ echo $CONTEXT_FILE
/u01/r12/application/fs2/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml
[applmgr@ebs1 application]$


$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=/u01/r12/application/fs2/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml \
logfile=/tmp/patchctxupload.log
run the query to validate

Run the below query again to validate


select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') =