Oracle E-Business Suite Technology

Dear steven,
I cloned my production and did upgrade from 12.0.4 (financial 12.0.5) to R12.1.1 following metalink note every thing went smooth and fine. I only faced one issue while applying patch (R12.AD.B.1 (Patch 7461070)

“AutoPatch error:
aiprfp: product 'cle' not in release 'R120'
AutoPatch error:”
The solution was not documented on metalink for this case exactly but for other case the solution was to remove the cle line from the file called topfile.txt under $APPL_TOP/admin just wanted to share this so others can get benefit. Other than that it went all fine
Fadi

Dear Steven
This is excellent news. I've been awaiting the release of 12.1.1 with baited breath.
Media is already on its way, and I plan to start an upgrade from 11.5.9 this week, closely followed by an upgrade of the database to 11g.
Please pass on my congratulations to the product teams.
Regards
Stuart

Hi,

I am plan to upgrade the instance to 12.1.1 from 12.0.4 Is it necessary to upgrade the DB also. Our DB is 10.2.0.3.0. With out upgrade can we proceed further. Kindly advise.

Regards,
Venkat.

HI Steven,

Great news, this version is very help full to clients who are planning to upgrade from 11i to 12i.

Regards,
Phani.K

Steve,

What will be the default version of Techstack with R12.1.1. Is the latest patcheset 10.1.2.3 and 10.1.3.4 are included with R12.1.1.

Thanks
Jyoti

Steve,

I read your article and came to know the patchset 10.1.2.3 and 10,1.3.4 are included with R12.1.1.

I am unable to download the R12.1.1 upgrade guide, The link is taking me to download R12.0.4 upgrade guide.

Please let me know the right link to download upgrade guide.

Thanks
Jyoti

Hello, Fadi,

Thanks for sharing that with our readers. I look forward to hearing more about your experiences with this release.

Regards,
Steven

Dear Stuart,

Thanks for your comment. I trust that the media has arrived by now and that your upgrade is underway.

Good luck with your upgrade from 11.5.9. I'd be very interested in hearing your feedback on how that upgrade process worked for you.

Regards,
Steven

Hi, Venkat,

You can refer to Note 752619.1, which shows that 10.2.0.3 is an acceptable database level on which the 12.1.1 Maintenance Pack can be installed.

Good luck with your upgrade to 12.1.1! I look forward to hearing about your experiences with this upgrade.

Regards,
Steven

Hi, Jyoti,

Glad to hear that you managed to answer your own question while I was on vacation. Thanks for pointing out the incorrect link; I've corrected it now.

Good luck with your upgrade. I look forward to hearing about your experiences with this release.

Regards,
Steven

Hi Steven,

Recently I have installed fresh R12.1.1 media pack on OEL 4.7 and the installation was successful and was doing a smoke testing on the modules.

I fixed couple of issues by regenrating the forms in WSH Module.

I am having problem with viewing attributes of the Item on the Items screen (Items > Master Items , Organization Items) in Inventory.

Before the Item screen opens it is showing me as a Note saying "you must allow access to at least one attribute group"

Moreover when I open Item Attribute Controls form (Setup > Items > Attribute Controls) it's giving me an exception saying no data found.

I have checked the Organization Access (Setup > Organizations > Organization Access) form and all the setups are correct but still why am I getting the above Note and the item attrubutes are becoming inactive.

Moreover adadmin recognize only fnd and not any other modules like 'wsh', 'inv' etc... I have to do it manually for wsh using frmcmp_batch command.

Kindly help me.... Also am I missing any Patch application because I am doubtful on Oracle releasing R12.1.1 without regenerating the forms.

Thanks,
Vijay

Good News Guys!!! Finally this issue is reolved...

Cause: The components for the Inventory Items screen are not licenced in License Manager for R12.1.1.

Fix: Please license the Products through System Administration or System Administrator Responsibility.

System Administrator > Oracle Applications Manager > Lincese Manager

Click on the the Products under License section and license the Products.

After performing the above steps the Items Screen attributes are active.

Also regenerate all the forms in WSH Module as R12.1.1 has a bug in WSH Transactions screen while Pick Release and Ship Confirm.

Thanks for all the help...

VijayR

Vijay,

Thanks for sharing this with our readers. I look forward to hearing more about your experiences with this release.

Regards,
Steven

Hi Steve,

I want to buy the media pack for Release 12.1.1 for Microsoft Windows 32 bit, as it will take forever from me to download from Oracle Electronic Product Delivery, because of low bandwidth internet connection.

But, I am not able to find Release 12.1.1 on oraclestore.oracle.com.
Am I looking at a wrong URL ?
Please advise.

Regards
Mallik

Hi,
I installed Oracle R12.1.1 on Vista 32-bit (Windows) platform.
Everything went smooth.
I'm able to login as sysadmin to Brower interface. When I try to go to form based interface, I get the error
FRM-92101: Failure in Forms Server during startup. This could happend ue to invalid configuration. Please look into the web-server log file for details.
I restarted the opmn with adstrtal.cmd and everything looks good.

Did anyone face the same problem? Could anyone suggest what is going on?
Thanks

Hi, Mallik,

I'm part of EBS Development. I'm afraid that I don't have a lot of insight into the Oracle Store and don't have any contacts in that organization. Your best bet for getting help with this might be to call Oracle Sales at 1-888-Oraclei (1-888-672-2534) or email them at edrstore_us@oracle.com. More info is here:

http://oraclestore.oracle.com/OA_HTML/ibeCZzdHelp.jsp?sitex=10021:22372:US

Regards,
Steven

Hi, Sandip,

Glad to hear that you're working with R12.1.1. I haven't seen this error reported yet. I suspect that there might be something simple in the configuration that needs to be tweaked to get past this error.

I'd recommend logging a formal Service Request via Metalink to get one of our installation specialists engaged. Good luck with the rest of your project.

Regards,
Steven

Steven,

It doesn't appear that Oracle HRMS Release Update Pack 7 for 12.0 (R12.HR_PF.A.DELTA.7), patch # 7577660 is included with 12.1.1. It was built 17 days after the release 12.1.1. Would you know if the changes delivered by RUP 7 for 12.0 are included in 12.1.1?

Thanks,

Kevin

Hi Gurus:

We did our CRP 1 on R12.0.4 and we are plannign to do UAT on 12.1.1. So we want to know wheather 12.1.1 is a stable release to go live or rather we should prefer 12.0.6?

Please advise on R12.1.1

Hi, Kevin,

I'm afraid that I don't have much visibility into product team functional patches and their content.

Your best bet would be to log a formal Service Request against the HRMS product. An HRMS specialist should be able to tell you about the relationship between fixes in 12.1.1 vs. HRMS Release Update Pack 7.

I look forward to hearing about your experiences with this release.

Regards,
Steven

Hi, Prasanna,

I would strongly recommend 12.1.1 over 12.0.6. 12.1.1 includes many product enhancements and other updates for stability, security, and performance that aren't included in 12.0.6.

Good luck with your implementation. I look forward to hearing about your experiences with this release.

Regards,
Steven

Steven,

We're playing about with 12.1.1, and generally looks to be fine. Prod install done, in the middle of 1st clone from that and it's going ok.

We have, however, hit some issues with the Vision install.
- There was only 1 product licensed in the installed system (Which I'm sure is incorrect for the default in a Vision system).
- Trying to create an OEM DBControl system in the Vision installed 11.1.0.7 $ORACLE_HOME doesn't work. It seems to want to place files in filesystems we don't have(/nfs/bld/d26/PRDXBLD9/db/tech_st/11.1.0/). Looks to be an internal build structure?

To me it looks like the bundled 11g ORACLE_HOME with 12.1.1 hasn't been created / packaged in the 12.1.1 media correctly.

The media was downloaded from edelivery.oracle.com, and is for Linux x86. The same media was used for the Prod install, and it works as expected (including the OEM DB Control creation).

Any thoughts on what may be going on?

Thanks
Des

Hi, Des,

I appreciate your sharing your experiences with EBS 12.1.1 so far. Glad to hear that the initial install went smoothly.

I don't have any insight into what might be going on with the OEM DBControl integration. I'd like to have our Install team look into this. Would you mind logging a formal Service Request via Metalink to get that team engaged?

Regards,
Steven

Steven,

One of my co-workers confirmed with Oracle Support that the changes in RUP7 (HRMS) for 12.0.x are not in the current patch for R12.1 and will be coming as a separate patch in July.

Thanks,

Kevin

Hi, Kevin,

Thanks for sharing that with our readers. Good luck with the rest of your 12.1.1 evaluation.

Regards,
Steven

Where can I find Rel 12.1. footprint or for that matter a Rel12 footprint?

Dear All valuable pears,

i am new at this blog , it seems so practical.. in fact we are planning for Oralce EBS R12.1..1 (latest release) on RHEL Linux 5 (latest) and on x86-64 bit architecture ... we need to get from you guys .... what kind of db, app & test node server configurations like (your good tested machines for 100 ~150 users ) load.. with applications (Fin , Purc, INv, OM) and brand of hardware like Dell 2850 , HP DL 380 or any other good & ecnomic option....
2ndly as we are new in Oralce Apps ... we dont clear idea for backup sizes and methads... .could you please sahre wheather tape backup , dVD , backup or any other media whould be used and how much sapce requirements , we need to have .. again sharing for your tested backup stratigy....

I will really be so much oblige for prompt feedback.
Regards,
Muhammad Waseem
Manager IT - NC TEX -31-Q Guberg II, Pakistan

Hello, Muhammad,

You might find this presentation useful:

Case Study Redux: Oracle's Own Oracle E-Business Suite Release 12 Upgrade (OpenWorld 2008 Recap) - http://blogs.oracle.com/stevenChan/2008/10/case_study_redux_oracles_own_ebs12_upgrade.html

It has details about the hardware that Oracle itself uses for our own global single instance of EBS.

As for load-testing and sizing recommendations: I'd recommend consulting with your hardware vendor for more detailed guidance. They're better-able to perform load-testing with their latest server models than Oracle.

I'll leave it to other readers to comment on their own operational practices for backups. If you don't get any responses here, you might wish to cross-post your question on our R12 Upgrade Forum on the Oracle Technology Network:

http://forums.oracle.com/forums/forum.jspa?forumID=395&start=0

Good luck with your R12 implementation.

Regards,
Steven

Hi, I am also new to the blog and find it extremely useful & educational. I have a question though. Does Oracle Access Manager replace SSO in R12.1? I read the FAQ's from Oracle's webpage on Access Manager and it seems that Access Manger is for non-Oracle deployments and SSO for Oracle Deployments.

I would like to understand the current and future positioning of these 2 products.

Many thanks
cornelia

Hello

We have Oracle Ebusiness suite 11.5.10 and most of integrations are point2point.

We have IBM Websphere middleware products to integrate with applications , MQ WBI-MB , WPS & Datastage (ETL). We have used this product to integrate with other applications , but not with Oracle Ebusiness Suite.

We have multiple type of integration patterns Batch , Event and Request/Reply.

Can you please let me know the possible options to integrate with Ebusiness Suite version 12.1

We had done POC couple of months back to use XML Gateway/AQ/MQ for Async and worked succesfully , but not sure that is the direction.

Please point me to a document or best practise.

Hi, Cornelia,

By default, EBS 12.1 allows users to log in via its own native log-in screens. No additional authentication tools are required.

You can optionally integrate EBS 12.1 with Oracle Single Sign-On (SSO) if your organization's needs exceed that of the native EBS 12.1 log-in capabilities. If you wish to use Oracle Access Manager (OAM), it needs to be integrated with Single Sign-On, which results in the following architecture:

EBS SSO OAM

We're investigating other options for integrating OAM directly with the E-Business Suite.

I don't have firm schedules for this OAM certification yet, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.

Regards,
Steven

Hello, RM,

There are many ways of integrating with the E-Business Suite. You can use standards like EDI, RosettaNet, SOAP, SOA / Web services, and even integration tables for batch uploads.

We document all E-Business Suite integration points and methods in the Integration Repository. For Oracle E-Business Suite Release 11i, you can find more details about that in this article:

Integration Repository for the E-Business Suite -
http://blogs.oracle.com/stevenChan/2006/05/integration_repository_for_the.html

Unlike EBS 11i, the Integration Repository is built into Oracle E-Business Suite Release 12. Therefore it stays up-to-date with new integration points every time you apply a new EBS patch. Your best option for accessing the R12 Integration Repository would be to install an R12 Vision Demo environment and browse through the repository.

You might also find the following article useful:

E-Business Suite + Fusion Middleware Best Practices Center Launched -
http://blogs.oracle.com/stevenChan/2008/05/ebusiness_suite_fusion_middlew.html

Regards,
Steven

Thanks for the reponse.

Most of the documents states use BPEL process server and adapter but was looking for a option a document which gives me more details on how to use third party software to integrate with ebusiness suite.

eg EBS Events -> JMS ->Websphere MQ -> Websphere Message broker
or
EBS->WebserviceCall->WPS or EBS-Webservice Call->Websphere message Broker

or

Websphere message broker->Webservice call->EBS

Thanks for your help

Hello, RM,

I have not seen any Oracle-produced documentation along those lines. I don't think there are any Oracle teams that are investing in producing documentation for IBM WebSphere.

I would suggest contacting IBM to see whether they have produced any WebSphere-specific documentation.

Regards,
Steven

Hi Steve,
I was able to resolve the issue on Vista install by reinstalling .NET framework (reinstall the stack).

Later, I moved on to Oracle Enterprise Linux 5.3 and installed Oracle R12.1.1 on OEL 5.3. Installation was successful.
Now when I try to access the screen, I get some issue as

"You do not have access to this functionality" and
"YOu must allow access to at least one attribute group."

Thanks
Sandip

Hi Steve,
I'm trying to enable and configure Oracle CMRO. I get the error "You do not have access to this functionality."
I went into License Manager and enabled all licenses (Site wise, Component and each individual application products). Logged out and logged back.
Still I have the trouble.
Could you help?
Thanks
Sandip

Hello, Sandip,

Glad to hear that you've gotten this far into your implementation. I don't have any insight into what might be going on with the two issues that you've reported.

Your best bet for getting assistance for these two issues will be to log separate Service Requests via My Oracle Support to get our Support engineers engaged.

Good luck with your project.

Regards,
Steven

Hi,

I am having problem with viewing Item Attribute Controls form (Setup > Items > Attribute Controls) it's giving me an Form error: FRM-40735: WHEN-NEW-FROM-INSTANCE trigger raised unhandled exception ORA-04062.

Has any one got this error. Kindly please help me...

Thanks,
Kalyan

Hi, Kalyan,

Some of our readers might chip in with their tips, but this blog isn't really geared to handle issues like this. Your best bet for getting help with this issue is to log a formal Service Request via Metalink.

Good luck with your implementation.

Regards,
Steven

Hi Steven,

Do you know if anybody has upgraded from 11.5.10.2 with ATG_PF.H.RUP6 to 12.1.1, especially who has migrated to the new SHA password encryption delivered by ATG.RUP6 for fnd_user? Or I should ask if R12.1.1 supports the SHA password encryption delivered by ATG.RUP6. The reason I am asking is that I have finished upgrade in one test env recently, but I could not log in either to the self-service or forms directly. By comparing the fnd_user to a R2.1.1 vision database (11.1.0.7), I think it is because of the SHA encryption. I did have a TAR open, will keep you updated.

Thanks,

T Wu

Hi, Tianhua,

There should be no issues with upgrading from EBS 11i with the SHA password hashing enabled. R12 supports this password hashing capability by default.

Can you email me your SR number? I'd like to have one of our security engineers double up with your Support engineer on this one.

Regards,
Steven

Thanks, Steven.

Here are the TAR numbers: 21642972.6 and 21611082.6 (spawned by 7630476.993). As I have already migrated to the non-reversible hash password for 11.5.10.2. According to note 457166.1, the code supporting the non-reversible hash password is not "turned on" by default, right now I am waiting for response on how to turn on the support for r12.1.1.

For 11.5.10.2 with ATG_PF.H.RUP6, I run the following which migrated the passwords and "turn on" the code at the same time.

FNDCPASS apps/apps_pass 0 Y system/system_pass USERMIGRATE SHA
Regards,

T Wu

Hi Steven,

I applied patch 8764069 (not released yet), and started a new upgrade, now I can log into the apps without any problem.

Thanks for helping me resolve the problem so quickly,

T Wu

Hi, Tianhua,

I've been monitoring this closely on my side, and I'm glad to hear that this patch worked for you.

Thank you *very* much for escalating this issue to us. This will help many customers downstream.

Regards,
Steven

We are in the process of implementing Oracle EBS 12i and settting up the site to site VPN between the office locations via internet, we would like know how do we calculate the bandwidth required for each user.

Sanjeev,

Have you seen this article?

Comparing Bandwidth Requirements between Release 11i and 12 -
http://blogs.oracle.com/stevenChan/2007/06/comparing_bandwidth_requiremen.html

Bandwidth requirements are highly specific to what your end-users will be doing with the E-Business Suite. The general approach is to put a network analyzer on the line and then running a series of EBS transactions that represent your typical user's activities.

Best of luck with your benchmarking efforts.

Regards,
Steven

Hi Steven,

Can we use Maintenance Wizard 2.15 (latest) for upgrading 11.5.10.2 to R12.1.1?
Can we upgrade the existing 10GR1 RAC database (10.2.0.2) to 11GR1 RAC (11.1.0.7) first and then perform the R12.1.1 upgrade?

The idea is to split the long downtime into two different windows (one is for upgrading the database then to upgrade to 12.1.1)

Your response is greatly appreciated

Thanks
Johny

Hi, Johny,

I presume that you can use the Maintenance Wizard for this upgrade. However, my Maintenance Wizard expertise isn't all that deep -- it's a tool owned by Support, not EBS Development. Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our Maintenance Wizard specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Thanks Steven for the quick response. I did open a SR with oracle support and waiting to hear from them. The SR#7771512.993. Any help in getting the good response on the SR is greatly appreciated as we certain deadline on the R12 upgrade.

Thanks

Johny

Hi Steven,

Even I was getting the issue while opening the Item Master Screen but thankfully it got resolved after looking at the resolution part of this blog.

Thanks a lot.

Vishal Majithia