Thursday, November 27, 2014

Weekend Learning: OEM Patching 101

As some of us recover from turkey induced comas, let me share with you a post from Courtney Llamas from the Oracle OEM blog about patching.  Maybe being in a support type role, you may not have to support OEM, but there is a chance you have some level of access in the tool so you may want to know more about patching for it.  Not using OEM?  You might find this post useful with the breakdown she gives, and think about how it can apply to the other systems you support and if you could write such a concise and accurate patch strategy at your shop.

Wednesday, November 26, 2014

R12.1.3 Assets: Encountering APP-OF-48395 when backdating retirement

Find out how to resolve the problem MOS article "Unable to Issue a Backdated Retirement due to: APP-OF-48395" in note ID 1940140.1 details when the business is trying to retire an asset and they encounter these error messages asking them to change the retirement date.

Tuesday, November 25, 2014

R12 Payables: Open Interface output not displaying rejected invoices

Add one more to your suite of test cases!  MOS document "R12 Payables Open Interface Output Does Not Display Invoices That Are Rejected Due To Being Future-Dated And Whose GL Date Is Null" article ID 1945445.1 has the details including the patches on both R12.1 and R12.2 codelines, why ORA-01400 errors are showing up when debug mode is on, and what state items in AP_INVOICES_INTERFACE have to be in for this issue to show up.

Monday, November 24, 2014

R12.2.3: AME works for a single OU

Tonight is a new bug on EBS R12.2.3 in Internet Expenses where AME rules work for just a single OU (Operating Unit).  The My Oracle Support article "AME Rule Is Working For Only One Operating Unit" in document ID 1947632.1 has the resolution and surprisingly it is NOT a patch this time!  Find out the easy fix for this and how to keep it on your checklist for future upgrades!

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.