Posted on January 25th, 2009 by Sanjit Anand | Print This Post
| Email This Post
Few reader question..
What is the difference and theory behind Oracle terminal releases and terminal patchsets ?
What are Critical patch updates ?
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 184.108.40.206, 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 220.127.116.11CU (3240000), 18.104.22.168CU (upg from 1CU 3460000) and 22.214.171.124CU (upg from pre-11.5.10 3480000).
Since there was change in stretegy that why here are the details for ATG Rollup patchsets
Oracle EBS 11i Technology support Matrix
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 :
Posted in AOL | 1 Comment »
Posted on January 23rd, 2009 by Sanjit Anand | Print This Post
| Email This Post
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
- User Unable to Export Data to TSV File
- Export functionality does not prompt for saving the file.
- 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:
- 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
- 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:
- 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.
Version of excel on user computer.
Version of Internet Explorer in user computer.
Deactivate any pop-up blockers in windows XP or in Internet explorer
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)
Try the following as part of quick check:
In the Tools -> Internet options, set the following:
Once you done, close browser, open browser than try to export again.
If still getting an error , you need to verify these details too.
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.
Posted in AOL | 1 Comment »
Posted on January 20th, 2009 by Sanjit Anand | Print This Post
| Email This Post
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.
Posted in Misc | 4 Comments »
Posted on January 18th, 2009 by Sanjit Anand | Print This Post
| Email This Post
Withholding tax is an amount withheld by the party making a payment to another (payee) and paid to the taxation authorities, depending on the nature of the product or service being paid for. Local WHT is often used to counteract tax evasion and tax avoidance whereas overseas WHT is often used to collect tax from payers within the boundries rather than payees who may be outside the boundries.
WHT tax is often applied to
- Dividends and Interest payments: Tax may be deducted at source from dividend payments, in addition to Corporation tax.
In India, tax is not withheld at source from dividends since tax is paid by company on the profits (excluding dividends) and hence dividend income is tax free in hands of payee.
UK has imposed a 20% withholding tax on distributions from Real Estate Investment
- Payroll payments to employees: In most countries, employers are required to deduct tax from salary.
- Contract and consultancy work payments: Payments to contractors, consultancy firms, realty business etc are subjected to tax deducted at source Withholding Tax is applied as a part of local regulatory requirement, to reduce the final payment made to the supplier. WHT is then paid to the local tax authority as per the local regulations.
Sometimes WHT is applied to cross country payment, based on country-to-country relations. At other times, it is applied on Invoices from all Foreign Suppliers, to boost local business or to make them subjected to local VAT, which otherwise would be applicable for local suppliers. In few
countries, WHT is applied also on certain types of local vendors as well (eg. consultants).
Posted in Oracle Payable | No Comments »
Posted on January 17th, 2009 by Sanjit Anand | Print This Post
| Email This Post
This focus on the Product (product innovation…product profitability…product decisions…product lifecycle…product network)
"Product Lifecycle Management (PLM) is the business activity of managing a company's products all the way across the lifecycle in the most effective way.” (source -*2PLM - Product Lifecycle Management Magazine)
In other word:
- PLM enables companies to accelerate product innovation and maximize product profitability
- …through the management of the information, processes and decisions about their products…
- …throughout the product lifecycle and across the global product network
Which kind of industry needs PLM
- Industrial manufacturing industry to track and manage engineering change orders .
- High technology
- Life sciences and pharma industry
- Food & beverage
Posted in Beyond Apps, Centrestage | No Comments »
Posted on January 11th, 2009 by Sanjit Anand | Print This Post
| Email This Post
News and Views for Oracle related, all in one place.
- Translation and UX Trends in the Enterprise: Your Reason to Attend Oracle Apps UX Events
Are you an Oracle partner who wants to know more about what’s hot in user experience (UX)? Are you an Oracle applications customer with a workforce that needs to translate material quickly to be productive? Are those workers on the go? Need to keep their hands free? Well, here’s just reason why you need to […]
- Cloning databases
My friend Kyle wrote a blog piece a while back http://www.kylehailey.com/what-delphix-does-in-1-minute-22-seconds/ Now, not to criticise Delphix (in fact,the opposite – its a very very cool product, and you should read some of Kyle’s great blog content on it), but if you have not got it, or can’t get then as long as you have some […]
- UKOUG Tech13
I attended the UKOUG Tech13 conference this week, along with over 1,000 other Oracle Technical Professionals (and some less-professional too), to learn what I could about how everyone else is doing stuff with Oracle, and how it works. And to share some experiences. I wasn’t disappointed. As with everything these there was a lot of […]
- number of set bits
declare n number := ….; tmp number; begin tmp := n – ( bitand ((n / 2) ,3681400539)) – (bitand ((n / 4) ,1227133513)); tmp := mod ( bitand ((tmp + (tmp / 8)) , 3340530119) , 63 ); dbms_output.put_line(tmp); end; Google for "hakmem" to see how it
- Spring HikariCP with Pivotal GemFireXD
Previously I blogged about using the HikariCP with Pivotal GemFireXD as per the post below.http://theblasfrompas.blogspot.com.au/2013/12/hikaricp-connection-pool-with-pivotal.htmlIn this example I show how you would use this Connection Pool with Spring.1. Ensure your using version 1.2.1 of HikariCP as it provides the setDataSourceProperties() setter to HikariConfig easier configuration though Spring. Example below is for Maven. <dependencies> <dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> <version>1.2.1</version> […]…
- Disable JDBC data type wrapping in WLS
I’ve now seen this problem several times in customer environments. During startup of a CMSDK Node you see a ClassCastExceptions related to weblogic.jdbc.wrapper.If something like this shows up in your log file: …oracle.ifs.common.IfsException: IFS-45206: Unable to get credentialoracle.ifs.common.IfsException: IFS-10184: Unable get tokenoracle.ifs.common.IfsException: IFS-10191: Unable to make token credential persistentjava.lang.ClassCastException: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB at oracle.ifs.server.S_LibrarySession.getTokenCredentialBlob(S_LibrarySession.java:23888)… you have probably […]…
- Partner eSeminars: Oracle Database 12c
Learn about Oracle Database 12c in this exclusive series of live webcasts from Oracle Database Product Management. Oracle Database 12c is Oracle’s new release of the Oracle Database with features for consolidation and cloud deployments. In these EMEA focused Internet Seminars, participants will learn about Oracle Multitenant, Automatic Data and the HA new features of Oracle Database 12c. […]
- Oracle R Distribution 3.0.1 now available for Windows 64-bit
We are excited to introduce support for Oracle R Distribution 3.0.1 on Windows 64-bit versions. Previous releases are available on Solaris x86, Solaris SPARC, AIX and Linux 64-bit platforms. Oracle R Distribution (ORD) continues to support these platforms and now expands support to Windows 64-bit platforms. ORD is free distribution of the open source R […]
- Managing Oracle Communications Applications with Enterprise Manager Cloud Control
I’m very excited to intoduce a new InfoDev blogger. Meet Chet Liew, Principal Technical Writer for Oracle Communications based in Bend, Oregon. His previous roles at Oracle include time as a QA Engineer and Product Manager working with BRM and OSM. Currently, he writes documentation for our Service Delivery Platform and Application Management products while also assisting in […]
- eSTEP TechCast – December 2013 Material available
Dear Partners,We would like to extend our sincere thanks to those of you who attended our TechCast on "Oracle Server Virtualisation Technologies". The materials (presentation, replay) from the TechCast are now available for all of you via our eSTEP portal. You will need to provide your email address the pin below to access the downloads. Link […]
Posted in Misc | No Comments »
Posted on January 9th, 2009 by Sanjit Anand | Print This Post
| Email This Post
Oracle iSupplier Portal enables secure, self-service business transactions between companies and their suppliers provides suppliers with the ability to directly manage business transactions and access secure information
Key business flows Include:
- Purchase Order Acknowledgement
- Create Advance Shipment Notice and Advanced Shipment Billing Notice
- Create Invoice
Core Functionality of this application are :
1) PO Collaboration
- View and Acknowledge PO
- Submit PO Change Requests and Split Shipments
- Manage Deliverables
- View agreements and PO revision history
- Issue Work Confirmations
2) Shipment Notices
- Inbound logistics
- Plan the optimum route
- You can view Delivery Schedules, receipt, returns and overdue receipts
- View item inventory Information like on-hand stock, item locations, lot and serials
- Vendor Managed inventory – supplier manage their inventory at customer’s location
- Consigned inventory – View on hand stock on consigned items as well as associated p2p transactions.
4) Supplier Management
- Vendor registration
- Supplier profile Management e.g. address, business classification, bank details, tax details, item, category etc.
5) Buyer’s Internal view
- Provide all information which supplier view
- Search information across all the suppliers
- Search and view supplier items
6) For Invoice and Payments
- This provides view the history and status of all invoices
- This Provide view the history of all payments done
Check out at link for Oracle Datasheet .
Posted in Oracle Purchasing | No Comments »
Posted on January 4th, 2009 by Sanjit Anand | Print This Post
| Email This Post
Oracle iProcurement enables internal corporate requesters to independently order items from both local (internal) and remote (external) catalogs. It is the starting point for the ordering process and provides powerful self-service requisitioning capability with an intuitive, Web shopping interface.
It is a key component of Oracle Advanced Procurement, the integrated suite that dramatically cuts all supply management costs.
In an efficient and automated manner, Oracle iProcurement:
- Constitutes a key component of the procure-to-pay business flow.
- Helps an enterprise process and manage requisitions.
- Helps an enterprise process and manage receipt of the requested goods or services.
As a part of Oracle Advanced Procurement, iProcurement
- Delivers measurable savings
- Reduced maverick spend
- Greatly simplified process for purchasing goods and services
- Requesters can quickly purchase the items they need with an easy to use interface that provides all the information they require to make purchases while directing them to preferred vendors and pricing
- For purchasing managers iProcurement provides powerful tools for managing catalogs in real time, stores and content zones
If you are planning to implement this application, here are the Core features & functionality of this application, boardly divided under these heads.
- This Provides flexible solution to catalog and content management
- Punchout / transparent Punchout feature will establish direct link to supplier’s web store to access their catalogs
- This stores and provide a way for requesters to shop among a variety of catalog types and sources.
- This provides a category and descriptor Management (Such as supplier and Price)
- This also control on requester’s access based on categories, catalog sources and operating unit
- Configure stores to include any combination of local catalogs, punchout catalogs, informational catalogs, and transparent punchout catalogs.
- Administrators can control which catalogs and stores are available to different classes of requesters.
- Powerful search Capability
- Shopping list- Create own favorite shopping list of frequently ordered items. Create public list that can be access by all requestor
- Saved shopping carts- Create n number of shopping carts in progress.
- Non Catalog request – Request for items and services which are not in catalog
- Automatic document creation- Supplier PO contracts and quotation generate PO and releases accordingly without buyer’s intervention.
- Center Led Procurement- Create global contract agreement and use it for all organization.
- Provide options to stock delivery option like multiple destination types, delivered at one time addresses location.
- This also integrated with Enterprise asset management
- You can manage multiple account distribution and account generation workflow rules.
- This is integrated with Oracle projects and Oracle Grants enables requesters to optionally reference projects, tasks, and award information about shopping cart order lines.
- Encumbrance support lets user view funds online before submitting requisition.
- Notes and attachments
- This Provide additional information to approvers, buyers, suppliers, and receivers by attaching text, URLs, and other file types to the requisition.
- Approval and workflow setup determines the approver list for each requisition. During checkout, the requester can add approvers and change the first approver in the approver list. You can also customize it to meet your business needs.
From their desktop, a requesters can receive internally and externally sourced items or the entire requisition.
View supplier advanced shipment notices (ASNs) as well as internal shipments
Workflow-driven receipt confirmation mechanism that proactively sends a notification to requesters to confirm receipt on the due date.
5.Requisition Tracking & Management
- This enables you to track the status of all the requisitions and also Procure to Pay life cycle
- This will keep real time notification keeps you up-to-date
If your compnay or Procurement dept looking option to simplify and automate company’s flow of ordering for Services,Refill for inventory,CIP , Opex, Capex Purchasing then this application will drastically reduce employee and bookkeeper time spent in procurement process.
Posted in Oracle Footprint, Oracle Purchasing | 1 Comment »