Thursday Twitter - 5/15/14

This week, I'm going to keep it simple and short; only 10 links will be shared!

Announcements:

https://twitter.com/enkitec/status/466972415512166403 - Enkitec has been acquired!

Training/Free Stuff:

https://twitter.com/oracleace/status/466475726708174848 - The Oracle ACE program shares how to script for Essbase!

https://twitter.com/dbms_output/status/466382367398305794 - Filed under training, here is a bunch of WebLogic 12c information!

General News/Information:

https://twitter.com/ignacioruizmx/status/466596158530658306 - Nacho has made the list again this week, this time sharing Exadata Best Practices!

https://twitter.com/chrisantognini/status/466581866855022594 - Did you know that the newest version of Christian Antognini's Troubleshooting Oracle Performance book has 150 additional pages?

https://twitter.com/dba_hba/status/466516826642329600 - Allan has a very insightful comment about tuning, and how to categorize it!

https://twitter.com/tanelpoder/status/466450107249229824 - We can't have a roundup without Tanel!  This time it is a blast from the past article on latch contention troubleshooting which could help you out if there are some lessons to learn!

Conference News:

https://twitter.com/biju_thomas/status/466578101577977857 - Biju asks a great question, has the tag for the GLOC conference, and shows Ric Van Dyke giving a keynote address!

https://twitter.com/muralivallath/status/466541500332277760 - If you're in the neighborhood, this conference may interest you!

Social Media/DevOps:

https://twitter.com/clicktips/status/466483406155829248 - If you are interested in AdWords, you might want to check this out!

R12: ADRELINK utility on HP-UX creates excessively large executables

When I first clicked on the MOS article "ADRELINK utility for E-Business Suite Release 12.0 and 12.1.1 result in large executables which may lead to out-of-memory issues" from note 1060979.1 I assumed that it was something I could look for in my system but luckily this affects only HP-UX operating systems.  Yet this does give one pause as it COULD happen on any OS in the future so this is another opportunity to monitor our systems for extreme changes.

R12: Reversing matched PO/Invoice distributions

A question that came into my Inbox recently was: can you reverse a PO in R12?  I didn't know, so I decided to search out an answer to the question and I found it in the My Oracle Support article "R12: How Do You Reverse PO Matched, Invoice Distributions?" in note 729985.1 which was directly on point.  The note said that when you receive an error message of "APP-SQLAP-10103 You cannot reverse this distribution." it is by design as with R12 you cannot reverse matched PO distributions.

What can you do?  Well, the note goes on to direct us to go to the Invoice Lines tab and hit the Discard button which with automatically reject the associated PO distributions.  To stay up to date with these types of issues, you can join the My Oracle Support community for Payables by clicking this link.

Invoice DM matching validation problems

The article "System Allows A Standard Invoice Matched To A Debit Memo (DM) To Be Validated Or Remain Validated, Even Though The DM Is Not Validated Or The DM Is Cancelled" found with document ID 1629189.1 is very interesting in that this is a complex problem but most of the solution is business process instead of applying a patch or other fixes.

R12: GL posting ends in ORA-00001

Staying with my R12 updates, you will need to verify you don't run into the issue detailed in the MOS document "GLPPOS: Posting Terminated With ORA-00001: unique constraint (GL.GL_JE_HEADERS_U2)" in ID 758785.1 because there is a known restriction on the uniqueness/length of the journal names.  The problem?  It doesn't seem like the uniqueness is enforced 100% of the time, so you will need to verify how the business sends this data into the system to ensure it will not hit this error.

Latency in OSB causes error messages

The next time somebody in a project says that any latency between systems is not an issue, point them to MOS articles like "Latency in Performing Message Level Security in OSB" within note ID 1629831.1 where an incorrect configuration (another item to always be checking for) caused the latency that started timing out authentication requests.

Weekend Learning: Hyperion Architecture

The other day we had an issue, and I ran across this PowerPoint from OTN which I think you'll enjoy if you need Hyperion reference documentation.

www.oracle.com/technetwork/middleware/bi-foundation/epm-component-architecture-11121-354678.ppt

Thursday Twitter: The Return!

It has been a while since I've shared Twitter posts, but it's past time for it to return!  I'm going to start off slow with just a part of what I've favorited this week.

Announcements:

https://twitter.com/oracleace/status/463672039081902080 - Congratulate the newest Oracle ACE and ACE Associates!

Training/Free Stuff:

https://twitter.com/oraclepress/status/464104980115648512 - Get a free chapter comparing SQL and NoSQL.

General News/Information:

https://twitter.com/ignacioruizmx/status/464403212360241153 - Nacho shares a MOS article about ASM and Exadata.

https://twitter.com/myoraclesupport/status/464389279507304449 - Group your MOS identifiers!

https://twitter.com/c_martin2/status/463768857950572544 - Learn about DBMS_SQLDIAG.DUMP_TRACE which is not documented yet in 12c!

https://twitter.com/woodendaily/status/463768601858560000 - Love this quote from John Wooden!

https://twitter.com/oracleblogs/status/463718511500873729 - Do you use ORACHK?

Conference News:

https://twitter.com/tanelpoder/status/463751921204219904 - Quite the lineup at E4!

https://twitter.com/collab_oaug/status/463742714916651008 - If you are a member of OAUG, the slides from Collaborate are now available!

https://twitter.com/centraloaug/status/463697161390026752 - Join the Central States OAUG group!

https://twitter.com/martinberx/status/463379244127879168 - I couldn't agree more with Martin!

https://twitter.com/kylehhailey/status/462337726344212480 - Oracle wait event documentation shared by Kyle Hailey!

Social Media/DevOps:

N/A - Nothing this week.

Receivables LOV shows inactive values

The MOS article "List of Values (LOV) in the Receivables Interface Lines Table Shows Inactive Tax Codes Values" found in note ID 1625874.1 isn't just for R12, as it pertains specifically to 11.5.10.2, but it has a general lesson for us.  When dealing with LOVs, one needs to make sure what data does not show just as well as what data DOES show up.  We had an issue with this the other day, as the form LOV was not respecting the end date placed on the value set which drove the LOV.

Finding Solaris OS Release and Kernel Information

Have you ever wanted to find out more about the Solaris OS that your system is on, like the release and kernel details?  Look no further than the document "How to Determine the Release and Default Kernel Version in the Solaris Operating System" on the My Oracle Support site in note 1002239.1 for all the details.

Conference Update: OAUG Connection Point - AppsTech 2014

Last year I was lucky enough to be selected to speak at the inaugural OAUG Connection Point - AppsTech conference in Pittsburgh.  This year?  I submitted several abstracts and it's déjà vu all over again, as I've been selected to speak at the conference this year!!  I hope to see you there in July, for what is sure to be another great line up of speakers and information for the attendees!  I'll continue to share with you about the conference as we get closer to the date, but right now I'm on Cloud 9.  :}

5/6 EDIT:  Added links and labels to the post and minor change to the conference name as "Connection Point" is correct but "ConnectionPoint" is not.  I'm picky, sue me!

R12: GL Secondary Ledger Conversion Level Change

In today's installment of "did you know" for R12, the short article "GL Secondary Ledger Conversion Level Change" in note 1614737.1 stirs up more questions than answers for me.  First off you can't enable a conversion of a secondary ledger once disabled, but that makes me wonder why you would want to disable it and what the business implications are if you get to the point you need it enabled again.

Weekend Learning: Useful R12.2 Documents

There are SO many things in note 1585889.1 on MOS "Useful 12.2 Documents For Customers And ATG Support Engineers" that I can't even begin to explain it.  I'm making this a favorite in MOS so I can keep tabs on this to stay on top of changes coming down the road with the various versions of R12.2 as I know that we will be upgrading someday even though we JUST got done with an upgrade.  I would rather have things in the back of my mind for when we start planning, and keep this around for handy quick reference later.

Weekend Learning: OS Watcher

If you want to start getting deeper into the internals of the OS your Oracle products are running on, you need to take a while this weekend to read the "OS Watcher User's Guide" on MOS via note 1531223.1.  This was a tool mentioned during the Hotsos Symposium in March, so I've been on the lookout for an opportunity to learn more about it!

R12: Changes in GL_DAILY_RATES table

Catching up on more changes in R12, note ID 1611110.1 "Why there is the change in GL_DAILY_RATES.STATUS_CODE from 'C' to 'O' after an upgrade to R12?" shows why the status is different depending on what actions are taken to create the items.  Additionally, you can check out an old note 290666.1 to learn more about these status codes.