X

The Latest Technology Stack News Directly from EBS Development

Database 12.1.0.2 Certified with E-Business Suite 12.2

Elke Phelps
Product Management Director

I’m pleased to announce that 12.1.0.2, the first patchset for the 12c Database, is now certified with E-Business Suite 12.2.2 and higher. 

Database support implications may also be reviewed in this database patching and support article.

Screenshot of Database 12.1.0.2 OTN download page
 
 
Oracle E-Business Suite Release 12.2.x
Certified Platforms
  • Linux x86-64 (Oracle Linux 5, 6)
  • Linux x86-64 (RHEL 5, 6)
  • Linux x86-64 (SLES 11)
  • Oracle Solaris on SPARC (64-bit) (10, 11) 
  • Oracle Solaris on x86-64 (10, 11)*
*This is a 'database tier only' or 'split tier configuration' certification where the application tier must be on a fully certified E-Business Suite platform.
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit) 
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
Database Feature and Option Certifications The following database options and features are supported for use:

Pending Feature/Option Certifications

  • Oracle Multitenant
  • Oracle Database Vault
  • TDE Tablespace Encryption
  • Transportable Database and Transportable Tablespaces data migration processes

About the pending certifications Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which will be posted as soon as soon as they're available.  

EBS 12.2 References

Related Articles The preceding is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Join the discussion

Comments ( 48 )
  • guest Friday, January 9, 2015

    What about dataguard (and active dataguard that you previously said was not yet certified ) ?

    i am also confused because the certification matrix said database 12c 12.1 is already certified which includes 12.1.0.2 unless you assume 12.1.0.2 is to all intents and purposes 12.2 which it probably is and should have been labelled as such seeing the amount of new features. Anyway why is this a separate certification then ?

    That belies the previous announcement that 12.1 is certified...


  • Elke Phelps (Oracle Development) Friday, January 9, 2015

    Guest, Thanks for the inquiries. I apologize in advance as this is a long reply; however, I think it includes some additional information regarding the E-Business Suite and database certification process that is beneficial to share with you and our readers. I’m going to start by addressing your base database certification announcement question first.

    GUEST>> i am also confused because the certification matrix said database 12c 12.1 is already certified which includes 12.1.0.2 unless you assume 12.1.0.2 is to all intents and purposes 12.2 which it probably is and should have been labelled as such seeing the amount of new features. Anyway why is this a separate certification then ?

    RESPONSE>> Oracle E-Business Suite performs certifications with Oracle Database major releases and patchsets. For example:

    Oracle Database 11gR2: 11.2.0.1, 11.2.0.2, 11.2.0.3, 11.2.0.4

    Oracle Database 12c: 12.1.0.1 , 12.1.0.2

    Not all combinations of EBS versions are certified with all Oracle Database major releases and patchsets. Which combinations are certified is dependent upon EBS and database support timelines, release dates, baseline minimum requirements and other factors.

    For example:

    Oracle E-Business Suite 12.2.2, 12.2.3 and 12.2.4 are certified with database 11.2.0.3 (minimum database version certified with 12.2.x), 11.2.0.4, 12.1.0.1 and 12.1.0.2

    This is a new announcement as we certify database patchsets. Oracle E-Business Suite certification is not with Oracle Database 12.1 but rather with Oracle Database 12.1.0.1 and 12.1.0.2. This article is announcing certification with Oracle E-Business Suite 12.2 and Database 12.1.0.2.

    The certification tab in My Oracle Support (MOS) also reflects the database level as indicated here - Oracle Database 12.1.0.1 and Oracle Database 12.1.0.2. Sometimes the certification information in MOS may be a few days behind the initial posted announcement here on the blog. This is because we are providing you the announcement on the blog as soon as the certification is complete and the announcement is published internally. So, the updated certification in MOS may lag behind a few days from the original post.

    After we complete the base certification, we then begin the process of certifying database features and options. For example: Advanced Compression, Advanced Security Option (ASO) / Advanced Networking Option (ANO),Database In-Memory Option, etc...

    Some database features/options require explicit certification (such as standby database), others (such as advanced compression) do not as the feature is transparent to the EBS application.

    We make our best effort with every database certification we perform to complete the certification of all database options and features and announce these when the base certification is announced. Sometimes this is possible, sometimes due to other priorities and/or bugs it is not possible.

    As previously stated, the best place to determine what is certified is the certification tab in MOS.

    Now that you have some background information regarding the EBS and database certifications and the certification of database features/options, I will address the first question you posted...

    GUEST>> What about dataguard (and active dataguard that you previously said was not yet certified ) ?

    REPONSE>>Unfortunately, you did not provide enough information for me to answer the question. The answer depends upon the EBS version and database version you are inquiring about. It also depends on if you are asking about certification with a standby database or an active data guard database instance. Blog articles are typically static (current at a point in time); therefore, the best place to find current certification information is the certification matrix on My Oracle Support (MOS).

    Hope this helps.

    Happy New Year.

    Regards,

    Elke


  • guest Friday, January 23, 2015

    Hi,

    What about IBM AIX 7.1-R12.2.4 . I do see that IBM AIX/R12.2 has not been certified for any version of 12c whereas Linux and Sun OS are certified for both 12c releases 12.1.0.1/2. Our customer is pushing us for 12c upgrade on EBS R12.2-AIX.May I know why AIX is lagging behind in certification when many customers use it and its a major plus powerful OS platform.Any estimate of its certification.

    regards,

    Vishal


  • Elke Phelps (Oracle Development) Monday, January 26, 2015

    Vishal,

    Thanks for the inquiry. My previous update should have also included information regarding platform certification. The base certification starts with certification on Linux then Solaris, then other platforms. We just announced Oracle E-Business Suite 12.2 certification with Database 12.1.0.1 on AIX. You may refer to the following article:

    https://blogs.oracle.com/stevenChan/entry/oracle_database_12cr1_12_11

    Oracle E-Business Suite 12.2 certification with Database 12.1.0.2 on AIX is still in progress. A separate blog article will be published as additional platforms are certified. You can also get up-to-date certification on the My Oracle Support certifications tab.

    Regards,

    Elke


  • guest Tuesday, February 17, 2015

    hi Steven,

    I think I know the answer, but will 12.1.0.2 be certified with EBS 12.0?

    thanks


  • Steven Chan Tuesday, February 17, 2015

    Hi, Guest,

    That combination is certified, but now that EBS 12.0.6 is in Sustaining Support, we will not be producing any new certifications for that release.

    Regards,

    Steven


  • guest Wednesday, February 25, 2015

    Hi Steven, do you know if database 12.1.0.2 on Exadata is certified with EBS 12.2.4?

    Thanks


  • Elke Phelps (Oracle Development) Wednesday, February 25, 2015

    Guest,

    Thanks for the inquiry.

    Yes, Oracle E-Business Suite 12.2.4 is certified with Oracle Database 12.1.0.2 running on Exadata.

    Note:

    - Oracle E-Business Suite 12.2.4 and Oracle Database 12.1.0.2 is certified for Linux x86-64 and Oracle Solaris 11.

    - Exadata ships with Linux x86-64 or Oracle Solaris on SPARC (64-bit).

    Please refer to the following My Oracle Support note for additional Oracle E-Business Suite Exadata patch requirements:

    - Additional Database Patches Required by Oracle E-Business Suite on Exadata Database Machines (Note 1392527.1)

    Thanks.

    Elke


  • guest Thursday, March 26, 2015

    Is Oracle E-Business Suite 12.2.4 certified with Oracle Database 12.1.0.2.0 running on Oracle OVM (Linux x86-64)?

    Further can the database be RAC?

    Also can the application run on two application servers load balanced?

    Thanks in advance


  • guest Thursday, March 26, 2015

    Is Oracle E-Business Suite 12.2.4 certified with Oracle Database 12.1.0.2.0 running on Oracle OVM (Linux x86-64)?

    Further can the database be RAC?

    Also can the application run on two application servers load balanced?

    Thanks in advance


  • Rajeev Sunday, September 13, 2015

    Is Oracle Ebiz 12.2 or higher supported on the leaf nodes & can the application leverage the cluster HA of 12c ?


  • Elke Phelps (Oracle Development) Monday, September 14, 2015

    Guest,

    My apologies, it seems I neglected to reply to your post in March.

    To answer your questions:

    - Yes, Oracle E-Business Suite 12.2.4 is certified for Oracle VM Linux x86-64. The Oracle E-Business Suite Performance team recommends that customers run their production Oracle Database on bare metal.

    - Yes, Oracle E-Business Suite 12.2.4 is certified with Oracle Database 12.1.0.2. Oracle E-Business suite 12.2.4 with Database 12.1.0.2 RAC is also certified.

    - Yes, the application nodes can be load balanced. You may refer to the following for more details:

    Using Load-Balancers with Oracle E-Business Suite Release 12.2, MOS Note 1375686.1

    Thanks.

    Elke


  • Elke Phelps (Oracle Development) Thursday, September 17, 2015

    Rajeev,

    We are currently in the process of certifying the Oracle Database 12c Flex ASM feature with Oracle E-Business Suite 12.2.

    Certification of the Oracle Database 12c Flex ASM feature with Oracle E-Business Suite 12.1 is currently planned.

    Thanks.

    Elke


  • Rajeev Wednesday, September 23, 2015

    Elke,

    Thanks for responding back on the 12c Flex ASM feature.

    Is Oracle Ebiz 12.2 or higher supported on the leaf nodes ?

    Rajeev.


  • Elke Phelps (Oracle Development) Saturday, September 26, 2015

    Rajeev,

    You're welcome. No, Oracle E-Business Suite 12.2 is not currently certified with Oracle Flex Cluster.

    Please monitor this blog for the latest in certification announcements.

    Regards,

    Elke


  • Stuart Leeke Saturday, October 17, 2015

    Hi,

    Has 12c FlexAsm been support yet for Ebiz 12.1.3 ? If not, is there an expected date for support ?

    Regards,

    Stuart


  • Steven Chan Tuesday, October 20, 2015

    Hi, Stuart,

    We're still reviewing the requirements for Flex ASM in EBS environments. Stay tuned to this blog for updates.

    Regards,

    Steven


  • Nikhil Thursday, November 5, 2015

    Hi Elke,

    Is R12.2 now certified with data guard 12.1.0.2?


  • Lori B. Thursday, November 5, 2015

    Is EBS 12.2 certified to run on 12c as a pluggable database on exadata?

    Thanks,

    Lori


  • Elke Phelps (Oracle Development) Thursday, November 12, 2015

    Lori,

    No version of Oracle E-Business Suite is certified with the Database 12c Multitenant feature (ie pluggable database).

    We are currently working on a project to certify Oracle E-Business Suite with the Database 12c Multitenant feature.

    Please monitor this blog for the latest in Oracle E-Business Suite Technology certification announcements.

    Regards,

    Elke


  • Elke Phelps (Oracle Development) Tuesday, November 17, 2015

    Nikhil,

    Yes, Oracle E-Business Suite 12.2 is certified with Database 12.1.0.2 and Data Guard. Refer to the following My Oracle Support Note:

    Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1)

    https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1963472.1

    Be sure to review the software prerequisite requirements as noted in the MOS Note.

    Thanks.

    Elke


  • TyskJohan Wednesday, December 16, 2015

    Hi -

    We are seeing quite a few problems with 12.2.5 on 12.1.0.2, particularily in (seeded) queries using UNION, and mostly within Projects. Both incorrect results, and ORA-00600 as well as ORA-07445.

    Is this something that you are aware of at a product management level?

    /Johan


  • Steven Chan Wednesday, December 16, 2015

    Hi, Johan,

    I'm in the Applications Technology Group, which specializes in the E-Business Suite's technology stack. I don't have much visibility into end-user functionality such as Projects.

    All EBS product teams, including Projects, perform extensive testing as part of a given release such as 12.2.5. Our mandatory exit criteria would bar them from releasing their product if such errors are found.

    Do you have Service Requests open for these two issues?

    Regards,

    Steven


  • TyskJohan Wednesday, December 16, 2015

    Steven -

    Yes, SRs as follows:

    SR 3-11647935781

    SR 3-11559648821

    SR 3-11567099491

    SR 3-11806058601

    Two of them are definitely RDBMS bugs; the other two are flagged as potential RDBMS bugs.


  • Pankaj Saturday, January 2, 2016

    We have just went live on R12.2.4 with database 12.1.0.1 and are facing lot of issues. The database hangs randomly and have to bounce the instance.

    Even Oracle support is not able to give any solutions.

    Have raised multiple SR for the same.

    As per the latest recommendations only 12C.1.0.2 is recommended with R12.2 but when we planned the upgrade 12.1.0.2 was not certified and had to go for 12.1.0.1 and now we find that Oracle would not provide any patches for .1 and only supports 12.1.0.2.

    Our instance is still not stable and getting downtime is challenge. What can be done ?


  • Elke Phelps (Oracle Development) Monday, January 4, 2016

    Pankaj,

    I'm sorry to hear that you are encountering issues. If you could, please email me the SRs you opened for the issues encountered.

    Thanks.

    Elke


  • Kevin Wednesday, January 13, 2016

    This question is in regard to upgrading from 11i to R12.2 and the timing of the database upgrade from 11.2.0.4 to 12.1.0.2. The upgrade guide (part E48834-13) indicates near the end of chapter 2 that the database is upgraded (point 7) after the first run of Rapid Install (point 1). However, note 1349240.1 seems to indicate the opposite, the database is upgraded first and then the first run of Rapid Install occurs. In addition, there are references to identification and application of the proper database patches to the 12.1.0.2 db home. I assume ETCC check can not be run on the newly installed 12.1.0.2 RDBMS home because, at this point (Chapter 2), that RDBMS ohome has not be autoconfig enabled...ETCC db check requires a CONTEXT_FILE. To summarize, what is Oracle's prefered order for Rapid Install vs db upgrade and can you confirm there is no expectation to use ETCC on the dbtier until it is autoconfig enabled?

    Thanks


  • Steven Chan Wednesday, January 13, 2016

    Hi, Kevin,

    Most customers upgrading to EBS 12.2 will upgrade their existing EBS environment (e.g. 12.1.3) to the target database release (e.g. Database 12.1.0.2) first. This approach gives you the option of doing these two tasks in two different downtimes.

    We support either approach. You should always have a clean ETCC run before beginning your upgrade to EBS 12.2.

    Regards,

    Steven


  • Sarat Monday, March 21, 2016

    Need confirmation whether TDE Tablespace Encryption is certified with Oracle E-Business Suite Release 12.2 on Oracle Database 12c Release 1 (12.1.0.2). As per blog TDE Tablespace Encryption is pending certification for Database 12.1.0.2 with E-Business Suite 12.2 and higher.

    Within the same blog document 1926686.1 ("Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12.2 on Oracle Database 12c Release 1 (12.1.0)") is also referenced.

    This could be interpreted as document 1926686.1 was initially certified for database 12c Release 1 (12.1.0) but pending certification for 12.1.0.2. We are seeking clarification whether this combination would be certified.


  • Steven Chan Tuesday, March 29, 2016

    Hello, Sarat,

    Yes, TDE 12.1.0.2 is certified with EBS 12.2.5. You can verify this by searching for "Transparent Data Encryption" in the Certify database on My Oracle Support.

    Regards,

    Steven


  • Varun Wednesday, April 6, 2016

    Hi Steven,

    How CDB's and PDB's of 12c database are used with E-Business Suite.

    What are advantages/disadvantages of having CDB and PDB's for E-Business Suite.

    Will there be any benefits of PDB's for cloning EBS production database to Test and Dev environments?


  • guest Sunday, June 12, 2016

    Is EBS 12.2 certified to run on 12c as a pluggable database


  • guest Monday, June 13, 2016

    Varun, Apologies for the delayed response. Your post came at the time of the COllaborate 2016 conference - a very busy time for us in EBS development and product management and I must have missed this post.

    To answer your question and the current question from our guest:

    The Multitenant (Container Database (CDB) with Pluggable Databases (PDB)) feature delivered with Oracle Database 12c is not currently certified with any release Oracle E-Business Suite (12.1/12.2).

    We are currently working on a project to certify Multitenant with Oracle E-Business Suite. Please monitor or subscribe to this blog for the latest certification announcements.

    Regards,

    Elke


  • Steven Chan Monday, June 13, 2016

    Hello, Guest,

    Not yet. Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.

    Regards,

    Steven


  • Rajender Tuesday, June 14, 2016

    Thanks for the acknowledge.We are awaiting and can we get any idea about the releasing date in future.

    Regards,

    Rajener


  • Guest Friday, June 2, 2017
    Hi,

    Is EBS 12.2 certified to run on 12cR2?
    Do you have any plan?
  • Steven Chan Friday, June 2, 2017
    Hi, Gues,

    Our certification of EBS 12.2 and 12.1 with Database 12.2 is underway right now.

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.

    Regards,
    Steven
  • Benny Tate Monday, October 9, 2017
    Hi Steven,

    has database 12.2 been certified for EBS 12.2? We recently completed upgrading EBS from Release 12.2.4 to 12.2.7. But our EBS database is still at 11.2.0.4. We would like to bring our EBS database up to date with latest version.

    What is the latest database certified for R12.2?
    Is it database 12.1.0.2 or is database 12.2 certified now?

    Thank you,
    Benny Tate
    Ben R. Tate and Associates, Inc.
  • Steven Chan Thursday, October 12, 2017
    Hi, Benny,

    Not yet. These certifications are still underway right now. The latest certified database for EBS 12.2 is Database 12.1.0.2. See:

    https://blogs.oracle.com/stevenchan/database-12102-certified-with-e-business-suite-121

    Regards,
    Steven
  • Muhammad Rawish Siddiqui Tuesday, October 17, 2017
    Hi Steven!
    Could you please confirm, if eBusiness 12.1.3 is now certified with 12c Databse CDB/PDB features ?

    Thanks.
  • Guest2018 Thursday, February 8, 2018
    Hi

    Can you please let me know if we are upgrading EBS R12.2.4 database from 11.2.0.4 to 12.1.0.2 then which option we should choose i.e In-memory or non in-memory " .

    Please advice

    Thanks
  • Steven Chan Thursday, February 8, 2018
    Hello, Guest2018,

    You need to purchase a license to use the Database In-Memory Option. You should check with your organization's purchasing department to see whether you can use it.

    If you're licensed for it, you can implement Database In-Memory by following the white paper linked from this article:

    https://blogs.oracle.com/stevenchan/using-oracle-database-in-memory-with-oracle-e-business-suite

    Regards,
    Steven
  • Chirag Patel Monday, March 19, 2018
    Hi,

    I am refering Steven's earlier reply on 2-Jun-17 and 12-Oct-17, saying "Our certification of EBS 12.2 and 12.1 with Database 12.2 is underway right now" and this certification is yet not announced so I guess it is still underway. Tthis is quite disappointing that it take such a long. It is almost a year since Database 12.2 was released and on top of this, premier support for 12.1 is ending on Jul-18 (Ref: http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf). Database upgrade takes couple of months in large complex environmets and we have just 4 months left before 12.1 premier support ends and yet we can't upgrade to Database 12.2, which is very frustrating. I know, you won't give me any tentaive date for this certification, but can it be worked on priority basis and release certification asap?

    Thanks
    Chirag
  • Steven Chan Monday, March 19, 2018
    Hello, Chirag,

    I understand how you feel. This certification has taken much more effort and time than we wanted.

    This is our top priority. This has been our top priority since Database 12.2 was in beta, which underlines the complexity of this certification.

    Premier Support for Database 12.1 runs to July 31, 2018. Extended Support for Database 12.1 runs to July 31, 2021.

    In case you missed it, the Extended Support fee for Database 12.1 was waived to July 2019. See this article:

    https://blogs.oracle.com/stevenchan/database-121-extended-support-fee-waived-through-july-2019

    We're still working on the Database 12.2 certification with both EBS 12.1 and 12.2. We have identified a number of issues that require patches from the database group, particularly around pluggable databases and compatibility with the Edition-Based Redefinition functionality that is the core of our Online Patching features.

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.

    Regards,
    Steven
  • Saptarshi Banerjee Friday, April 20, 2018
    Hi Steven,

    Can we upgrade the GI to 12.2 with EBS database in 12.1.0.2. We are in Exadata and if we don;t upgrade the GI to 12.2, there are other non-EBS database where we cannot use 12.2. As you have mentioned, there is uncertainty when EBS would be certified for 12.2. This is causing problems in Exadata with single cluster.
  • Steven Chan Friday, April 20, 2018
    Hello, Saptarshi,

    I understand your concerns. Our Grid Infrastructure certifications are inherited from the Database certifications. I'm afraid that you have to hold off on upgrading the Grid Infrastructure until our base certification of Database 12.2 is completed.

    Regards,
    Steven
  • Howard Bellis Thursday, June 28, 2018
    Any news yet on EBS 12.2 being certified on Database 12.2 or 18?

    Thanks
    Howard
  • Steven Chan Wednesday, July 11, 2018
    Hi, Howard,

    The certification of the next database release for EBS 12.1 and 12.2 is our top priority. There are some complex issues around Pluggable Database features as well as interactions with the Edition-Based Redefinition features. These issues are escalated to the highest level with Database Development, so they are top priority for resolution. Due to the complexity of these issues, this is taking more time than anyone expected.

    Customers have been escalating their concerns about this certification due to pending support status changes. Premier Support for Database 12.1 runs to July 31, 2018. Extended Support for Database 12.1 runs to July 31, 2021.

    In case you missed it, the Extended Support fee for Database 12.1 was waived to July 2019. See this article:

    https://blogs.oracle.com/stevenchan/database-121-extended-support-fee-waived-through-july-2019

    We are continuing to work through the technical issues, and in the meantime we have been discussing the support timelines for prior versions with the Database Development and Support groups. At this point, we are anticipating that the next version of the database we certify will be 19. This is the "Long Term Support" release of the Database 12.2 line, in the same way that 11.2.0.4 was the Long Term Support patchset on the 11.2 lines. Database versions 12.2 and 18 will have relatively shorter support lives compared to 19.

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.

    Regards,
    Steven
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services