Thursday, August 22, 2013

Oracle History and ERP Versions their Release Dates



Oracle History and ERP Versions their Release Dates
Ellison co-founded Oracle Corporation in 1977 with Bob Miner and Ed Oates under the name Software Development Laboratories (SDL). In 1979 SDL changed its name to Relational Software, Inc. (RSI). In 1982, RSI renamed itself Oracle Systems Corporation to align itself more closely with its flagship product Oracle Database. At this stage Bob Miner served as the company's senior programmer. In 1995, Oracle Systems Corporation changed its name to Oracle Corporation. On March 12, 1986: Oracle gone public with revenues of $55 million USD.

ü  Oracle E-Business Suite started life as Oracle Financials in 1987. 

ü  August 1987: Oracle founds its Applications division, building business-management software closely integrated with its database software. Oracle Corporation acquires TCI for its project management software.

ü  October 1987: Oracle Applications Release 1

ü  Sometime in August 1988 they released their first ERP application called accounting system that has only general Ledger functionality enabled. This is one of the reason of having General ledger application_id is 101.

ü  November 1988: Release 3

ü  January 1989: Release 4

ü  May 1989: Release 5

ü  October 1989: Release 6

ü  May 1990: Release 7

ü  November 1990: Release 8

ü  June 1992: Release 9

ü  1995: Release 10

ü  Release 10 Sub versions are 10.7NCA, 10.7.16.1, 10.7

ü  April 1998: Release 11

ü  Release 11 sub versions are 11.0, 11.0.1, 11.0.2, 11.0.3, 11.0.28

ü  July 16, 1998: First combined production installation of Oracle Applications Release 10.7 NCA at Leeson Electric Corporation.

ü  May 2000: Release 11i

ü  11i Sub Versions are 11.5, 11.5.1, 11.5.2, 11.5.3, 11.5.4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.0, 11.5.10.1, 11.5.10.2.

ü  Feb 2006: 11.5.10.2

ü  31 Jan 2007: R12

ü  R12 Sub Versions are 12.0.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, 12.0.5, 12.0.6, 12.0.7, 12.1, 12.1.1, 12.1.2, 12.1.3 and upcoming version is 12.2.


DATABASE VERSION LIST
  • Oracle v5
  • Oracle v6
  • Oracle7: 7.0.16–7.3.4
  • Oracle8 Database: 8.0.3–8.0.6
  • Oracle8i Database Release 1: 8.1.5.0–8.1.5.1
  • Oracle8i Database Release 2: 8.1.6.0–8.1.6.3
  • Oracle8i Database Release 3: 8.1.7.0–8.1.7.4
  • Oracle9i Database Release 1: 9.0.1.0–9.0.1.5 (patchset as of December 2003)
  • Oracle9i Database Release 2: 9.2.0.1–9.2.0.8 (patchset as of April 2007)
  • Oracle Database 10g Release 1: 10.1.0.2–10.1.0.5 (patchset as of February 2006)
  • Oracle Database 10g Release 2: 10.2.0.1–10.2.0.5 (patchset as of April 2010)
  • Oracle Database 11g Release 1: 11.1.0.6–11.1.0.7 (patchset as of September 2008)
  • Oracle Database 11g Release 2: 11.2.0.1–11.2.0.3 (patchset as of September 2011)
  • Oracle Database 12c Release 1: 12.1 (patchset as of June 2013)

MAJOR DIFFERENCE BETWEEN 11I AND R12



MAJOR DIFFERENCE BETWEEN 11I AND R12

11i
R12
Database version is 9i Rel-2
Database version in is 10g (10.2.0.2)
Tech stack in Application Tier consist of iAS & Developer 6i(Forms & Reports 8.0.6)
It is build on Fusion Middleware (10g web server and 10g Forms & Reports)
HTTP Server or Web server version 1.0.2.2.2 which is built in Apache Version 1.3.19
HTTP Server or Web server version 10.1.3 which is built in Apache Version 1.3.34
mod_Jserv
Mod_oc4j
Forms/Reports version is 6i
Forms/Reports version is 10.1.2.0.2 (10g)
In personalization level set_lov_property is not available
We can change the LOV
JDBC version is 9
JDBC version is 10.2.0
JDK/JRE version 1.3.1 or 1.4.2. Jinitiator at client side
JDK/JRE version 1.5.0. SUN JRE at client side
APPL_TOP path : $HOME/<SID>appl
$HOME/apps/apps_st/appl
COMMON_TOP path : $HOME/<SID>comn
$HOME/apps/apps_st/comn
ORACLE_HOME path : $HOME/<SID>ora/8.0.6
$HOME/apps/apps_st/10.1.2