Monday, September 15, 2014

Blog roll update: Martin Bach

Are you always looking for more information on Exadata or 12c?  How about learning from an Oracle instructor on these subjects?  If you answered yes to these, then you NEED to visit Martin Bach's blog!  The best part of this is how much Martin references and links to documentation from a variety of different people on these subjects so you can read his blog and get involved with others in the community to learn even more as time goes on.

Bonus:  I enjoyed the post here about wait events that are being introduced with new versions of the database, and makes me think about creating some documentation for myself to keep track of the "new" ones I encounter in the wild and those I am looking for!

Sunday, September 14, 2014

500 posts!

It is hard to believe that I have not missed a night (or day) of posting on the blog since January 20th of this year, and even harder to believe that I have finally hit the 500 post milestone tonight!  While it has taken over two years to get to this point, I am thinking that I will hit 1000 posts by the end of year 4 because I have so many more places to get relevant information for somebody in my type of position out there supporting EBS or Hyperion products.

Thanks for sharing the ride of the last 500 posts!  Feel free to share any favorite posts in the comments or give me advice for the next 500!

Saturday, September 13, 2014

Weekend Learning: 10 book writing tips

One day I may compile a lot of the things you read in this blog, and maybe other places in the coming future, into an actual published book.  Are you an aspiring author too?  If so, this post from Michael Abbey with Pythian has some very good tips that can probably be applied to more than just technical book writing!

Friday, September 12, 2014

R12.1: Incorrect GL and subledgers due to corruption

Are you already on R12.1?  Did you know there is a known bug where several reports are not returning subledger journals which requires a patch and datafix?  Visit the MOS article "Corruption in GL Journal Headers Causing Incorrect Reporting in GL and Subledgers" from note ID 1559470.1 to get up to speed on this issue, and make sure that you have applied the required patch!

Thursday, September 11, 2014

11gR2: ORA-600 corruption in rolling back RAC transaction

If you are on several different versions of Oracle's 11gR2 database, you may be susceptible to a known ORA-600 bug detailed in the MOS note "ALERT: Bug 13605839 ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds] ORA-600 [kdBlkCheckError]. Corruption in Rollback with Clusterwide Global Transactions in RAC" which is found in document ID 1527740.1 but the linked document 13605839.8 has all of the bug details including which versions are affected and which versions have this fixed.

Wednesday, September 10, 2014

Troubleshooting Automatic Remittances

Related to an old post of mine on batches where I ran into problems due to automatic batch numbering, I found another My Oracle Support article that needs bookmarking in "Automatic Remittances: Troubleshooting, Errors, Known Issues and Patches" via document ID 1369785.1.  This article will give you a lot more than just troubleshooting on Automatic Remittances for versions of the EBS application including 11.5.10 and after including patches, errors and other known issues.  Why favorite this?  Well it has been updated within the last month so it is absolutely relevant as new information keeps being released by Oracle and it is possible new patches are deployed and you can find out about it here first.

EDIT 9/11:  I realized this morning that I forgot to link to my previous post!  Oops!  Fixed now though.  :}

Tuesday, September 9, 2014

12c: Release 1 support and alerts

Do you know where to find Oracle support documentation about the newest Release for 12c?  Well look no further than MOS document "ALERT: Oracle 12c Release 1 (12.1) Support Status and Alerts" from note ID 1565065.1 for all the patches, certifications, support policy and more on the 12.1.0.1 and 12.1.0.2 releases!  Do not forget to favorite this in MOS!

Monday, September 8, 2014

R12: Superseded RPCs

How often do you apply product Recommended Patch Collections (RPCs)?  Are you in the middle of applying some RPCs?  Did you know that some RPCs have been superseded within the last few weeks?

***SUPERSEDED*** EBS: R12.1: Receivables Recommended Patch Collection (RPC), Sep 2013 - Note ID 1579521.1
EBS: R12.1: Receivables Recommended Patch Collection (RPC), Aug 2014 - Note ID 1912247.1

***SUPERSEDED*** EBS: R12.1: Advanced Collections (IEX) Recommended Patch Collection - SEP 2013 - Note ID 1618571.1
EBS: R12.1: Advanced Collections (IEX) Recommended Patch Collection - Aug 2014 - Note ID 1912256.1

***SUPERSEDED*** General Ledger Recommended Patch Collection (GL RPC) September 2013 - Note ID 1584923.1
General Ledger Recommended Patch Collection (GL RPC) August 2014 - Note ID 1919532.1

With all of this information that can be updated, do you wish that everything was bundled in one spot?  Ask and ye shall receive!

EBS: R12.1 Oracle Financials Recommended Patch Collection (RPC), Aug 2014 - Note ID 954704.1

Sunday, September 7, 2014

Weekend Learning: JDBC/JVM connection troubleshooting

Have you made sure you have every little bit of performance from your system?  Well here is another way to squeeze out a little more performance from your system by visiting My Oracle Support note "Please update JDBC settings following MOS Basic troubleshooting of JVM consuming CPU or too many JDBC connections in EBS Apps 11i" via document ID 370583.1 and even if you are on R12 there are some nuggets of information that may interest you including a linked document towards the end of the article which is not exclusive for 11i.

Saturday, September 6, 2014

Weekend Learning: EBS Workflow - Information Center

In my experience one of the parts of the Oracle E-Business Suite that changes the least is the Oracle Workflow product, but also when it does change sometimes it is very important that you have stayed on top of the documentation so when you hit go-live day you do not have an unexpected speed bump.  What is a good way to do that?  Go into My Oracle Support and bookmark the article "Information Center: E-Business Suite Oracle Workflow (WF)" located by note ID 1320509.2 so you can monitor the Workflow product for new patches or configurations that might be needed to avoid potential issues down the road.

Friday, September 5, 2014

Blog roll update: Weidong Zhou

Another great blog that you should be reading if you are interested in Exadata is Weidong Zhou's blog that is being added to my blog roll tonight.  I had learned of Weidong via his Enkitec co-worker Carlos Sierra from a post shared on LinkedIn last year, and it looks like he has not stopped sharing great information with all of us as there are some really awesome tidbits which can fuel your fire a bit!  Go take a gander, and share what you found new or interesting in the comments here!

Thursday, September 4, 2014

Office 365: EBS and Hyperion

Is your business thinking about migrating to the Office 365 solution?  Do you know what that means for either the EBS or Hyperion applications?  I found out the answer to that today by reading these My Oracle Support documents:

Is The Workflow Notification Mailer Compatible With Microsoft Office 365 Cloud Base Mailer Servers - Note ID 1914579.1
Oracle Hyperion Smart View Support for Office 365 - Note ID 1581197.1

Wednesday, September 3, 2014

RMOUG Training Days: Abstracts Open!

Are you returning to the Rocky Mountain Oracle Users Group (RMOUG) Training Days this year?  Did you know that the abstract submissions are now open?  I have not had the chance to attend this conference yet, but I am looking forward to trying to get accepted to present and I will let you know how I do!

Tuesday, September 2, 2014

Limiting your attachment size in EBS

Did you know there is a built-in profile option to limit how much space users can upload in a single attachment for your Oracle EBS application?  After reading the MOS article "How to Limit The Attachment File Size?" via note ID 604458.1 you will know about the profile option as well and can start thinking of ways to use it to limit potential abuse.

Monday, September 1, 2014

COLLABORATE 15: Call for Presentations open

Are you a member of the OAUG?  Have you ever attended the COLLABORATE conference and wanted to get back there?  Do you have something to share with the rest of the OAUG?  If you answered yes to all of these, then you are in luck!  The call for presentations is now open until October 10th for members of the OAUG and getting accepted will get you a free registration!

I'm looking forward to submitting my abstracts again, but I'm also looking forward to hearing from you about your experience putting an abstract together and even more to hear you getting selected for the conference so please let me know in the comments!