Thursday, February 4, 2016

R12 EBS: Output Post Processor not working due to JVM error

The article "EBS: OPP does not work After Platform Migration ; Conflicting Collector Combinations ; Could not Create the Java Virtual Machine" can be found on My Oracle Support via note ID 2103349.1 which tells us why this happened AND also more details that could be useful in your toolbox about "developer parameters" or environmental files being used!

Wednesday, February 3, 2016

R12 Purchasing: Template clears information on category change

Over 3 years ago the issue "INFORMATION TEMPLATES CLEARED WHEN CATEGORY CHANGED FOR THE LINE." was reported on My Oracle Support via bug number 15863073 where template information is cleared after the requisition gets saved and then altered before submitted and if you are affected by this make sure you get your data added to the bug!

Tuesday, February 2, 2016

11gR2: ASH report has "null event" wait event

The My Oracle Support article "'Null Event' Wait Events Occurs Intermittently in ASH Report" from document ID 2102027.1 clues us into a known bug which is resolved in 12.2 and lets us know that this is a pretty insignificant issue but it is really important to know this does not mean anything so we do not freak out when we see it in the wild!

Sunday, January 31, 2016

Weekend Learning: Bill Presentment Architecture (BPA) setup

Do you use XML for your PDF generation?  Have you looked at "Bill Presentment Architecture Set Up And Usage" on My Oracle Support from document ID 786553.1?  You should!  Find out if you can upgrade your processes and environment!!

Friday, January 29, 2016

R12.1.3: Is there a problem with AME rules not being executed due to notification delegation?

In any busy environment you know that delegation is incredibly important to make sure workflows keep moving and business keeps happening, but is there a flaw with AME rules being fired when delegated?  My Oracle Support note "AME Rule Is Not Getting Executed With The Notification Being Delegated" from article ID 2015185.1 has all the details including a very good explanation for the answer!

Thursday, January 28, 2016

Linux VM: Server crash due to Fatal Machine kernel panic

As our systems become more and more complicated, and we look for more and more ways to consolidate and save money I am sure more technologists will need to learn about bugs associated with the Linux VM platform!  Tonight is one such lesson from MOS note "Server Crashed with Kernel panic - not syncing: Fatal Machine check" via ID 2093734.1 as the vmcore output shows very clearly that the kernel did panic which resulted in the server crashing, but just as important as knowing that information is WHY Oracle indicates this happened!

Wednesday, January 27, 2016

R12.2.3 Payables: Maximum value size is violated for DFF

The issue described in MOS article "DFF Error - The Maximum Value Size For Segment Is X. Truncating Value To Xxx (R12.2)" from document ID 1960243.1 may be due to a direct upgrade from right to 12.2.3 but I will bet it could also be seen if you upgrade from an earlier version of R12 as well!  Check out the associated bug and patch for all the details and update your testing suites accordingly!

Tuesday, January 26, 2016

Solaris: ZFS root pools hang system when unavailable

While we are talking about ZFS and not ZFSSA "Systems with a ZFS Root Filesystem Running Certain Solaris 10 patches or Solaris 11 SRUs may Hang if the Disks of the Root Pool Become Temporarily Unavailable" is still a good document to read on My Oracle Support from article ID 2098232.1 so you can learn what symptoms are possible on Solaris just in case this happens to your system!

Monday, January 25, 2016

R12.1.3 Payables: APP-SQLAP-10264 error is thrown while new operating unit is setup In Financials During Setup Of New Operating Unit [2096022.1]

Article "R12 AP: Error APP-SQLAP-10264 In Financials Options During Setup Of New Operating Unit" on My Oracle Support via document ID 2096022.1 is a good one to read about why data validation is important and how automatic numbering can trip the system up.

Sunday, January 24, 2016

Weekend Learning: Whitepaper on Exadata monitoring with Enterprise Manager

Do not miss this whitepaper on Monitoring Exadata Storage Server Grids with Enterprise Manager from the Maximum Availability Architecture (MAA) team which has the entire step by step process and all the SQL you need to set up all of the conditions you need to alert on!

Saturday, January 23, 2016

Weekend Learning: Defining the TCP Socket (KGAS) wait event

I have talked about this wait event before as a potential warning sign of network issues, as well as an indicator when you have database traffic misbehaving, but what does Oracle say about the TCP Socket (KGAS) wait event?  I am SO glad you asked!  Wait no more, check out MOS article "What are 'TCP Socket (Kgas)' Waits?" from document ID 416451.1 for the official word on why this wait event is not a cause to open an SR with Support, and what issues it could be representing!

Friday, January 22, 2016

Oracle Forms: Frmall.jar and Frmwebutil.jar files are set to expire soon

So when I say soon, I mean the .jar files may have already expired in your system or will expire tomorrow.  Oops.  Find out more about this from My Oracle Support article "How to Extend Frmall.jar and Frmwebutil.jar Expiration Beyond 22, 23-Jan-2016" via note ID 2072400.1 to learn what can be done for 10gR2, 11gR1, and 11gR2!

Thursday, January 21, 2016

R12 Workflow: Automated replies give "Client was not authenticated" errors

On R12.1.3 and R12.1 "Automatic Reply To Unsolicited Mail shows erros 530 5.7.1 Client was not authenticated" from MOS document ID 1991613.1 indicates this can be resolved with a patch but it seems like the root cause is when the SMTP server gets changed!

Wednesday, January 20, 2016

Transparent HugePages on several Linux kernels should be turned off

Even though the document "ALERT: Disable Transparent HugePages on SLES11, RHEL6, RHEL7, OL6, OL7 and UEK2 Kernels" in note ID 1557478.1 on MOS has been out there for years, it is still good information to have that the Transparent HugePages (not regular HugePages) feature is enabled by default AND that it can cause instability in RAC or non-RAC environments!  Since Oracle recommends turning this off in all your database machines, do you know if it is off in your systems?

Tuesday, January 19, 2016

11gR2: Performance with NVL or NVL2 is slow

My Oracle Support article ID 2093132.1 for the document "Slow Performance With NVL or NVL2 Referencing PL/SQL Function Even When Ignoring the Function's Result" directs us not to an issue but to a basic fundamental part of PL/SQL that is certainly worth checking out!  Without looking at the document, can you guess why this is happening?