Monday, May 23, 2016

JDBC connection throws ORA-01489 error when querying

Even though article "ORA-01489 When Running Query" in My Oracle Support document 2141406.1 is about JDBC, the underlying issue is likely one you could see outside of a JDBC environment so take a moment to read up on this error and find out why it is happening!

Sunday, May 22, 2016

Weekend Learning: Configuring the Workflow Mailer for a Proxy Server

On Oracle EBS R12.1.3 you can follow the MOS document "How To Configure the Mailer to Connect To a Proxy Server" via article ID 2139133.1 and even if you do not plan on changing your configuration you may want to see what is required.  This article even has reference to the additional step required if you have moved on to R12.2 and want to do this!

Saturday, May 21, 2016

Weekend Learning: Transparent Data Encryption and Disaster Recovery

Want to learn more about Transparent Data Encryption?  How about what you need to know if you are using it in a Disaster Recovery situation?  Look no further than Lukasz Feldman's post on LinkedIn!

Thursday, May 19, 2016

Corruption in TEMP tablespace on 11.2.0.4 RAC system

There is a bug where if parallelism is turned on you could encounter the scenario described in "ORA-01578 in temp tablespace on RAC" from My Oracle Support document ID 2140124.1 across the nodes so really your only options are to turn parallelism off entirely!

Wednesday, May 18, 2016

11i Assets: Rolling back a journal entry fails due to batch status

If you are still on 11.5.9 or even 11.5.10.2 you will want to read the MOS note "Rollback Journal Entries Fails with Journal Entry Status Message" from article ID 452583.1 to learn why you cannot roll the journal entry back and the simple action you can take to get around this error message.

Tuesday, May 17, 2016

12c: KGLH0 process is causing Shared Pool ORA-04031 errors and latch contention

Are you looking to upgrade your Oracle database to 12.1.0.2 soon?  You might want to read "Bug 20370037 - Shared Pool from KGLH0 constantly growing causing ORA-04031 and Latch contention" from MOS note 2119923.1 because there seems to be several well known bugs with the KGLH0 process and this document has steps for different ways to mitigate this.  What does that mean?  If there are a lot of ways to encounter this in the system, then you need to prepare for encountering it so deploy the upgrade in QA and stress test to see if you run into this!!

Monday, May 16, 2016

R12.1.3 Payables: Invoice Validation program has performance issue

For the article "R12: AP: Invoice Validation program (APPRVL): Performance Issue - Insufficient Parameters" on My Oracle Support via document ID 2138625.1 you need to read up on the attached bug as well since it appears this dynamic query is actually being designed to run for an excessive amount of time if you do not provide an invoice date range.  That means that just entering an Operating Unit parameter does not actually limit the query as much as you would think, and Oracle Development has closed the bug as "not a bug" even though it really sounds like a bug!

Friday, May 13, 2016

Hyperion Essbase: Setup for automatically disconnecting users

Sometimes I post about things for your toolbox, and other times I post about investigating your own setup; and sometimes I post something from both columns like tonight!  Do you know how long users can be connected to your Essbase server?  If you read the MOS article "Specify when Users are Automatically Disconnected from an Essbase Server" from note 1054448.1 you will AND you will learn how to tell when running with Shared Services too!

Thursday, May 12, 2016

R12.2 Procurement: How to replace seeded FAQ

Check out MOS document ID 2132795.1 for "How can we replace seeded FAQs in iProcurement home page in Purchasing News Section with Business specific FAQs." for the official Oracle documentation on how to customize the PORFAQSS.htm file to fit your needs!

Wednesday, May 11, 2016

Linux OS: Logwatch crontab is sending several e-mails per day instead of one

If you are on a Linux OS then make sure that you check out the article "Crontab Called Logwatch Sends More Email Then Expected" on My Oracle Support via note ID 2114498.1 because there is a very simple reason this is happening and can be easily rectified!

Tuesday, May 10, 2016

Windows Vista: Support ends in April 2017

You should be aware that product lifecycles which Oracle does not directly control CAN impact support for Oracle products.  In this case, Microsoft has set the end of life for Windows Vista to be April 2017 and that means that Oracle will be supporting the EBS product from a historical perspective so you need to get off that product and onto newer Windows platforms which are currently slated to be supported past April 2017.

Monday, May 9, 2016

State of the Blog!

Hi everybody!  After a not so short break I am going to work towards getting back in the groove of posting on a more regular basis, starting with another State of the Union-type post to review where I am today compared to the previous post around 2 1/2 years ago and what I want to be doing with the blog in general!

A few years ago I was excited by hitting 5,500 total views and now I am 90,000 views past that and almost at 100,000 in total!  That boggles my mind and amazing that I have put up another 700 posts to be getting close to 1,000 total posts and that is something I never thought I would be saying when starting the blog.  The stats of the views and posts here just highlight what I have been doing, but do not focus on the future and that is what I need to refocus on going forward!

The mission of the blog going forward is to deliver knowledge for Oracle e-Business Suite applications on a regular basis for SysAdmins in the Application Support and Operations space.  It seems like a simple mission statement, but now I need to go a step further and outline for myself what that means and how I can deliver on it.  Those are the types of things I have been noodling on for the past few weeks, but I have realized that I cannot stop posting while I try to align the future of the blog, so be on the lookout for changes over the next few months!!