Apps DBA
After an upgrade to E-Business suite R12.1.3 on one of our test servers we encountered an issue with the Invoice Workbbok form (APXINWKB.fmb).
When trying to enter an invoice line it would error when saving or performing other tasks which involved validating the data. (e.g. Calculate Tax)
The error encountered was:
ERROR
———————–
Invalid argument to LINE_SUM_FOLDER_ITEMS_ITEM.ASSET_BOOK: EVENT=’WHEN-VALIDATE-ITEM’
I recently came across two useful articles on Steven Chan’s Oracle E-Business Suite Technology Blog detailing the various levels of support that Oracle provide for all of their products, both on the Applications and Technology sides of the business. The articles contain links to PDFs on the main Oracle website that show the actual End Dates for the various levels of coverage for all of Oracle’s products.
Oracle has three stages of support:
Premier Support is obviously the best level of support and is offered immediately after a product release. The benefits are:
With Extended Support all that you lose is the “Certification with new third-party products”. This doesn’t sounds like too much of a problem, but you would need to be careful before rolling out new versions of your browser or integrated products, such as Microsoft Office.
Finally, Sustaining Support is the lowest level of support, but you still have the following benefits indefinitely:
I would like to draw your attention to a couple of key dates in the near future:
In just over 2 months time Oracle Database 9.2 will drop from Extended to Sustaining Support. This will impact any E-Business Suite customers who are using EBS 11i on a 9i database; I would highly recommend that you upgrade to Oracle 10gR2 or 11gR2 as soon as possible.
Also at this time, Oracle Database 10gR2 will drop from Premier to Extended support. This may be less of an issue for our customers, as you still have another three years before Sustaining support kicks in. However, some organisations may prefer to have all their Applications and Technology on Premier support; if so, you need to start planning your upgrade to 11g.
Near the end of this year Oracle E-Business Suite 11.5.10 will drop from Premier to Extended support. As with DB 10gR2, you will have another three years before support drops to Sustaining, but if you aren’t already planning an upgrade to R12, I would consider starting the exercise in the next few months.
As we were running out of disk space on one of our servers I was reviewing the disk usage and found a directory $ORACLE_HOME/.patch_storage. This was over 2G.
After some digging around I found a method of cleaning up unused files in the area:
cd $ORACLE_HOME/OPatch
opatch util cleanup
Results from our install are shown in this screenshot:
So over 1G of disk space saved!
This facility should be available in the latest OPatch releases for 10.2.0.x and 11.1.0.x (and above…)