Difference between Oracle Apps 11i and R12 (Technical)

Based on high influx of mail from users requesting difference between Oracle Applications Release 12 and 11i , I decided to dedicate this post to outline few major technical difference.

Database:
Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2)

Application Tier:
Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6) but in Applications R12 it is build on Fusion Middleware (10g Web Server and 10g Forms & Reports)

Sub component in Application Tier
A) HTTP Server or Web Server in R12 is Version 10.1.3 which is built on Apache version 1.3.34. In apps 11i it is Version 1.0.2.2.2 built on Apache Version 1.3.19
B) Jserv in apps 11i is replaced by OC4J (mod_jserv is replaced by mod_oc4j)
C) Forms Version 6i in Apps 11i is replaced by Forms 10.1.2.0.2 in R12
D) Reports Version 6i in Apps 11i is replaced by Reports 10.1.2.0.2 in R12
E) JDBC version is changed from version 9 in apps 11i to version 10.2.0 in Apps R12
F) modplsql or mod_pls is removed from Apps R12 (What will happen to my mod plsql applications- coming soon* )
G) Java processes use JDK/JRE version 1.5.0 in R12 against JDK version 1.3.1 or 1.4.2 in Apps 11i
H) For various environment variable changes check below picture

I) New top INSTANCE_TOP added in Release 12 for configuration and log files

Related:

http://becomeappsdba.blogspot.com/2007/01/oracle-apps-r12-file-system-changes.html

If you think I missed any Technical changes in Release 12, Kindly leave a comment so that it can be useful to everyone.

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

87 comments
Anonymous says April 11, 2007

On Client Side Differences,

Client Plugin will be Sun JRE(1.5) replacing the good old Jinitiator.

Regards,
Kabz

Reply
Atul Kumar says April 11, 2007

Thanks for pointing this out.

Atul

Reply
Anonymous says April 19, 2007

What is Sun JRE(1.5) ? How it differs from J-initiator?

Regards
Kumar

Reply
Anonymous says May 9, 2007

Dear Atul,

I am trying to installatoin of Apps12 but eng of installation only one error display which is

“Login Page
checking URL = http://apps.isb.ots.com:8000/OA_HTML/AppsLogin
RW-50016: Error: – {0} was not created:
File = {1}”

Please solve this problem ASAP.

Thanks

Noman

Reply
Atul Kumar says May 9, 2007

R u using new Start CD for R12 ?

Check patch # 5885627

Atul

Reply
Anonymous says May 28, 2007

Hello Atul,
I want to learn AppsDBA, shall I begin with installation of R12 or 11.5.10.2?
If 11.X from where I can download vision demo? (when I browse edelivery, I do not see any thing about vision demo, could you please through some light on this)

Thank you,
Rahul

Reply
Anonymous says May 28, 2007

Hello Atul,
I want to learn AppsDBA, shall I begin with installation of R12 or 11.5.10.2?
If 11.X from where I can download vision demo? (when I browse edelivery, I do not see any thing about vision demo, could you please through some light on this)

Thank you,
Rahul

Reply
Anonymous says May 28, 2007

Hello Atul,
I want to learn AppsDBA, shall I begin with installation of R12 or 11.5.10.2?
If 11.X from where I can download vision demo? (when I browse edelivery, I do not see any thing about vision demo, could you please through some light on this)

Thank you,
Rahul

Reply
Atul Kumar says May 28, 2007

Rahul,
You can try either of two. They are two version of ERP from Oracle.

Once you download R12 software (38GB software only) then when you install that software you get an option to install demo or fresh/prod (without demo) erp

Reply
Anonymous says May 28, 2007

sorry about duplicate posting’s

Regards,
Rahul.

Reply
Anonymous says May 29, 2007

Could you please let us know the significance of INST_TOP in R12. Why do we need this new top in R12 seperately for config and log files?

Reply
Atul Kumar says May 29, 2007

Thanks for pointing out above INST_TOP and its requirement. I’ll try cover this in coming post soon as its diffcult to explain here

Reply
Anonymous says June 13, 2007

Hi Atul,

What is the discoverer version that comes with R12?I couldn’t find any discoverer details in context file?can u pls help me on this.

Thanks,
appsdba

Reply
Anonymous says June 14, 2007

Hi Atul,

What are the differences with respect to Discoverer between Release12 and 11i?

Regards,
Parag

Reply
Atul Kumar says June 14, 2007

Parag,
R12 uses DBI (Daily Business Intelligence) Though you can still integrate 10.1.2 discoverer with R12

Atul

Reply
Anonymous says June 26, 2007

hi atul what are the difference between 11.5.x and R12 installation on linux?

zaheer

Reply
Atul Kumar says June 26, 2007

Installation wise not much difference except on linux with 11i u need JDK as prereq. which is no more required in R12

Reply
yas says July 31, 2007

hi atul
i am new DBA . i install r 12 in my server system . but in post installation check . i have linux ES 4 . 300 gb hard disk with good processor i get this error. http , login (file was not created ), jsp is not responding , virtual directory (file was not created ), help page error

can u say what i wan to do for resolve this error …asap

thanks

yaseen.a.r

Reply
Atul Kumar says July 31, 2007

Hi how much was memory during R12 installation on server ?

What is error message you get like RW ..in isntallation logs .

For any issues raise them in forum at http://teachMeOracle.com/forum with above details

Reply
Anonymous says August 6, 2007

Hi,
I am trying to install Oracle Apps12 on RHEL but at the end of installation only one error display which is

“Login Page
checking URL = http://apps.ib.com:8014/OA_HTML/AppsLogin
RW-50016: Error: – {0} was not created:
File = {1}”

I am not sure if it requires any patch like 5885627.

It would be great if any one can suggest the solution or provide the link from where I can get this patch As I don’t have access to metalink.

Thanks
Namchand
namchand@yahoo.com

Reply
Atul says October 6, 2007

Anon Said
===========
Where is the report server executable in R12. In 11i, we can check the OS server process for reports and forms server with ps -ef|grep rwmts and ps -ef|grep f60srvm. But in R12 how do we check the OS process for forms and reports server?

We replied
==========
Forms are Reports in R12 are in OC4J process which is controlled by OPMN check “opmnctl status” for R12

Atul

Reply
Anonymous says October 25, 2007

Hi Atul,

I checked the opmnctl status in R12, i can see the status for forms,asg,oacore and HTTP_Server in that. But where do i find if the reports server is running for R12.

Thanks,
Karthik

Reply
Atul says October 25, 2007

Open adrepctl.sh and look for port on which its listening & log file then “ps -ef | grep report_port_no”

Reply
SenthilKumaran says December 19, 2007

Hi atul,
Execpt /OAD_TOP/_pages what are the cahes are existing in release12. Really i need to know what happen to plsql and session in r12.

Reply
Harish says January 2, 2008

Hi

my name is harish.i am doing as a DBA in my office.can u help me what course i have to learn to improve my skill and for the future purpose

Reply
Atul says January 2, 2008

Go for 11i/r12 apps dba or fusion middleware (SOA Suite)

Reply
baleeswara reddy says February 25, 2008

hi atul ,

how did i create a concurrent request , and how did i run report as concurrent request,

what will be the suitable suggestion when concurrent request is taking long time ,

Reply
Harry says March 25, 2008

Hi Atul,
could u plz tell where the xml file is placed in r12. its not there in $APPL_TOP/admin.

Thanks

Reply
reddy says April 9, 2008

After cloning if listener not coming up .What is solution?

Reply
Atul says April 9, 2008

Is this database listener or apps listener ?

Check listener logs

for DB check $TNS_ADMIN/log

Reply
Paul says May 5, 2008

Atul, In R12, Is Jinitiator still in use? Thanks.

Reply
Atul says May 6, 2008

Default in R12 is Java Plugin but you can configure to use Jinitiator as well

Reply
Paul says May 6, 2008

Hi Atul,
Do you have any doc/steps on upgrading from 11i (11.5.9 or 11.5.10) to R12(12.0.x) ?
I am looking for general steps.
Thanks.

Reply
chiranjeevi says May 22, 2008

Hi All,
I am trying to install Oracle Apps12 on Solaris10 but at the end of installation only one error while creating the Virtual Directory display which is

“Login Page
checking URL = http://blresxoracle01.com:8001/OA_HTML/AppsLogin
RW-50016: Error: – {0} was not created:
File = {1}”

It would be great if any one can suggest the solution or provide me the work around.

Thanks
Chiranjeevi

Reply
chiranjeevi says May 22, 2008

Hi All,

I am trying to install Oracle Apps12 on Solaris 10 but at the end of installation only one error while creating the Virtual Directory display which is

“Login Page
Checking URL: http://blresxoracle01.com:8001/OA_CGI/FNDWRR.exe

RW-50016: Error: – {0} was not created:
File = {1}”

It would be great if any one can suggest the solution or provide me the work around.

Thanks
Chiranjeevi

Reply
Atul says May 23, 2008

How much is memory on server ?

Reply
chiranjeevi says May 23, 2008

Memory size: 32GB

Reply
Paul says May 23, 2008

Hi Atual,
Do you any documentation on migrating from 10.7 to R12?

Thanks.

Reply
Atul says May 23, 2008

Paul,
You can’t go to R12 from 10.7. First you have to upgrade it to minimum 11.5.7

Reply
Atul says May 23, 2008

chiranjeevi,
Check log file for installation and startup of services in R12 to find any issues http://onlineappsdba.com/index.php/2007/12/25/oracle-r1212i-log-file-patch-clone-startupshutdown/

This is because services didn’t start properly either because of failed installation or any other reason which you can find in log files

Reply
Jaffer says July 17, 2008

Hi Atul,,

As of now Iam learning D2K as it wll be helpful to
learn Oracle apps technical quickly ..now R12 has came into picture ..will D2K will be completly Vanished or ..it wll help me ANYWAYZ..plz reply me..

Thx

Reply
Jaffer says July 17, 2008

Plz reply me through Mail..

Reply
subodh says September 17, 2008

liked it…!

regards,
subodh Bhale

Reply
Kamlesh says September 30, 2008

Hi Atul,

I gone through your all blogs related Oracle apps. they are great. more user friendly that Oracel documentation. I am new in Oracle and trying to install OOracle Apps.

One cofusion: in you document you mentioned Oracle R12 installtion is avaiblable on edelivery.oracle.com but I found ther only VM server,Enterprise linux, not R12 installation. please help.

Reagrds,

Kamlesh

Reply
Atul says September 30, 2008

Kamlesh,
What URL you are using in edelivery ?

Select product stack as E-Business Suite and you o.s. as shown in link here

http://onlineappsdba.com/index.php/2008/07/02/install-oracle-apps-r1212i-on-windows/

Reply
Hamid says November 3, 2008

Hi,

We upgarded from 11.5.9 to 11.5.10.2 , one of our 350 character wide report is giving output as wrapped.It was ok before upgrade. Please help.

Thanks,
Awaiting for the reply

Reply
AbdulRazak says December 11, 2008

hi Anil ,

My name is Razak from Saudhi Areb,
please send any document about Developed new form in Oracle apps R12..

Regards,
Razak

Reply
Rajasekhar Gupta says December 16, 2008

Hi,

Oracle Apps R12 and 11i Difference is missing Tables information.

11i few tables not available in R12. There may be Alternate tabels came in R12 that information is not available. Please let me know for Finance Modules.

Rajasekhar Gupta.

Reply
venu says December 18, 2008

Hi
I want to know what is the major difference between the Oracle apps 11i and R12…
what are the tables involved in r12…in modules like po,inv,ap AND HRMS

PLease send me reply ASAP.
Thanks
Venu.

Reply
maulik says December 25, 2008

Hi all,

getting error during the Upgrade (11.5.10.2 to 12.0.0) and OS is RHEL 4.

checking URL = http://vis.evosys.co.in:8000/OA_HTML/AppsLogin

RW-50016: Error: – {0} was not created:
File = {1}

Thank you

Regards

Maulik Jani

Reply
Prasad says January 14, 2009

Hi Maulik,

Please try the below solution for the error u r facing

Soultion:

1) Try to login with following URL:

http://:/OA_HTML/fndvald.jsp?username=sysadmin&password=

If main home page appears then try to click any responsibility. If resposibilities are not working i.e. while clicking on responsibility page getting blank or getting “The page cannot be displayed” then clear the cache and compile jsp’s as given in Step 2.

If Step 1 doesn’t work then move to Step2:

2) Clear the cache and compile jsp’s

* Remove _pages under $COMMON_TOP
* cd $FND_TOP/patch/115/bin

./ojspCompile.pl –compile –flush -p 2

* Try to login again as per Step 1

Regards
Prasad

Reply
mkthamariaselvan@yahoo.com says January 15, 2009

Hi atul,

Could you explain what are table/schema has changed in r12 from r11i. (particularly for AP only)

Thanks and Regards
MKTS

Reply
Sam says January 28, 2009

Looks like Mr. Atul is on vacation :-)

Reply
nazlfc says March 5, 2009

Hi,

Please can anyone help me. I have following error (as have others it appears)

RW-50016: Error: – {0} was not created:
File = {1}

This happens on the rapidwiz post install system checks. One of the things I have done to resolve this is to modify my /etc/hosts file but this has not worked.

I have done the following:

127.0.0.1 localhost.localdomain localhost

to

127.0.0.1 localhost.localdomain

has mentioned in a metalink note.

Please can anyone let me know if this is a memory issue. I am installating EBS R12 on a virtual pc using virtual box on the OEL5 platform. I have also had the vision db installed too.

I cannot get pass this stage and I really need to do some testing on the apps product.

Any help will be greatly appreciated.

Thanks

Naz

Reply
» Upgrade Oracle Applications to Release 12.0.2 Online Apps DBA: One Stop Shop for Apps DBA’s says May 9, 2009

[…] Technical Difference between Oracle Apps 11i & R12 File System Changes in Oracle Applications R12 Install Oracle Apps R12 on VMWare linux Start-Up/Shutdown Scripts in Oracle Applications R12 Unified APPL_TOP in Oracle R12 : New Feature Prepare Database Uprade for 11i to R12 Previous in series Related Posts for R12 Upgrade Oracle R12 Upgrade from 11i and Database VersionsUpgrade Oracle Applications to Release 12.0.2 var OutbrainPermaLink=”http://onlineappsdba.com/index.php/2007/10/13/upgrade-oracle-applications-to-release-1202/”; var OB_demoMode = false; if ( typeof(OB_Script)!=’undefined’ ) OutbrainStart(); else { var OB_Script = true; var str = “”; document.write(str); } […]

Reply
anjireddym says June 1, 2009

In 11i, all jsp compilation errors are logged in $IAS_ORACLE_HOME/Apache/Jserv/logs/mod_jserv.log

But in R12, all jsp compilation errors are logged in $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

This is useful for developers writing new jsps in R12 instance.

Reply
jsp compilation errors in R12 says June 1, 2009

In 11i, all jsp compilation errors are logged in $IAS_ORACLE_HOME/Apache/Jserv/logs/mod_jserv.log

But in R12, all jsp compilation errors are logged in $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

This is useful for developers writing new jsps in R12 instance.

Reply
Atul Kumar says June 1, 2009

Anjireddym,
Thanks for this valuable information.

Reply
Subramanyam says July 26, 2009

Hi,

How to upgrade Oracle Apps 11i Discoverer reports to R12.

Thanks,

Subbu

Reply
Subramanyam says July 30, 2009

Hi Atul,

My client using Discoverer 4i for Oracle apps 11i instance .Now we are upgrading the Instance to R12.How can i move this all discoverer reports to R12 Instance.

It is possible to migrate all the discoverer 4i reports to R12 instance?

Thanks

Subbu.

Reply
Atul Kumar says July 30, 2009

@ Subbu
If you are using Oracle Discoverer, you must perform the Discoverer implementation steps described in Metalink Note 373634.1 Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12

Main Task –

1. Install 10g Discoverer 10.1.2.0.2
2. Apply latest patchset for discoverer
3. Copy dbc file from apps to 10.1.2.X discoverer
4. Add entry in tnsnames.ora of 10.1.2.X disco
5. Migrate EUL from 4i to 10.1.2 using eulapi
6. Set profile options in apps to point to 10.1.2.X discoverer URL

For more information click http://onlineappsdba.com/index.php/2009/06/17/discoverer-with-oracle-apps-r12/

Reply
subramanyam says August 1, 2009

Thank you very much Atul

Reply
Haris says August 8, 2009

I am getting “jsp error – jsp writter failed” while viewing DBI dashboard, however all drop down menus are shown.

I want to recompile jsp pages but dont know how to recompile it.
I am using E-Business Suite 11.5.10.2.

Any help will be greatly appreciated.

Thanks.

Reply
Atul Kumar says August 9, 2009

perl ojspCompile.pl –compile –flush

ojspCompile.pl should be under $FND_TOP/patch/115/bin/

Reply
» Oracle Apps R12 Interview/Reader’s Question : opmnctl status Online Apps DBA: One Stop Shop for Apps DBA’s says January 4, 2010

[…] For technical differences between 11i & R12 click here […]

Reply
er.ankitc@gmail.com says January 21, 2010

Hello Atul,

Can you please help me for some Architectural differences as well..

Thanks in advance

Reply
mleninbabu says March 19, 2010

Hi folks,

Any body have upgadataion exp to r12 please help me out

thanks
lenin

Reply
fuyu says August 16, 2010

Hi Atul,

I saw a few discussions about report server. R12 no longer uses report server, instead reports are run through concurrent managers. The concurrent manager builds necessary command line to run the report, equivalent to how a report would be run at the command line.

Regards

Fuyu

Reply
khajamohiddinpathan says August 29, 2010

hi im haivin problem while im istaling linux on vmware-player3. version for r-12 my conifig is P4,2gb ram,160hdd,
wt iwil do plese giv me reply.

Reply
manju says September 28, 2010

very good info…we are getting and we need some more update info.. about how to design the r12 from …process flow steps… hopefully am getting positive responds…

Regards,
Manju

Reply
ashishm59 says December 20, 2010

Is its posible that both sql server 2008 R2 & orcale 11g R2 are installed

Reply
Atul Kumar says December 20, 2010

@ ashishm59,
Yes it is possible to install both SQL server and Oracle 11g R2 on same certified windows machine.

Reply
mohd javed says April 7, 2011

Hello Atul.

i have migrate oracle 6i report but i don’t want to change code 6i report & i don’t want to use web_show_document,how to migrate report using run_product .So please specify me detail regarding that it is not working 10.2.0.2 10g ..

Thanks in advance.

Reply
rafi says May 18, 2011

Hi Atul,
I frequently read your blog and follow also.Can you please let me know some difference
between 12.0.4 and 12.1.1

Reply
Atul Kumar says May 18, 2011

@ Rafi,
Check note 566521.1 Oracle Application Object Library Release Notes, Release 12.1.1

Reply
rafi says May 31, 2011

Thanks Atul.

Best regards,

Rafi.

Reply
» Changes in Oracle E-Business Suite R12 12.2 from 12.0.x and 12.1.x Online Apps DBA: One Stop Shop for Apps DBA’s says September 21, 2011

[…] 12.0/12.1 and 12.2. If you want to see changes between Oracle Apps 11i and R12 then check here , here or Rupesh’s Posts […]

Reply
Anonymous says November 18, 2011

I have different R12 enviorments and users get confused with different links so wondering if there is a way to alias the following login page.

http://hostname.domainname:port/OA_HTML/AppsLogin

to like “PROEBS” or “UATEBS” something like that so that the users don’t need to remember the ports which is aso error prone.

Thanks
EB

Reply
Atul Kumar says November 18, 2011

@ EB,
You can create webpage and create hyperlink like PROEBS (and EBS URL as link <a href=””)

Reply
chaitanya says April 4, 2012

Hi Atul,
Here in 11i oracle version it supports is 10g

R12 supports 11g version of oracle .

In the first few lines you had mentioned in reverse order.Readres please note this change.

Reply
Atul Kumar says April 4, 2012

@ chaitanya,
Thanks for your comment. Could you please copy paste from my post on what you think is not correct ?

What I mean by “Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2)” is that when you install 11i , by default you get database version 9i R2 where as with R12 (12.0.x) default database is 10.2.0.2 .

With 12.1.x default database is 11.1.x

Reply
Shah says July 19, 2012

Hi Atul,

I would like to know the basic difference between 11i and 12. Also in terms of functionalities what changes is being done in R12

Reply
ateeqrn@gmail.com says August 23, 2012

hi atul can u plz tell the installation process of oracle apps tech (R12) on linux and i didnt have any kind of s/w can u tell from where i download these s/w
plzz tell the step by step process of installation guide

Reply
ateeqrn@gmail.com says August 23, 2012

plz send the detail

Reply
sanju says March 21, 2014

Hi

I am begninnger in Oracle apps dba ,I am trying to understand the version of oracle apps 11,app 12.1 and 12.2 .

In 12.2 oracle ebs arechitecture ,its not showing in concurrent manger,Please let me know where is exist in conurrent manager in 12.2 version

Regards
Sanju

Reply
Add Your Reply