• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


    Company

  • Categories

  • Archive

  • Difference between Oracle Apps 11i and R12 (Technical)

    Posted by "" in "apps, r12" on 2007-04-08

    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.

    87 Responses to “Difference between Oracle Apps 11i and R12 (Technical)”

    1. Anonymous says:

      On Client Side Differences,

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

      Regards,
      Kabz

    2. Atul Kumar says:

      Thanks for pointing this out.

      Atul

    3. Anonymous says:

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

      Regards
      Kumar

    4. Anonymous says:

      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

    5. Atul Kumar says:

      R u using new Start CD for R12 ?

      Check patch # 5885627

      Atul

    6. Anonymous says:

      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

    7. Anonymous says:

      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

    8. Anonymous says:

      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

    9. Atul Kumar says:

      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

    10. Anonymous says:

      sorry about duplicate posting’s

      Regards,
      Rahul.

    11. Anonymous says:

      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?

    12. Atul Kumar says:

      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

    13. Anonymous says:

      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

    14. Anonymous says:

      Hi Atul,

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

      Regards,
      Parag

    15. Atul Kumar says:

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

      Atul

    16. Anonymous says:

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

      zaheer

    17. Atul Kumar says:

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

    18. yas says:

      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

    19. Atul Kumar says:

      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

    20. Anonymous says:

      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

    21. Atul says:

      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

    22. Anonymous says:

      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

    23. Atul says:

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

    24. SenthilKumaran says:

      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.

    25. Harish says:

      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

    26. Atul says:

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

    27. baleeswara reddy says:

      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 ,

    28. Harry says:

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

      Thanks

    29. reddy says:

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

    30. Atul says:

      Is this database listener or apps listener ?

      Check listener logs

      for DB check $TNS_ADMIN/log

    31. Paul says:

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

    32. Atul says:

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

    33. Paul says:

      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.

    34. chiranjeevi says:

      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

    35. chiranjeevi says:

      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

    36. Atul says:

      How much is memory on server ?

    37. chiranjeevi says:

      Memory size: 32GB

    38. Paul says:

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

      Thanks.

    39. Atul says:

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

    40. Atul says:

      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

    41. Jaffer says:

      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

    42. Jaffer says:

      Plz reply me through Mail..

    43. subodh says:

      liked it…!

      regards,
      subodh Bhale

    44. Kamlesh says:

      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

    45. Atul says:

      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/

    46. Hamid says:

      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

    47. AbdulRazak says:

      hi Anil ,

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

      Regards,
      Razak

    48. Rajasekhar Gupta says:

      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.

    49. venu says:

      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.

    50. maulik says:

      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

    51. Prasad says:

      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

    52. mkthamariaselvan@yahoo.com says:

      Hi atul,

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

      Thanks and Regards
      MKTS

    53. Sam says:

      Looks like Mr. Atul is on vacation :-)

    54. nazlfc says:

      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

    55. […] 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); } […]

    56. anjireddym says:

      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.

    57. 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.

    58. Atul Kumar says:

      Anjireddym,
      Thanks for this valuable information.

    59. Subramanyam says:

      Hi,

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

      Thanks,

      Subbu

    60. Subramanyam says:

      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.

    61. Atul Kumar says:

      @ 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/

    62. subramanyam says:

      Thank you very much Atul

    63. Haris says:

      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.

    64. Atul Kumar says:

      perl ojspCompile.pl –compile –flush

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

    65. er.ankitc@gmail.com says:

      Hello Atul,

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

      Thanks in advance

    66. mleninbabu says:

      Hi folks,

      Any body have upgadataion exp to r12 please help me out

      thanks
      lenin

    67. fuyu says:

      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

    68. khajamohiddinpathan says:

      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.

    69. manju says:

      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

    70. ashishm59 says:

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

    71. Atul Kumar says:

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

    72. mohd javed says:

      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.

    73. rafi says:

      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

    74. Atul Kumar says:

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

    75. rafi says:

      Thanks Atul.

      Best regards,

      Rafi.

    76. […] 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 […]

    77. Anonymous says:

      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

    78. Atul Kumar says:

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

    79. chaitanya says:

      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.

    80. Atul Kumar says:

      @ 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

    81. Shah says:

      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

    82. ateeqrn@gmail.com says:

      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

    83. ateeqrn@gmail.com says:

      plz send the detail

    84. sanju says:

      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

    Leave a Reply



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP
    TOP