Few reader question..

1. What is the difference and theory behind Oracle terminal releases and terminal patchsets ?
2. What are Critical patch updates ?
3. What is the terminal release after 11.5.10 CU2? or Do you have 11.5.10 CU3/CU4?

Terminal release means that the version specified is the last point release of that product. For example, the “terminal release 11.5.10” for the 11i E-Business Suite would mean that there will not be any further releases of 11i after 11.5.10. Specifically, that would mean there will not be a release 11.5.11 for 11i.

The terminal patchsets means that would the last patchset provide on that particular release.

This is very simple as this example:
In 10g Release 2 the last patchset would be 10.2.0.4, upon further there won't be any more patchset will be released under this version.
In 9.2 release the last patchset is 9.2.0.8, upon further there won't be any more patchset will be released under this version.

In other word :Terminal meaning no more patchsets are going to be delivered, so you will be forced to either apply one-offs or upgrade.

Critical patch updates

Oracle provides critical patch updates (CPUs) to its customers to fix known bugs that are critical in nature also includes security fixes.

Critical Patch Updates are the primary means of releasing security fixes for Oracle products:(Adpoted-otn )

• A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes nonsecurity fixes that are required (because of interdependencies) by those security patches.
• Due to the threat posed by a successful attack, Oracle struongly recommends that fixes are applied as soon as possible.
• CPUs are released on the Tuesday closest to the 15th day of January, April, July and October each year

You can find information at Oracle Technology Network .

Q .What is the terminal release after 11.5.10 CU2? or do you have 11.5.10 CU3/CU4?

It's just a matter of terminology.There was the original 11.5.10 install (or upgrade maintenance pack).Then came 11.5.10.1CU (3240000), 11.5.10.2CU (upg from 1CU 3460000) and 11.5.10.2CU (upg from pre-11.5.10 3480000).

Since there was change in stretegy that why here are the details for ATG Rollup patchsets

• CU3 = ATGRUP3 (4334965)
• CU4 = ATGRUP4 (4676589)
• CU5 = ATGRUP5 (5473858)
• CU6 = ATGRUP6 (5903765) :This is the latest

Oracle EBS 11i Technology support Matrix

Metalink Notes

• 738923.1 :Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Note (January 2009
• 315713.1 :Prior E-Business Suite Security Alerts
• 329689.1 :E-Business Suite (Oracle Applications) 11.5.1 through 11.5.6 Desupport Notice
• 363827.1 :Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10

Refrence Link :

• ATG Blog for support ,desuuport and certify infohttp://blogs.oracle.com/schan
• Oracle Lifetime Support Policy

For new Implementation, certain things never focused by implementation team i.e user desktop configuration which might be a big reason that is reported by end user once Business switch to new system. This is specially true, when your client belong to SME's (Small and medium enterprise).

Lets me summarize few issue with File ->Export

1. User Unable to Export Data to TSV File
2. Export functionality does not prompt for saving the file.
3. Data export from Oracle form is missing some rows in the output file , specially from AP Invoice workbench , Gl account enquiry screen and AR Transaction workbench

Some of them are purely desktop issue, still you need to do such steps if such things being reported by remote users.

Do verify the following:

1. You should have the following Viewer Option entry: File Format Mime Type Description Allow Native Client Encoding
   -------------- -------------------------------- -------------------- -----------------------
   Excel application/vnd.ms-excel Microsoft Excel Checked
2. Check out the table FND_MIME_TYPES_TL entry. A row contains an entry for FILE_FORMAT_CODE = "EXCEL" and MIME_TYPE ="application/vnd.ms-excel"

Next you need to verify these details:

1. What is the windows OS on your computer (XP, W2000, etc...)? Which service pack?
   i.e.: Microsoft Windows XP - Profesionnel - Version 2002 - Service Pack 2 check the comptability matrix.
2. Version of excel on user computer.
3. Version of Internet Explorer in user computer.
4. Deactivate any pop-up blockers in windows XP or in Internet explorer
5. You need to do a try to compare the two computers? (The computer where you have the issue and the computer where the export is working)
6. Try the following as part of quick check:
   In the Tools -> Internet options, set the following:
   • Open Internet Explorer and choose Tools-->Internet Options
     • Click on the Security Tab
     • Click the Custom Level button
     • Scroll down to the "Downloads" options
     • Enable the option "Automatic prompting for file downloads"
     • Enable the option "File Download"

Once you done, close browser, open browser than try to export again.

If still getting an error , you need to verify these details too.

• In Internet Explorer select the Tools menu - Internet Options - Security - Custom Level
• Adjust all the settings for ActiveX Controls and Downloads to be either 'enable' for the following zones :
  • - Internet
  • - Local Intranet
  • - Trusted Zones
• Try to add the site of instance to Trusted Zone and adjusted Security level to Low protection.
• Restart the browser and now test.

99% chances that you can able to resolve 1 and 2 , else not, ask Oracle with SR and wait for a day.

For 3,you need to check with Oracle, there might be chances the version of form is bit lower.

Similar Post

• ‘File ->Export’ Function is troubling
• Setting default to Excel for Exported file from “File ->Export “
• File -> Export : Enabling or disabling

Well its been nearly more than a month since I last posted something here. I must have been busy because I dont know the reason why! Things simply went uncontrolled since last week of Dec '08. Well actually I have been a super busy, working on a client project in the office that was due to go live in first week of Jan'09 and wanted to make sure it went ok.

I don't know about you but I'm exhausted.So, it is time to relax.. festive season locally,a long weekend for Lunar New year therefore a perfect occasion to do some housekeeping for blog .

Thanks for everyone...

Moreover, Normally I pay so little attention to this blog since last one month, that I didn’t notice my page view count rolling over 1 million. It must have done somtime at least begining of this year. Therefore, I would like to thanks To all readers,visitors.

In the 19 months since I start counting, I think that’s a fantastic achievement (if I say so myself!)

But, I’m going to be slow blogger till end of March,09 because of some added responsiblity with new role , still keep you posted thats will help to support your daily life with Oracle.

I know I've been very behind in answering comments lately, but I hope to get back to it soon, so please be patient if you're waiting.If there's anything you'd like me to cover which I haven't already, just get in touch via comment, I will try to reach as much I can.

Wishing a very happy Chines new Year to everyone.

2009 will be the Year of the Ox, which symbolises prosperity through fortitude and hard work. In other words, persevere and work hard and steadily. Considering the world ecenomical fact, though it’s not the year to be outrageous or impulsive, but hard work will be rewarded, what you say..lets hope..

Gong Xi Fai Cai!

Thats all for now…And thank you all again.

• 100,000th Visitor
• OracleApps Epicenter :1,00,000+ and Counting