Difference between Oracle Apps 11i and R12 (Technical)

On Client Side Differences,

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

Regards,
Kabz

Thanks for pointing this out.

Atul

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

Regards
Kumar

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

R u using new Start CD for R12 ?

Check patch # 5885627

Atul

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

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

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

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

sorry about duplicate posting’s

Regards,
Rahul.

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?

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

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

Hi Atul,

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

Regards,
Parag

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

Atul

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

zaheer

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

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

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

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

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

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

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

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.

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

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

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 ,

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

Thanks

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

Is this database listener or apps listener ?

Check listener logs

for DB check $TNS_ADMIN/log

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

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

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.

Check this

http://blogs.oracle.com/schan/2008/04/28#a2657

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

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

How much is memory on server ?

Memory size: 32GB

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

Thanks.

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

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

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

Plz reply me through Mail..

liked it…!

regards,
subodh Bhale

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

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/

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

hi Anil ,

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

Regards,
Razak

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.

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.

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

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

Hi atul,

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

Thanks and Regards
MKTS

Looks like Mr. Atul is on vacation 🙂

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

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

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.

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.

Anjireddym,
Thanks for this valuable information.

Hi,

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

Thanks,

Subbu

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.

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

Thank you very much Atul

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.

perl ojspCompile.pl –compile –flush

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

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

Hello Atul,

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

Thanks in advance

Hi folks,

Any body have upgadataion exp to r12 please help me out

thanks
lenin

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

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.

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

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

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

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.

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

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

Thanks Atul.

Best regards,

Rafi.

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

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

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

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.

@ 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

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

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

plz send the detail

@ Ateeqrn,
Check here

http://onlineappsdba.com/index.php/2007/02/20/prepare-for-oracle-apps-r12-installation/

http://onlineappsdba.com/index.php/2007/10/06/install-oracle-applications-r12-12i-on-unixlinux/

http://onlineappsdba.com/index.php/2007/01/30/oracle-apps-r12-installation-guide/

If any link is broken then post on that comment and I’ll try to find new link

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

In 11i applications report server was replaced with XML publisher. Please give a detailed explanation for this differrence