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?

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!

Wednesday, March 11, 2015

Resolving archive logs not being shipped to standby

Have you had occasion to see your remote/DR instance become disconnected or otherwise offline to your primary database?  If so, make sure you bookmark MOS document "Logs are not shipped to the physical standby database" via note ID 1130523.1 for your troubleshooting needs later!

Tuesday, March 10, 2015

R12.1.3 Concurrent Manager: Buttons greyed out on scheduled requests

Have you applied a recent R12.1.3 patch?  If you have, then your version of FNDRSRUN may have a bug in it and the article "Options Button Is Greyed Out For Future Scheduled Request Sets" found in My Oracle Support from note ID 1988337.1 tells you what patch caused this and which one resolves the issue.

Monday, March 9, 2015

Multitenant: Resource Manager runs too many sessions

I have posted about Multitenant once, twice, or maybe a few more times so tonight the My Oracle Support post "Excessive throttling by CPU Manager" from article ID 1590014.1 caught my eye for multiple reasons: this is the first time I remember seeing Multitenant on anything other than 12c, and it really surprises me that a simple problem like this creeps up with just a few PDBs after just a couple of minutes!

Sunday, March 8, 2015

Weekend Learning: EBS 12.2 login issue when DB upgraded to 12c

Combining upgrades for both the Oracle E-Business Suite and Database, the MOS document "EBS 12.2 Login Issue after Database Upgrade to 12c - The system has encountered an error when servicing the request with initialize class oracle.apps.fnd.common.WebAppsContext error" with note ID 1987505.1 shows a very simple reason for WHAT caused the problem but not WHY it happened at all!  Check it out to see what went on and how to solve it.

Saturday, March 7, 2015

Weekend Learning: OAS log file and diagnostic tools for R12

Read the MOS document "Oracle Application Server Diagnostic Tools and Log Files in Applications Release 12" in note ID 454178.1 to brush up on a lot of R12 details this weekend that just might be able to let you monitor and be more proactive with your system!

Friday, March 6, 2015

Weekend Learning: Flash Cache Compression for Exadata

Everybody is curious about the new kid on the block, and the MOS note "EXADATA Flash Cache Compression - FAQ" from document ID 1664257.1 goes in depth on how to create and disable a Flash Cache on a X3-2 or X4-2 Exadata platform.  Take a look at this FAQ and see if it will give you some new information you did not have before!

Thursday, March 5, 2015

R12.1.2: Internet Expenses may throw Java Unparseable errors

Following a lot of what I have been doing on the blog lately, My Oracle Support document "Expenses Unparseable Date Error" from note ID 1986536.1 has yet another lesson about verifying your application changes because this issue stems from an ICX profile option which changed with the patch/upgrade.  Sure R12.1.2 is lower than R12.1.3 that I see a lot of error reports for, and it seems like most people have gone to R12.1.3 also, but there is no reason we cannot learn something from this issue by preparing for this type of change going forward so that we do not get caught out by any of these changes in the future!

Wednesday, March 4, 2015

When too many bind variables is a bad thing

It has hardly been a full week, and my streak has been snapped yet again by missing my post last night!  I will fix that with asking if you know how many bind variables make a SQL statement no longer bind sensitive?  Give up?  Obviously the title of this MOS article "SQL Containing More Than 8 Bind Variables is not Marked as Bind Sensitive" from note ID 1983132.1 gives the answer away, but the answer changes for when you try to take advantage of the 12c Adaptive Cursor Sharing option so check out the article!

Monday, March 2, 2015

R12: Revenue Recognition Execution Report signal 6

Did you know that in R12 your Revenue Recognition Execution Report can end up generating an error message of “was terminated by signal 6”?  We had that exact scenario happen to us when the business ran multiple copies of this report for the same org that started at the EXACT same second!  We did not find any hits on MOS for a resolution, so we asked the business to run them again but in sequence instead of parallel and they both completed successfully.  Searching on MOS does not yield great results, but the closest hit is note ID 1631873.1 which matches some of the error details we saw at that time, but the resolution for it is all wrong as we did not need to patch:

emsg:was terminated by signal 6
Enter Password:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0xb740156c, pid=9281, tid=3031722560
#
# Java VM: Java HotSpot(TM) Server VM (1.4.2_14-b05 mixed mode)
# Problematic frame:
# C  [librw.so+0x75856c]  hshuid+0xe0
#

Sunday, March 1, 2015

Weekend Learning: Gathering data for InfiniBand issues

Have ever had to submit InfiniBand diagnostics to Oracle Support?  If you have not, did you ever wonder how to do it?  Check out MOS document "SRDC - EEST Infiniband Connection Issue on Linux" note ID 1683910.1 to get more details this weekend on what needs to be done to pick up some more things for your toolbox!

Weekend Learning: Introduction to technical details about SLA

While finishing up my presentation and whitepaper for COLLABORATE so I can present in April, I found the perfect article for Weekend Learning, saved a draft, and then promptly forgot to post it last night!  My consecutive posting streak is broken!  Oh well, I am going to post twice today and then know next year on February 29th that I have posted 366 days in a row!  Maybe it has something to do with my last post being the 666th post that was posted too!  Anyways, on with the show!

The MOS document "SLA: A TECHNICAL PERSPECTIVE OF THE AP TO GL RECONCILIATION" from note ID 605707.1 has a lot of good reading about how SubLedger Accounting (XLA) works with R12 so that the AP module no longer retains the accounting information.  Walk through the tables that retain all of the data, so that you can learn about the interconnections between modules that might need alerting!