Oracle E-Business Suite Release 12.2.4 Readme

Section 1: Preparation
Section 2: Apply Required Database Patches
Section 3: Apply Consolidated Seed Table Upgrade Patch (Required)
Section 4: Apply the Latest AD and TXK Delta Release Update Packs
Section 5: Perform Pre-Update Steps (Conditional)
Section 6: Apply Oracle E-Business Suite 12.2.4 Release Update Pack
Section 7: Post-Update Steps
Section 8: Apply Additional Critical Patches
Section 9: Known Issues
Change Log

Section 1: Preparation

For information about known issues associated with specific products in Oracle E-Business Suite Release 12.2.4 and possible workarounds for those issues, please reference the Known Issues section of your specific product Release Note documents.
In Release 12.2.0 and higher, patching is performed by running the new adop (AD Online Patching) utility. You must use adop instead of the adpatch utility that was provided in previous releases. Download and unzip all the patches to the default Patch Top location for R12.2 ($APPL_TOP_NE/../patch). For more information about the adop utility, refer to Oracle E-Business Suite Concepts (Part No. E22949) and Oracle E-Business Suite Maintenance Guide, Release 12.2 (Part No. E22954).

Section 2: Apply Required Database Patches

Review My Oracle Support Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes, and apply all required patches for your database version.

Note: Refer to My Oracle Support Knowledge Document 1355068.1, Oracle E-Business Suite 12.2 Patching Technology Components Guide, for guidance with database patch application.

Section 3: Apply Consolidated Seed Table Upgrade Patch (Required)

Note: This step is applicable only for new installation customers and customers upgrading from Oracle E-Business Suite Release 12.2.2 to Release 12.2.4.

If you haven't already applied Consolidated Seed Table Upgrade Patch 17204589:12.2.0, then you must first apply Patch 17204589:12.2.0 on the run file system.

Note: If you have upgraded to Release 12.2.0 using Consolidated Upgrade Patch 18007406:12.2.0 (CUP5) or Consolidated Upgrade Patch 17197281:12.2.0 (CUP4), then you can skip this step.

1. Stop all Application tier services on the run file system. UNIX:
   
   sh $ADMIN_SCRIPTS_HOME/adstpall.sh
   Windows:
   
   C:\>%ADMIN_SCRIPTS_HOME%\adstpall.cmd
2. Start up only the Weblogic AdminServer service on the run file system.
   UNIX:
   
   $ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
   Windows:
   
   C:\>%ADMIN_SCRIPTS_HOME%\adadminsrvctl.cmd start
3. Apply the consolidated seed table upgrade Patch 17204589:12.2.0 on the run file system using adop hotpatch mode.
   
   $ adop phase=apply patches=17204589 hotpatch=yes
   Note: For existing non-American languages in the system, skip NLS patch application for this. It is not required.
4. Start up all Application tier services. UNIX:
   
   $ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
   Windows:
   
   C:\>%ADMIN_SCRIPTS_HOME%\adstrtal.cmd

Section 4: Apply the Latest AD and TXK Delta Release Update Packs

Note: Review My Oracle Support Knowledge Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2, and follow the instructions to apply the required codelevel of AD and TXK for your system.

Section 5: Perform Pre-Update Steps (Conditional)

Perform the following pre-update steps only if you have licensed this product:

• Supply Chain Management tasks:
  • Oracle Install Base
    Check your system for possible corruption on the user-defined Installed Base Transaction SubTypes. If additional Installed Base Transaction SubTypes or changes to the user-defined Installed Base Transaction SubTypes are identified, you must fix them before applying the Oracle E-Business Suite 12.2.4 Release Update Pack.
    Refer to My Oracle Support Knowledge Document 1681308.1, Generic Datafix For Installed Base Transaction SubTypes Data Corruption Caused by csitxnst.ldt, for instructions.
  • 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.6 INLPCUSS.pls 120.5.12020000.5

    After applying the Oracle E-Business Suite 12.2.4 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 package WMS_LABEL_CUSTOM_PKG, 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

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

Section 6: Apply Oracle E-Business Suite 12.2.4 Release Update Pack

Having applied the latest available AD and TXK Release Update Pack (RUP) for Oracle E-Business Suite Release 12.2 as mentioned in the above step, you can now proceed to apply the Oracle E-Business Suite 12.2.4 Release Update Pack based on your installation type.

If you are...	Follow this path...
Upgrading to Oracle E-Business Suite Release 12.2.4 from Release 11i, 12.0, or 12.1	Path A
Installing a new Oracle E-Business Suite system	Path A
Already using Oracle E-Business Suite Release 12.2.2 or 12.2.3	Path B

6.1 Path A - Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.4 Release Update Pack

1. Source the run edition applications environment.
   UNIX:
   
   $ . <INSTALL_BASE>/EBSapps.env run
   Windows:
   
   C:\><INSTALL_BASE>\EBSapps.cmd run
2. Stop Weblogic AdminServer 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.
   
   1. Stop Weblogic AdminServer service on the run file system.
      UNIX:
      
      $ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
      Windows:
      
      C:\>%ADMIN_SCRIPTS_HOME%\adadminsrvctl.cmd stop
   2. Stop Node Manager service on the run file system.
      UNIX:
      
      $ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
      Windows:
      
      C:\>%ADMIN_SCRIPTS_HOME%\adnodemgrctl.cmd stop
3. Apply Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 by merging with Patch 21900859:12.2.0, on the run edition application environment, using downtime mode.
   UNIX:
   
   $ adop phase=apply apply_mode=downtime patches=17919161,21900859 merge=yes
   Windows:
   
   C:\>adop phase=apply apply_mode=downtime patches=17919161,21900859 merge=yes
4. Start all Application tier services on the run file system.
   UNIX:
   
   $ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
   Windows:
   
   C:\>%ADMIN_SCRIPTS_HOME%\adstrtal.cmd
5. Perform adop cleanup action.
   UNIX:
   
   $ adop phase=cleanup
   Windows:
   
   C:\>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.
   
   $ adop phase=fs_clone

6.2 Path B - Existing Customers (Release 12.2.2 or Release 12.2.3) upgrading to Oracle E-Business Suite 12.2.4 Release Update Pack

1. Source the run edition applications environment.
   UNIX:
   
   $ . <INSTALL_BASE>/EBSapps.env run
   Windows:
   
   C:\><INSTALL_BASE>\EBSapps.cmd run
2. Start an online patching cycle.
   
   $ adop phase=prepare
3. Apply Oracle E-Business Suite Release 12.2.4 Patch 17919161 by merging with Patch 21900859:12.2.0.
   UNIX:
   
   $ adop phase=apply patches=17919161,21900859 merge=yes
   Windows:
   
   C:\>adop phase=apply patches=17919161,21900859 merge=yes
4. Complete the online patching cycle by running the following commands in the order shown.
   UNIX:
   
   $ adop phase=finalize
$ adop phase=cutover
$ . <INSTALL_BASE>/EBSapps.env run
$ adop phase=cleanup
   Windows:
   
   C:\>adop phase=finalize
C:\>adop phase=cutover
C:\><INSTALL_BASE>\EBSapps.cmd run
C:\>adop phase=cleanup
5. 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 help the next online patching cycle complete faster.
   
   $ adop phase=fs_clone

Section 7: Post-Update Steps

Note: If you are upgrading from Release 11i, 12.0.x or 12.1.x to Release 12.2.4, then you must continue with 12.2.0 post upgrade steps mentioned in the Upgrade guides before performing the below steps.

1. Apply Oracle E-Business Suite Release 12.2.4 Online Help
   Apply Oracle E-Business Suite Release 12.2.4 Online Help Patch 17919162 merged with Patch 19290141 using adop hotpatch mode on the run file system.
   
   $ adop phase=apply patches=17919162,19290141 hotpatch=yes merge=yes
2. Grant flexfield value set access to specific users (required)
   Release 12.2 includes a new security feature, flexfield value set security; it controls who can create or modify flexfield values in the Flexfield Values Setup window (FNDFFMSV). Flexfield value set security requires some mandatory setup steps before any users can create or update values in the Values window. You must perform this step if you have not already done so for a previous version of Release 12.2.
   
   Note: See the 'Flexfield Value Set Security' chapter in Oracle® E-Business Suite Flexfields Guide, Release 12.2 (Part No. E22963).
3. Register new products (conditional)
   
   The new products below (added in Release 12.2.4) are not automatically registered in your system. If you intend to use new products, register them using License Manager. For instructions, refer to Oracle E-Business Suite Maintenance Guide, Release 12.2 (Part No. E22954).
   

   Product Short Name	Product Name
   yms	Oracle Yard Management
   cmi	Oracle In-memory Cost Management

4. Perform Product-Specific Steps (conditional)
   After you have completed the steps to update all nodes with the latest code level, perform the following post-update steps only if you have licensed this product:
   
   • Application Technology tasks:
     
     • Oracle Application Framework: This release introduces an updated Look and Feel for Oracle Application Framework-based pages. Ensure that you either set the Oracle Applications Look and Feel profile option to "Skyros Look and Feel", or leave this profile option blank to use this standard Look and Feel by default. Oracle supports only this standard Look and Feel for Oracle E-Business Suite Release 12.2.4. Oracle no longer supports the Look and Feel options of previous releases. For more details, refer to My Oracle Support Knowledge Document 1676222.1, Oracle Application Framework Profile Options. Additionally, if you customized or extended the base functionality of any Oracle Application Framework-based applications in an earlier version of Oracle E-Business Suite, review My Oracle Support Knowledge Document 1927975.1, Oracle E-Business Suite Release 12.2.4 Upgrade Considerations for OA Framework-based Applications, to evaluate whether any adjustments to custom code are needed.
     • Oracle E-Business Suite Integrated SOA Gateway: Oracle E-Business Suite Integrated SOA Gateway requires post manual installation steps. If you are using the Oracle E-Business Suite Integrated SOA Gateway feature for web service generation, deployment, and invocation, perform the steps documented in My Oracle Support Knowledge Document 1311068.1, Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2.
       
       Note: Oracle E-Business Suite Integrated SOA Gateway has product dependencies on Oracle SOA Suite and Oracle E-Business Suite Adapter for SOAP based web services. REST based web services do not have this dependency. You are not required to install Oracle SOA Suite if you plan to use only the REST based web services provided by Integrated SOA Gateway.
   • Customer Relationship Management tasks:
     
     • Oracle Advanced Scheduler and Field Service: If you plan to leverage real-time travel calculations for geo-coding and routing in Advanced Scheduler and Field Service, refer to My Oracle Support Knowledge Document 1560522.1, Navteq ODF Installation Steps For Advanced Scheduler 12.2.2 or later, for Navteq ODF data installation and configuration steps. Note that the installation of ODF data and the corresponding deployment configuration is a one-time setup.
     • Oracle Channel Revenue Management tasks:
       
       1. Run the "Update Time Structure" concurrent program.
          Run the "Update Time Structure" concurrent program, if it was not executed after opening the latest General Ledger period.
       2. Verify whether this concurrent program was already executed by running the following query in APPS user.
          
          SELECT COUNT(*)
FROM OZF_TIME_DAY
WHERE TRUNC(SYSDATE) BETWEEN START_DATE AND END_DATE;
          If the query returns 1, the concurrent program was already executed; there is no need to execute it again. If the query returns 0, execute the concurrent program. Suggested parameters are:
          
          • FROM DATE: 1-JAN-1997 0:0:0
          • TO DATE: (the last date previously defined in General Ledger)
          • All Level : Y
          It is recommended to schedule this program to run at regular intervals whenever new GL periods are opened. If not executed, YEAR_ID column in table OZF_FUNDS_UTILIZED_ALL_B will not be populated.
     • Oracle Mobile Field Service customers: Refer to Section 'Installation steps - Technical' of My Oracle Support Knowledge Document 1396020.1, Mobile Field Service 12.2.x Release, Install and Implementation Notes, for the complete installation and implementation steps.
     • Oracle Price Protection customers: Refer to My Oracle Support Knowledge Document 1584883.1, Integrating Oracle E-Business Suite 12.2 with BPEL in SOA Suite 11g, for the complete installation, configuration and deployment steps.
     • Oracle Quoting customers: Execute the upgrade script to compute cost and margin information for existing quotes. The upgrade script is not automatically executed as part of the upgrade process to Release 12.2.4. You can run it manually, once for each quote status.
       The script accepts one input parameter, (status_code) quote status. The script runs for quotes in that status, in the highest version, and must be in an updateable quote status.
       This script needs to be executed AFTER cutover in the online patching cycle.
       Run the upgrade script asoupgmr.sql, located in $ASO_TOP/patch/115/sql
       
       cd $ASO_TOP/patch/115/sql
sqlplus apps/<apps password> @asoupgmr.sql
   • Financials tasks:
     
     • Oracle Subledger Accounting: If you used Multi Period Accounting, run the concurrent request "Validate Application Accounting Definitions" to re-validate the Applications Accounting Definitions (AAD) for which Multi Period Accounting was enabled. This makes the changes effective. See My Oracle Support Knowledge Document 1406203.1, Steps to Run Import And Validate AAD (Application Accounting Definition) with troubleshooting for instructions on how to validate AAD.
   • Human Resources tasks:
     
     • Human Resources Legislative customers only: Refer to My Oracle Support Knowledge Document 1469456.1 for details on the patches supplying the latest legislative data definitions and for instructions on how to actually apply this data to your system.
     • Single Latest Balance Table Upgrade (For Payroll customers only):If one or more business groups have not been upgraded to the single latest balance table, run the concurrent program 'Generic Upgrade' for 'Single Latest Balance Table Upgrade' to upgrade to Single Latest balance table. The upgrade is executed by business group. Refer to My Oracle Support Knowledge Document 1937092.1, How to determine which business groups need to be upgraded to "Single Latest Balance Table" for information about the SQL command to run to display which business group it was not executed for.
   • Procurement tasks:
     
     • Oracle Purchasing with Oracle Transportation Management: Oracle Purchasing is integrated with Oracle Transportation Management. If you have licensed both products and would like to use Oracle Transportation Management with Oracle Purchasing, execute the post-update steps listed in My Oracle Support Knowledge Document 1362803.1, About Oracle Transportation Management Integration with Oracle E-Business Suite R12.2.
   • Supply Chain Management tasks:
     
     • Oracle Complex Maintenance Repair and Overhaul: If you are using or plan to use Enigma 3C with Oracle Complex Maintenance Repair and Overhaul (CMRO), refer to My Oracle Support Knowledge Document 1584883.1, Integrating Oracle E-Business Suite 12.2 with BPEL in SOA Suite 11g, for the required post-update steps.
     • Oracle Flow Manufacturing: If you are using or plan to use electronic kanban, refer to My Oracle Support Knowledge Document 1517173.1, 12.2 Electronic Kanban Deployment Guide for the complete deployment setup.
     • Oracle In-Memory Cost Management for Discrete Industries or Oracle In-Memory Cost Management for Process Industries: Refer to My Oracle Support Knowledge Document 1632072.1, Oracle In-Memory Cost Management Installation and Configuration Guide, for complete installation and configuration steps.
     • Oracle Manufacturing Operations Center: Refer to My Oracle Support Knowledge Document 1669093.1, Oracle Manufacturing Operations Center Installation Guide, for the complete installation and configuration steps.
     • Oracle Mobile Application Server: Restart the Mobile Server after ensuring that no users are connected to Mobile Applications.
     • Oracle Shipping Execution with Oracle Transportation Management: If you have licensed both Oracle Transportation Management and Oracle Shipping Execution and are already using or plan to use Oracle Transportation Management with Oracle Shipping Execution, refer to My Oracle Support Knowledge Document 1362803.1, About Oracle Transportation Management Integration with Oracle E-Business Suite R12.2, for the required post-update steps.
     • Oracle Warehouse Management with Oracle Transportation Management: If you have licensed both Oracle Transportation Management and Oracle Warehouse Management and are already using or plan to use Oracle Transportation Management with Oracle Warehouse Management, refer to My Oracle Support Knowledge Document 1362803.1, About Oracle Transportation Management Integration with Oracle E-Business Suite R12.2, for the required post-update steps.
     • Oracle Yard Management: If you plan to use Oracle Yard Management, refer to My Oracle Support Knowledge Document 1672903.1, Oracle Yard Management, deployment steps for ADF components, for the deployment steps.
   • Value Chain Planning tasks:
     
     • Oracle Value Chain Planning: Oracle Value Chain Planning includes Advanced Supply Chain Planning, Demand Planning, Inventory Optimization, Global Order Promising, Collaborative Planning, Production Scheduling, Strategic Network Optimization, Service Parts Planning, Advanced Planning Command Center, and Demand Signal Repository. If you have licensed any of these products, perform the steps outlined in My Oracle Support Knowledge Document 1361221.1, Oracle Value Chain Planning Installation Notes Release 12.2 to enable these applications.
   • Oracle E-Business Suite Extensions for Oracle Endeca customers: Refer to My Oracle Support Knowledge Document 1614014.1, Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V5 for the complete installation and configuration steps.
5. Perform NLS-related Step (conditional)
   You may have languages other than American English installed on your Release 12.2.0 system. If so, you must apply the Release 12.2.4 NLS software patch for each of the existing languages in the system. After applying the Release 12.2.4 NLS software patch, apply the Release 12.2.4 Online Help patch for the language, if available. Refer to the Release 12.2 Translation Scope and Availability Page for scope of Online Help languages.
   
   Note: If you plan to install new languages after you apply Release 12.2.4 Patch 17919161, refer to My Oracle Support Knowledge Document 1314621.1, Oracle E-Business Suite NLS Release Notes.
6. Run the Patch Wizard for current recommended and high priority product patches.
   Patch Wizard is a tool included with Oracle Application Manager. Patch Wizard reviews recommended and high priority patches against those that have been applied on your system. Patches can be downloaded and merged using the tool. You can review patch impact to determine how a specific patch or several patches will affect your system. Refer to My Oracle Support Knowledge Document 976188.1, Patch Wizard Utility.
   
   Note: If your environment does not allow the patch wizard utility, review My Oracle Support Knowledge Document 1400757.1, How to Find Oracle E-Business Suite Recommended Patches.

Section 8: Apply Additional Critical Patches

8.1 Patches to Improve Connection Handling

• All Customers
  The following critical performance patches resolve issues with connections not being released for return to the data source connection pool:
  
  • Patch 19494816 - Oracle Application Object Library
  • Patch 19807163 - Oracle Applications Manager
  • Patch 19858552 - Oracle Application Framework
  • Patch 21619282 - Oracle Application Framework

8.2 Patch to Improve Results Caching

• All Customers
  Applying the following critical patch resolves an issue with efficiency of the database results cache, and may significantly improve response times.
  
  • Patch 19891697

8.3 Patch to Reduce Logging in Oracle Framework

• All Customers
  Applying the following patch to reduce log generation may improve overall performance:
  
  • Patch 18345006 - Oracle Application Framework

8.4 Patch to Synchronize Changes in Oracle Workflow

• All Customers
Applying the following critical patch resolves an issue with workflow processes that are launched during an online patching cycle. They get stuck after online patching cutover.

• Patch 21440868 - Oracle Workflow

8.5 Patch for Error Checking in the Flexield Segment Values Form

• All Customers
Applying the following patch introduces error checking in the Flexield Segment Values form, to help prevent data corruption.

• Patch 21483810 - Oracle Application Object Library

Section 9: Known Issues

9.1 Oracle Manufacturing Operations

Due to residual data in table MTH_EQUIP_PROD_PERFORMANCE_F, customers using the Sustainability Sensor Data Management (SSDM) feature within Oracle Manufacturing Operations might encounter the following error for the file mthtxntb.odf while applying the Oracle E-Business Suite 12.2.4 Release Update Pack:

Error: ORA-01758: table must be empty to add mandatory (NOT NULL) column

You must verify if there are any records in table, MTH_EQUIP_PROD_PERFORMANCE_F. If this table contains any records, you must apply Patch 19487679:R12.MTH.C.

9.2 Oracle Human Resources

Customers upgrading to Oracle E-Business Suite Release 12.2.4 from Release 12.1 HRMS RUP8 (20000288: R12.HR_PF.B.Delta.8) will encounter the following error for the file pay_taxability_rules_tab.xdf.

Error in executing statement ALTER TABLE HR.PAY_TAXABILITY_RULES ADD CONSTRAINT "PAY_TXR_TAX_TYPE_CHK" CHECK (TAX_TYPE IN ('SDI', 'SUI', 'SIT'

ORA-02293: cannot validate (HR.PAY_TXR_TAX_TYPE_CHK) - check constraint violated

To avoid the failure, apply Release 12.2.4 Patch 17919161, merged with Patch 21540405:R12.PAY.C.
UNIX:

$ adop phase=apply patches=17919161,21540405 merge=yes

Windows:

C:\>adop phase=apply patches=17919161,21540405 merge=yes

 

 

Thanks

Srini