What’s the latest Oracle E-Business Suite Release/support update?

This summary page is intended to provide the following information:

  1. Which Oracle support policy applies to the various Oracle E-Business Suite components and where to find the official Oracle support policy documents and error correction support documents

1.  Which support policy applies and where to find it

Oracle E-Business Suite deployments include the Oracle E-Business Suite Release, the 

Oracle E-Business Suite internal application tier technology stack, the Oracle E-Business Suite 

database and optional external integrations.

The following table includes guidance regarding which support policy applies to the various components of your EBS deployment and the location of the support policy documents:

Support Time LineCovered ComponentsWhere to Find the Official Support Policy Documents
Oracle E-Business Suite
  • Oracle E-Business Suite Release
  • Oracle E-Business Suite Internal Application Tier Technology Stack

Oracle Lifetime Support Policy: Oracle Applications

Tip:  Search for E-Business Suite in the referenced document

DatabaseAll Oracle Databases including the Oracle E-Business Suite Database

Oracle Lifetime Support Policy:  Oracle Technology Products

Tip:  Search for Oracle Database Releases in the referenced document

Fusion Middleware

All Fusion Middleware products including those used for external integrations with EBS

Examples:  SOA Suite, OAM, OID, OUD, etc.

Oracle Lifetime Support Policy:  Oracle Fusion Middleware Products
 

For dates of grace periods for Oracle database releases, see:  Release Schedule of Current Database Releases (MOS Note 742060.1).  Here is an excerpt:

Oracle Database ReleaseSupport Dates

19c

End of Premier Support:  April 30, 2024 or April 30, 2027 with paid Extended Support (ES)
12.1.0.2End of Error Correction Support: July 31, 2022 with ES or Universal License Agreement (ULA) - (not all platforms)
11.2.0.4

End of  Market Driven Support (MDS): December 31, 2022

Error Correction Support Ended: December 31, 2020 

Note: 

  • All older database releases are out of Error Correction Support
  • For Oracle Database 12.1 there is a global ES fee waiver in place for E-Business customers. For additional details and the process to determine your eligibility, see: Extended Support Fee Waiver or Oracle E-Business Suite (MOS Note 2522948.1)

For dates of grace periods for specific Fusion Middleware releases see:

2. Certifications for Current Oracle E-Business Suite Releases and Components

IMPORTANT:  The source of truth for certifications is maintained on My Oracle Support.  If in doubt, always check the Certifications database for the final word.

This summary page cross-references published blog articles and the official certifications listed in the Certifications database on My Oracle Support.  Platform-specific information is available in the Certifications database on My Oracle Support.

Obsolete certifications are releases that are no longer eligible for Extended Support or Error Correction Support. Obsolete certifications are denoted on this page using the following symbol: ⊠

Obsolete certifications that have been archived from this page are available for reference on the following page:  Obsolete EBS Certifications. 

Current EBS Releases

 EBS 12.2EBS 12.1

Support
Dates

Premier Support to At Least December 2032

April 2021 Announcement

Premier Support to December 2021

Beginning January 1, 2022, Market-Driven Support for EBS 12.1 is an option

Release
Update
Packs

12.2.10 (09/2020)

12.2.9 (08/2019)

12.2.8 (10/2018)

12.2.7 (9/2017)

12.2.6 (9/2016)

12.2.5 (10/2015)

12.2.4 (8/2014)

12.2.3 (12/2013)

12.1.3 RPC5 (8/2016)

12.1.3 RPC4 (10/2015)

12.1.3 RPC3 (4/2015)

12.1.3 RPC2 (9/2014)

12.1.3 RPC1 (3/2014)

12.1.3 (8/2010)

12.1.2 (12/2009)

Initial
Release

12.2.2 (9/2013)

12.1.1 (4/2009)

Documentation

Web Library

EBS 12.2 Technology Stack Doc Roadmap

Web Library

EBS 12.1 Technology Stack Doc Roadmap

 

EBS 12.2:  Internal Application Tier Technology Stack Certifications

  • Forms 10.1.2.3
  • WLS 11gR1 Patchset 5 (10.3.6)
  • WebTier Utilities: 11.1.1.9, ⊠[ 11.1.1.6 , 11.1.1.7]
  • Java SE (JDK) 7 ,⊠ [6]

EBS 12.1:  Internal Application Tier Technology Stack Certifications

EBS 12.2, 12.1:  Database Certifications

EBS 12.2, 12.1:  Optional External Integrations

Oracle Enterprise Manager Cloud Control 13c

EBS 12.2, 12.1:  Client Certifications

Java Runtime Environment

All JRE 1.7 and 1.8 updates are automatically certified with all supported EBS releases

Windows 

Windows-based Browsers

Windows-based Office

Apple Mac OS X and iOS

Other EBS Certifications


Reference link :- https://blogs.oracle.com/ebstech/ebs-resources


Assigning Concurrent Program to a Responsibility in R12.1.3

Steps to add request set/Program to responsibility in oracle apps R12.1.3

 Example :-

Responsibility name :- General Ledger Super User 

Add below two program to this responsibility.

a. GL Cost Journal Program

b. GL Revenue Journal Program

1. Find the Request Group of the Responsibility

Responsibility: System Administrator > Security > Responsibility > Define

2. Search for the Responsibility(General Ledger Super User) with which the Concurrent Program needs to be run. 

 Copy the request group name.

3. Add the Concurrent Program/Request Set to the Request Group

Responsibility: System Administrator > Security > Responsibility > Request

Search the request Group name for attaching the concurrent Program

Request group :- GL Concurrent Program Group

Application :- General Ledger

Add below both concurrent program and save it.

a. GL Cost Journal Program

b. GL Revenue Journal Program

I hope both concurrent program has been reflected on responsibility (General Ledger Super User).


 

How to Enabled and Disabled Triggers in oracle 11g.

Ques :- How to Enabled and Disabled Triggers in oracle 11g?

# Enabling Triggers steps.

You enable a disabled trigger using the ALTER TRIGGER statement with the ENABLE option. 

To enable the disabled trigger named trigger01 on the SUJEET table, enter the following statement:

ALTER TRIGGER trigger01 ENABLE;

To enable all triggers defined for a specific table, use the ALTER TABLE statement with the 

ENABLE ALL TRIGGERS option. To enable all triggers defined for the SUJEET table, 

Enter the following statement:

ALTER TABLE SUJEET ENABLE ALL TRIGGERS;


# Disabling Triggers steps.

Consider temporarily disabling a trigger if one of the following conditions is true:

An object that the trigger references is not available.

You must perform a large data load and want it to proceed quickly without firing triggers.

You are loading data into the table to which the trigger applies.

You disable a trigger using the ALTER TRIGGER statement with the DISABLE option. 

To disable the trigger trigger01 on the SUJEET table,

 Enter the following statement:

ALTER TRIGGER trigger01 DISABLE;

You can disable all triggers associated with a table at the same time using the ALTER TABLE statement 

with the DISABLE ALL TRIGGERS option. For example, to disable all triggers defined for the SUJEET table, 

Enter the following statement:

ALTER TABLE SUJEET DISABLE ALL TRIGGERS;


ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%'

 This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user ...