Sunday, November 23, 2014

Weekend Learning: Internet Expenses - Information Center

Are you staying on top of patches and information related to the Oracle EBS Internet Expenses module?  If not, make sure you bookmark the MOS page "Information Center: Oracle Internet Expenses" from note ID 1381228.2 this weekend!!

Saturday, November 22, 2014

Weekend Learning: Learning or Obsolescence?

This is an interesting post tonight, because I think most people actively following my blog would fall into the learning category of individuals, but the post from Matthew Morris on actively learning really does hit home for me as I have been using the blog to push myself to keep learning or discussing something every night so that I stretch myself beyond my comfort zone.  Last month I said how I would have had my younger self blog immediately after getting into this field, but another thing I would have told that younger self would have been: shoot for getting certified, but do not fall into the trap of thinking that is the only way you can learn about or become knowledgeable about Oracle technologies.  I feel like I have made plans over the past 3-5 years about getting certified because that was the only path available to me that I could actually map out where the random piecing together (or blogging) of information has actually given me a lot of knowledge that likely would not have been sussed out from certification.

Do I want to get certified some day?  Sure I do!  Am I okay not completing a certification in exchange for completing other tasks like new presentations, new conferences, or my random learning through the blog?  You bet I am!  I think I have finally come to terms with making my own path here through the Oracle technology jungle, with ANY progress being good because it means that I am not being paralyzed into inaction by "failing" to meet a path I set for myself.  That is why I think Matthew's article hit home so much, and why I think you might enjoy it.

Friday, November 21, 2014

Weekend Learning: Maximum open cursors with JDBC

Were you aware that "overuse" of the OracleDatabaseMetaData.getTables method in JDBC causes an ORA-01000 error to happen?  "ORA-01000: Maximum Open Cursors Exceeded With OracleDatabaseMetaData.getTables In JDBC" in My Oracle Support via document ID 1939417.1 tells the whole (but short) story and which version of the driver has this issue fixed.

Thursday, November 20, 2014

COLLABORATE 15: Accepted!!!

A few months ago I wrote about submitting abstracts for OAUG's COLLABORATE 15 conference and today I received notification for one of my abstracts being accepted!!  Now the clock is ticking for me to flesh out my presentation and start work on the whitepaper, but I have a whole three months to get it done so I will be seeing you in April at the Mandalay Bay!  Get in on the early bird pricing for the conference and the hotels as well!

Wednesday, November 19, 2014

Assets: Journal entry creation generates ERROR in posting

I know a lot of my posts recently are focused on R12.1.3, but not tonight!  Were you aware of this MOS article "FAPOST Create Journal Entries Ends with ERROR occurred in posting routine" found by note ID 1672917.1?  It appears to be a problem with consolidated retirement issues and a one-off fix was generated so you may need to be applying this some day when you encounter the issue on and after!

Tuesday, November 18, 2014

R12.1.3: Workflow error after RPC2

In My Oracle Support document "You Have Encountered An Error In The Worklist Notifications" from note ID 1946243.1 we learn that after applying Recommended Patch Collection 2 (and the prerequisites) an error message including "OANullDBTransactionImpl cannot be cast" is encountered.  What is the problem here?  It seems that this is related to a browser issue, so plan ahead now for when you have to apply RPC2.

Monday, November 17, 2014

Customizing different heap sizes for multiple WebLogic servers

Were you aware that it is possible to give different servers in your WebLogic domain different heap size values?  I did not know that either until I read MOS document "How to Customize Different Heap Sizes for Different Servers in a WebLogic Domain" found via note ID 1924617.1 for how to change the JVM heap to be the same for all servers in the domain and also how to specify different JVM memory values between Admin and the managed servers in the domain.

Sunday, November 16, 2014

Weekend Learning: Complex ATG application design

Being in a Support type role, it probably is not necessary to understand ATG application design but I can tell you that after reading this article from the Oracle Customer Experience blog there are some things which make a lot more sense.  If you had ever wondered about how different pieces are designed to fit together or want to get a few pointers to help shape the integration between your own parts of the application then give the article a once over.

Saturday, November 15, 2014

Weekend Learning: Inside Cary Millsap's learning

Earlier this year, Cary posted a really great article about how he learned so much about "Oracle" and I recommend that you read it (and take it to heart) if you are just getting started with Oracle technology.  While I am of course nowhere near where Cary is, I think it is very interesting how his path mirrors how my path went because of how much he was in the field and in Support that is my entire life every day.  What is pretty different is how he saw the application causing the majority of the problems while a lot of what I see is the database having problems or not understanding the interaction between the two.  Also do yourself a favor and follow each and every blogger Cary listed, all of them you can find on my blog roll, because it is important to practice continuous learning!

I learned a new book to read from reading his article, with a few other takeaways too.  What did you take away from this?

Friday, November 14, 2014

Weekend Learning: JDBC driver cursor leak on

Do you know how sometimes you can stumble across a solution for a problem, when you are not even looking for it?  Well let me introduce you to My Oracle Support document "Cursor Leak After Upgrading to JDBC Driver" via note ID 1939530.1 and ask if you have been having problem with "middleware" or "web services" after upgrading to  We are not on YET, but on we have had some issues with memory leaks so this type of issue could be the next condition we encounter so now I am aware of it and can potentially start looking for it when we start upgrading (and testing).  Luckily we have not had the ORA-01000 errors indicated in this article, but forewarned is forearmed.

Thursday, November 13, 2014

Hinting the RESULT_CACHE in 12c

Tonight, we learn from a recent article by Christian Antognini about having a new undocumented parameter for the RESULT_CACHE hint!  While the obvious lessons (the RESULT_CACHE hint, the undocumented parameter) are in front of us, what is less obvious is examining in our own environments the table he investigates: v$result_cache_objects.  Will it solve a problem for you tomorrow?  Not very likely, but we need to keep adding to our toolboxes no?  A few years ago I would not be using v$sqlarea, v$session_longops, or any number of specific v$ objects if it was not for encountering them in one off instances but then revisiting them and learning from what they did or did not tell me.

Wednesday, November 12, 2014

Hyperion: Level 0 Members of alternate hierarchy cannot be selected

Were you aware that on Hyperion Planning the Level 0 Members of the alternate hierarchy cannot be accessed with SmartView via Member Selection?  Visit MOS note "Unable To Access Level 0 Members Of Alternate Hierarchy Through Member Selection Using Smart View" via document ID 1625343.1 to find out why this is expected, and what the resolution will be for it.

Tuesday, November 11, 2014

Magical Mystery Event Tour: Part 3

Continuing the series of posts on mysterious wait events comes another today from 12c which appeared and then disappeared all by itself.  Our friend tonight is "acknowledge over PGA limit" and the wait event does not show up in the new version of the Description of Wait Events for 12c.  Sure, the wait event SOUNDS straightforward but if it was AND common OR easily replication why does it not get an entry in the wait event listing?

When I find out more about this wait event, I will post a new article!

Monday, November 10, 2014

Learn more about JVMs by tuning with JVM Diagnostics

I think we have all been there.  Garbage Collection (GC) for Java Virtual Machines are chewing up your server processing power and once they are done with the server they need to be rebooted.  Instead of a perpetual "throw memory at it" type of solution, take a gander at this post from Oracle.  Were you aware that the JVMD (Java Virtual Machine Diagnostics) tool was part of Oracle Enterprise Manager which is licensed with several other Management Packs?  Is this already in your environment, licensed, and just sitting there gathering dust?  What if you cannot use the tool?  Read the post anyways, and learn about things like "Eden space" or different algorithms to use for your GC!

Sunday, November 9, 2014

Weekend Learning: 32/64-bit OS, Internet Explorer and Excel checks

Capping our weekend learning comes some very simple version check information for the OS, Internet Explorer and Excel.  Visit My Oracle Support document "How To Check To See If IE Or Excel Is Running In 32-bit Or 64-bit Mode?" via article ID 1321637.1 to see how to check this information.  Will it be something you use tomorrow?  Probably not, but would you rather know how to check this when the time comes?  I think so!