Weekend Learning: Master reference note for "CPU time" wait events

If you have ever looked at what your database is doing in either a real time fashion, or via ASH/ADDM reports, then you have obviously seen wait events referencing the CPU and that does not mean there is a problem with the CPU or even with the database, but for the times when you are not sure make sure you have favorited the document ""DB CPU" / "CPU + Wait for CPU" / "CPU time" Reference Note" in My Oracle Support note 1965757.1 so you have a one-stop shop at your fingertips!  This would also be useful too, if you wanted to utilize it to check out possible issues when upgrading your database version or adding new features!

R12 Payables: JBO-25013 error is thrown when selecting supplier relationship

A few months ago there was an article I put up about several IBY tables and article "R12.1:22878464:Error JBO-25013 On Supplier When Selected The Supplier Relationship Tab" on My Oracle Support via document number 2115923.1 was just solved today but what I think is important from this is finding out a new IBY table AND another instance of something that needs to be added to your testing suites!

Exadata: CellCLI "list activerequest" command can produce I/O hang in Storage Server

Do not miss out on applying the patch to resolve the issue described in the MOS article "(EX27) Database IO may hang when CellCLI command "list activerequest" is executed on an Exadata Storage Server" from note ID 2095255.1 so your system is not subject to this if you ever need to run the command in an Exadata machine!

R12 Payables: Invoice Mass Additions Diagnostics

Make sure you have installed the diagnostic from My Oracle Support document 1162973.1 "R12.1 Mass Additions Diagnostics" so you can find out why something did not transfer from the Payables module in EBS over to the Assets module!

Exadata: Oracle Enterprise Manager shows Management Server is DOWN but ping shows SUCCESS

With MOS document "EXADATA:OEM errors MS Status is DOWN and Ping Status is SUCCESS" from note ID 2112971.1 we learn that in Exadata Cell server software 12.1.2.2.0 the ipconf utility restarts the Management Server and that since ipconf runs with Exachk the MS gets restarts every time you run Exachk!  Seems like a problem huh?  The good news is that cellsrv does not actually go down, so there is no service interruption, but this is something you may need to know for your next patch application!

R12: Programs complete in Warning due to "Output Post-processor is Running But Has Not Picked up This Request"

Article "R12: Various Programs End With Warning: The Output Post-processor is Running But Has Not Picked up This Request" in My Oracle Support refers to R12.0.6 in document ID 1224684.1 BUT has a lot of information about the setup of the Concurrent Manager and Output Post Processor so it is a good one to read up on even if you know about this and have patched to help prevent the issue from happening!

Weekend Learning: What APIs and programming languages can be used to make a connection to an Oracle DB?

While not directly on point for somebody in an application support role, you may need to know the information within MOS document "Oracle Client API's that can be used to access an Oracle database." from article ID 739169.1 so take a moment to brush up on your knowledge!

Exadata: InfiniBand may fail to send messages to cause I/O failures on Oracle VM

If you are running Exadata on Oracle VM, you need to look at the article "(EX26) Messages over the InfiniBand network may fail to send causing IO failures and hangs when using Exadata OVM with Exadata cell version 12.1.2.1.3" in My Oracle Support from note ID 2105407.1 as there is a pretty straightforward way to resolve this, even if it might not be the kind of solution you are looking for!

R12 Payables: Vendor and vendor sites can be updated post merge

The My Oracle Support article "R12: Payables: Merged Vendor and Vendor Sites can be Updated in Supplier Entry Screen" via document ID 2107797.1 talks about what happens when vendor sites can be updated after being merged and an error is thrown when trying to merge it again.  Also, I learned about the table AP_DUPLICATE_VENDORS_ALL which will let you know if a vendor has ever been merged before and with the data pattern described in the document could give you a chance to build a proactive alert!

ZFS Storage Appliance on Solaris could have transient write hangs due to snapshot actions

Tonight from My Oracle Support "Solaris 10, Solaris 11 and ZFS Storage Appliance (ZFSSA) Software may Intermittently Experience Transient Write Hangs if a Snapshot Destroy or Replication is in Progress" in document ID 2067174.1 is a pretty straightforward article that you need to be reading if you are on these Solaris platforms as this could happen at any time due to the type of actions being taken which are automatic!

R12.1 RPCs Superseded Again

Back in 2014 I posted a short post about Recommended Patch Collections being superseded for many modules and starting with My Oracle Support note 2102716.1 for "EBS: R12.1: Receivables Recommended Patch Collection (RPC), Feb 2016" you can find other RPCs but an even better idea is to add the document "EBS: R12.1 Latest Oracle Financials Recommended Patch Collections (RPCs)" from article ID 954704.1 to your favorites list in MOS.  This way when there are future updates, you can always stay up to date!

ANNOUNCEMENT: Arizona/New Mexico OAUG Geographic Region

Tonight I return from a short sabbatical to let you know that a new Geo has been formed by OAUG to represent the Arizona and New Mexico region, and you can go to the LinkedIn group to stay informed about recent updates which should be coming over the next few days and weeks leading up to OAUG's COLLABORATE conference!

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!

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!

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!