Tuesday, March 31, 2015

R12.1.3 Payables: Prepayment invoice not found

Check out MOS article "AP Prepayment Invoice Cannot Be Found For Application" from document ID 1995194.1 to find out how the data is wrong in the system and causing problems in the application!

Monday, March 30, 2015

Exachk can report Flash Memory as not configured

Do you run Exachk frequently?  Are you always getting the latest version?  If not, then you may run across the issue reported in MOS article "Exachk Reports Storage Server Flash Memory Is Not Configured As Exadata Smart Flash Cache" from note ID 1989340.1 with a specific version of the Exachk utility.

Sunday, March 29, 2015

Weekend Learning: Calculating file sizes

While you may be saying, I know how to use the du command just fine, so what can I learn this weekend?  Well, visit My Oracle Support article "How to Calculate File Sizes on a Specific File System" from document ID 1986163.1 to learn how to extend the command to get file sizes measured for hidden files/directories or some files that have been mounted in other ways.

Saturday, March 28, 2015

Weekend Learning: Password aging on Solaris

Are you supporting Oracle on Solaris, or is it in your environment in any way?  Do you know about the /etc/shadow file and how it contains the password aging, login activity, account validity and failed attempt lock out policy information?  Check out MOS document "Description of "Password Aging"" from note ID 1007235.1 for all the details about this!

Friday, March 27, 2015

Oracle OpenWorld 2015: Call for Proposals open!

Just a few days ago, the call for proposals for Oracle OpenWorld 2015 opened!  Just over a month away is our deadline for submitting some really good abstracts, so get working!!  I am planning on submitting again this year, and I hope to see you there!

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?