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!

Sunday, August 31, 2014

Weekend Learning: OBIEE - Information Center

If you get to support the OBIEE application then you will want to favorite the MOS post "Oracle Business Intelligence Enterprise Edition (OBIEE) Product Information Center (PIC)" via document ID 1267009.1 so you can stay on top of all the news and issues that Oracle releases for the product.

Saturday, August 30, 2014

R12: Create Accounting in error due to older files

File this one away for reference if you are upgrading to R12, or if you are applying some patches, and your Create Accounting program starts giving you ORA-00001 errors.  My Oracle Support note "Create Accounting Program Ending In Error:An internal error has occurred in the program xla_je_validation_pkg.populate_segment_values. ORA-00001: unique constraint (XLA.XLA_AE_SEGMENT_VALUES_U1) violated." from document ID 1902705.1 is directly on point with the files, versions, and patch which will resolve this.

If this helps you, please let me know so I can look for more of these types of articles in the future!

Friday, August 29, 2014

Blog roll update: Oracle Open World

Following yesterday's post about updating the blog roll, I think it is a good time to share another one with you!  Are you going to Oracle's Open World this year?  Do you know good places to get new information about the conference?  Look no further than the official Oracle Open World blog!  It may seem obvious, but this blog usually takes a break in between conference cycles so right now there is a flurry of activity and don't let it fool you into thinking it will be updated all year round.

Thursday, August 28, 2014

Blog roll update: oradbn

Last week I added a new blog to my list and today I decided to find another new blog that has the kind of articles I'm looking for!  While the oradbn blog from Benedikt Nahlovsky might only have a handful of posts from the last two years they are goldmines for being able to monitor the database in new and interesting ways, finding out more on ORA errors that can be encountered on new database versions, and getting 12c installed and running.  There are some great ideas here that I can use at work to implement some new monitoring but also is an outside perspective with how to handle things in a completely different way.

Wednesday, August 27, 2014

Assets: Can periods be reopened?

In a word, no.  Per the My Oracle Support document "How To Reopen a Closed Period In Fixed Assets?" via note ID 1358755.1 it is very clear that getting a period reopened is impossible to do as a supported option from Oracle.  I did find a post in the Oracle Community indicating that a datafix was available, but I have been told that there is not currently a datafix available for customers if the period has been closed by accident.  There are a few options available in the MOS document, but I am not sure they are viable for every situation.

Tuesday, August 26, 2014

Magical Mystery Event Tour: Part 2

Continuing the outlook for wait events which are out of place comes a post about the mystery behind the "GV$: slave acquisition retry wait time" wait event I have encountered on 12c.  My MOS research found two articles which are on point, but neither of which makes a whole lot of sense:

WAITEVENT: "GV$: slave acquisition retry wait" - Note ID 371117.1

This document talks about a list of instances, and thinking there is a configuration change in process until it no longer thinks the configuration change is going on.  This was something I could not understand because nothing seemed to be reconfiguring, and the document did not point me to a specific thing I could look at to see if it was reconfiguring.  After a few weeks of this being very low on our wait event alert, it eventually went away.

Wait Event GV$ Slave Acquisition High With CURSOR_SHARING To FORCE - Note ID 1589592.1

This article was referring to the parameter (in gv$parameter) cursor_sharing being set to FORCE, which we did not have it set to, and leading to a buffer value needing to be changed.  There was no changing the value before it went away, and we even had the value higher than the recommendation!

Since it went away, and we could not narrow down what was going on, I am sure I will see it again in the future and when I nail this one down there will be an update here.  :}

Monday, August 25, 2014

Free Webinar: R12 and Change Management from OAUG

Have you ever wondered about the OAUG group that I have had the wonderful chance to present for?  Wonder no more, as Wednesday you can enjoy a free presentation and get a glimpse of what the organization is all about by attending the webinar "Change is Good, Except Right Before an R12 Go-Live: Change Control and Release Management is the Key".  Not only is this a great topic, and a window into what one can see at regular conferences from the OAUG, but it is a "Best of COLLABORATE 14" so out of hundreds given this year at COLLABORATE this is one in the top percentile.  Have you already released R12?  Well, could you stand to learn something about the subject at hand anyways?  I know I could, so I'm planning on attending!

Sunday, August 24, 2014

Weekend Learning: Oracle BI Publisher - Information Center

Do you use BI or XML Publisher?  Learn more about the technologies by visiting the Product Information Center on My Oracle Support in document "Oracle BI Publisher (BIP) Product Information Center (PIC)" via note ID 1338762.1 to be introduced to many different articles on the subject.

Saturday, August 23, 2014

Weekend Learning: Solaris 20 years old

Of course those that do not learn from history are doomed to repeat it, but it may be interesting to know that Solaris celebrated 20 years of existence in 2012 and this site was created to tell the story and share some videos about it as well.  What is the big draw here?  The site also looks into the future by sharing a roadmap for the next few years, including when Solaris 12 might be released.

Friday, August 22, 2014

Weekend Learning: New and changed features for Procurement in R12.1.3 and beyond

Do you know how the Procurement module has changed in the latest R12 EBS releases?  Well look no further than this note from My Oracle Support "Procurement R12.1.3+ New and Changed Features" via ID 1607297.1!  Favorite this article since that + sign means the article will keep being updated with new features with new releases and RUPs too.

Thursday, August 21, 2014

Datapump LOB export/import not in parallel

Are you getting ready to do an upgrade of your OS/DB/app platforms?  Were you planning on using Datapump to get it done?  Did you know that the export and import of LOBs cannot execute in parallel?  My Oracle Support document "DataPump Export/Import Of LOBs Are Not Executed in Parallel" in note ID 1467662.1 not only informs us of that fact but introduces us to an overview article of Oracle Large Objects for BasicFiles and SecureFiles too.  Take a few minutes to read both MOS articles!

Wednesday, August 20, 2014

Blog roll update: ASM Support Guy

It has been quite a while since I had a blog roll update, but there are several new blogs that I have squirreled away for later and I hope to catch up with them over the next few months and share the really great ones with you!  Even though Bane Radulovic might not have a huge volume of posts over the last year or two, his ASM Support Guy blog has a LOT of information about ASM (duh) but also quite a bit of information about ASM in relation to the Exadata platform.  How much do you know about ASM, or ASM with Exadata?  Could you always learn more?  I know I can, so I am going to add this to my blog roll and apply some things learned from Bane and give you an update on what I have learned in future blog posts.

Tuesday, August 19, 2014

R12.1.3: Invoice adjustments blocked for inaccurate accounting

Sometimes when searching for one thing, you find another, and the article "Invoice Adjustments Ends in Error - This Action Has Been Blocked To Avoid Inaccurate Accounting Entries" via document ID 1626521.1 is no different.  I am lucky that we haven't had any reports of the error "This action has been blocked to avoid inaccurate accounting entries" being encountered yet, but I am going to be checking the version of ARALLOCB.pls that we have in our system to make sure that we will not be getting it in the future.  Will you be checking as well, or will you encounter the issue when you can least afford it?

Monday, August 18, 2014

GL: FRM-40654 when reversing journal

When our GL team was trying to close out the month, they were receiving the error "FRM-40654: Record has been updated. Requery block to see change." when trying to reverse a journal entry.  After looking at everything we could regarding locks, and other people being in the record or the form, I finally researched on My Oracle Support to find the document "GLXJEENT: Journal Reversal gives Error FRM-40654: Record has been updated. Requery block to see change" via note 1135903.1 which helped me solve the problem.

There is an enhancement bug and it seems that even though it is marked as fixed in 11.5.10.2 we still encountered it on R12.1.3 so we need to find out what patch to apply to prevent this in the future!