Thursday, March 26, 2015

R12.1.3 Receivables: County does not show up on Customer form

On R12.1.3 there is a simple problem with the Customer online Form where the county information goes missing after you create the record and you can find all the details in My Oracle Support article "Customer Form, Address Issue: County Information is not Displayed on Customer Page" via note ID 1350119.1 to find out what the problem is with how to fix it.

Wednesday, March 25, 2015

Exadata 12.1.2.1.1 has been released!

A few days ago I shared a post about Exadata 12.1.2.1.0 being released and today I see the document "Exadata 12.1.2.1.1 release and patch (20240049)" posted on MOS via note ID 1959143.1 which also addresses the issue I posted last weekend about how leap seconds are a problem on Exadata version 12!

Tuesday, March 24, 2015

R12.2.3: New profile option to run Create Accounting in detail

Upgrading to R12 brought a lot of changes from 11.5.10.2 across every module and Receivables with the transition from needing to run the "General Ledger Transfer" report to running the "Create Accounting" report.  With R12.2.3 enough people have requested a new feature so the Create Accounting can mimic the General Ledger Transfer a bit which My Oracle Support article "How to run create accounting in detail level with no merge in R12" goes into detail in document ID 1992895.1 about the patch required and the profile option which needs to be enabled to take advantage of this development.

Monday, March 23, 2015

R12: NACHA format problem drops leading zero

On R12.0.6 we learn/re-learn a valuable lesson about the difference between datatypes with MOS document "R12 US NACHA CCD Format Mishandles ABA Routing Number With Leading "0"" in note ID 841127.1 where a simple issue changes the formatting of the NACHA!

Sunday, March 22, 2015

Weekend Learning: The difference between Core Dump and Heap Dump

Have you ever read log files and wondered what the difference is between core dump or heap dump files?  Find out in this My Oracle Support article "What Is the Difference Between a Heap Dump and a Core Dump and How to Enable Each?" via document ID 1981375.1 for all the details!

Saturday, March 21, 2015

Weekend Learning: GoldenGate availability and patch notes

If you need to support the Oracle GoldenGate product, you may want to favorite these My Oracle Support articles and visit them this weekend to brush up on your general knowledge about the product!

Oracle GoldenGate Core Product - Release Availability and Support Status - Note ID 1920237.1
Master Note for Oracle GoldenGate Core Product Patch Sets - Note ID 1645495.1

Friday, March 20, 2015

Leap seconds, Exadata, Oracle DB and Linux OS

Are you aware we are having a leap second added at the end of June?  Do you know how that affects Exadata?  Refer to My Oracle Support document "Leap Second Time Adjustment (e.g. on June 30, 2015 at 23:59:59 UTC) and Its Impact on Exadata Database Machine" from article ID 1986986.1 to find out why you need to be worried about it if you have upgraded any infrastructure to the 12.1.2.1.0 version of software but you do not need to be worried if you have any other version of Exadata software installed.

Do you just want to know more about what a leap second is, and how it affects an Oracle DB?  Then MOS article "Leap seconds (extra second in a year) and impact on the Oracle database." from note ID 730795.1 will be your cup of tea while article "How Leap Second Affects The OS Clock on Linux and Oracle VM" from document ID 1453523.1 clues you in on how the Linux OS could be affected with or without the ntp service being installed on your system.

Thursday, March 19, 2015

12c: New hint to enable statement level Parallel DML

You may be familiar with Degree of Parallelism or Auto Degree of Parallelism (ADoP) settings for your instance, but did you know that 12c introduces a new way of using parallelism?  The My Oracle Support document "New 12c Hint: ENABLE_PARALLEL_DML Lets you Easily Enable Parallel DML (PDML) at the Statement Level" from note ID 1991034.1 introduces this new option for you with a very simple example of a table being loaded with and without this enabled so you can see it in action.  Even though the article linked at the end is for DW, there could be reasons to use this in your OLTP installation!

Wednesday, March 18, 2015

R12.1.3 Purchasing: Tax does not default on PO lines

Did you know that there are problems on R12.1.3 with the Purchasing module where information is being lost behind the scenes after hitting the save button?  The MOS document "19176183 Type_1099 Tax Is Not Defaulting To PO Line" from article ID 1991078.1 shows how to replicate this and also what patch is required to fix it too!

Tuesday, March 17, 2015

Hardware misconfiguration does not allow CRS to start up

Sometimes the most straightforward MOS articles can tell you so much, and the article "CRS is not starting up when Private Interconnect is disconnected on the other RAC node" from note ID 1981887.1 is a great example of that because there is such a simple explanation at the heart of this article even though it teaches so much.  Did you see this answer coming?  Does it make you rethink anything you have done lately?

Monday, March 16, 2015

HFM data sync gets stuck on 11.1.2.2

Were you aware that on 11.1.2.2 that "Hyperion Financial Management (HFM) Data Sync is Stuck" from My Oracle Support note ID 1985527.1 can be an issue due to Internet Explorer/Apache timeout settings?  It is true!  Find out what settings can resolve this timeout issue for you inside the MOS article!

Sunday, March 15, 2015

Weekend Learning: 12c and SQL performance with In Database Row Archiving

This weekend make sure that you read the My Oracle Support document "Potential SQL Performance Degradation When Using "In Database Row Archiving"" from note ID 1579790.1 so that you are aware of a. how In Database Row Archiving works and b. how it affects SQL performance tuning.  Everybody wants to upgrade right?  Everybody wants to use the latest and greatest features right?  Find out what happens when you do both with 12c and In Database Row Archiving!

Saturday, March 14, 2015

Weekend Learning: Release notes for Exadata 12.1.2.1.0 patch

Obviously the big headline of the patch in MOS document ID 1947476.1 "Exadata 12.1.2.1.0 release and patch (17885582)" is the support for the newest family Exadata member the X5-2 but there is a LOT more information like how sparse grid disks allow for larger virtual sizes and the patch enables Columnar Flash Caching as well.  Check it out and get up to date for all your Exadata needs including some important known issues with the patch!

Friday, March 13, 2015

Weekend Learning: EBS R12 Payments Funds Disbursement Analyzer

Look to the My Oracle Support article "R12: EBS Payments (IBY) Funds Disbursement Analyzer" from document ID 1587455.1 this weekend to get up to speed on issues affecting PPR (Payment Process Request), Oracle Payments, XML Publisher, and OPP (Output Post Processor) issues after installing or running this analyzer.

Thursday, March 12, 2015

Thursday Twitter - 3/12/15

Returning to Twitter this week, I am changing up the format and instead of several different categories I am going to focus on just one: Conferences.

RMOUG:  Of course, we cannot forget about the awesome Training Days conference from the Rocky Mountain group and you can still catch up on everything with #TD2015!

HOTSOS:  While I did not get to go this year, it was still good to follow along with #HotSym15 attendees and presenters!

OUGN:  Ever wonder what it would be like joining an Oracle conference on a boat?  Follow along with #OUGN15 for a Norwegian conference cruise!!

UTOUG:  Get a lot of information flowing out of the Utah group's own Training Days which is also going on right now and can be found at #UTOUGTD15!

OAUG:  Join in with the #C15LV hashtag to connect with thousands of Oracle users leading up to and during COLLABORATE!

GLOC:  Prepare to follow along with the Great Lakes conference by adding #GLOC15 to your list!

Was there a recent conference that I missed?  Let me know in the comments!