Wednesday, April 23, 2014

Hyperion Troubleshooting Assistants

Changing things up a bit tonight from the Information Centers I've posted the last few days, I present to you several Troubleshooting Assistant articles you can find on MOS:

Troubleshooting Assistant: Hyperion Essbase and Smart View Technical Issues - Note ID 1616200.2
Troubleshooting Assistant: Hyperion Essbase and Shared Services Technical Issues - Note ID 1616190.2
Troubleshooting Assistant: Hyperion Essbase and Essbase Administration Services (EAS) Technical Issues - Note ID 1616191.2
Troubleshooting Assistant: Oracle Hyperion Planning and Technical Issues - Note ID 1618663.2
Troubleshooting Assistant: Oracle Hyperion Planning and ODI - Note ID 1620740.2
Troubleshooting Assistant: Oracle Hyperion Planning and LCM - Note ID 1620753.2

Tuesday, April 22, 2014

ASMLib Information Centers

How much do you know about ASMLib?  Could you stand to learn a few more things?  If you think knowing more about ASMLib will help you, check out (and favorite) these My Oracle Support documents:

Information Center: ASMLib - Note ID 1624409.2
Information Center: Installing and Configuring ASMLib - Note ID 1627326.2

Monday, April 21, 2014

PL/SQL Information Centers


I may be on vacation this week, but I'm not going to leave you without SOME kind of information you can learn from and today I'll suggest you visit these notes in My Oracle Support to brush up or learn a few different things about PL/SQL!

Information Center: PL/SQL in an Oracle Database - Note ID 1622611.2
Information Center: PL/SQL in an Oracle Database: Upgrade - Note ID 1627571.2
Information Center: PL/SQL in an Oracle Database: Patching and Maintenance - Note ID 1627678.2
Information Center: PL/SQL in an Oracle Database: Install and Configure - Note ID 1627697.2

Sunday, April 20, 2014

FYI: Oracle Hyperion Essbase 64 Bit Information

Are you thinking about installing Oracle Hyperion Essbase?  Maybe thinking about upgrading your platform to a 64-bit OS client?  Then you should visit the article "Oracle Hyperion Essbase and 64 Bit Master Note" in My Oracle Support note 1090635.1 to get information on APIs, ODBC drivers, and SmartView issues with an eye towards a 64-bit OS client.

Saturday, April 19, 2014

Ping utility on Oracle Linux can report network is down

The article on My Oracle Support "Oracle Linux: Ping to IP address on non-local subnet returns "ping: sendmsg: Network Is Down"" in note ID 1625215.1 shows us why the ping command will timeout without some changes in the configuration file.  This is worth some reading because you'll learn more about the config files that make up your system, but also a bit about subnetting and routing.

Friday, April 18, 2014

Weekend Learning: All you need to know to upgrade PeopleSoft

Are you working to upgrade any modules in Oracle PeopleSoft?  If so, then the note in My Oracle Support 1587686.2 titled "Upgrading PeopleSoft? Start Here" which really says it all.  This has tips for PeopleTools, HCM, ELM, CRM, EPM, and FSCM in a lot of different areas so it is a great article for people like me that are trying to get up to speed on the platform as well!

Thursday, April 17, 2014

11.2.0.3 VIP/SCAN VIPs unreachable causing connection issue

There are always new things I find on My Oracle Support, but one interesting find was "11.2.0.3 VIP/SCAN VIP is Not Pingable After Failover Leads to Connection Issue" from note 1379498.1 because it reminds me of the problems we had with our ZFS connection after upgrading to 11.2.0.3 on Exadata.  Of course there is a workaround and the next patch of 11.2.0.3 contains the fix, as well as 11.2.0.4, but it would not hurt at all to make sure your platform is on the right version to avoid bug 13440962.

Wednesday, April 16, 2014

R12 Payables: Running Accounts Payable Trial Balance Report by Customer

From the "did you know?" file, comes an article on My Oracle Support titled "Customers Are Available In The "Accounts Payable Trial Balance Report" Parameter" in note 1629022.1 explaining that the new Payables architecture in R12 allows the report to pull in Customers as well as Suppliers. Of course this makes sense with the changes, but since I haven't had much of a chance to get hands-on experience with this change I am sure that I will keep running into these tidbits of information that I will be sharing with you along the way!

Tuesday, April 15, 2014

R12: Filling up the $APPLTMP directory

The other day we had our mount volume monitoring went off indicating that we had a mount starting to fill up, and they were a bunch of randomly named files all with the extension of .t for some reason.  So off to My Oracle Support our DBA went to create a ticket and the answer came back that we should look at note 730342.1 for "Files Get Created In The $APPLTMP Directory And Fills The Drive" to take the requested actions to resolve this issue.  While yes following this advice will help get us out of the weeds, I think is a band-aid for what the root cause might be.  I'll follow up with more on that when I research it a bit more, and maybe another issue I might have caught while investigating this.  :}

Monday, April 14, 2014

Heartbleed, OpenSSL, Exadata, R12 & You

Do you know what Oracle products are affected by the Heartbleed OpenSSL bug?  Well, you do now after reading this public article on the Oracle Technology Network!  The good news is that some large products such as Exadata and EBS R12 are not affected at their core…the caveat to that I see is unless they are running on a version of the Linux OS that is listed as affected.

Sunday, April 13, 2014

Weekend Learning: GoldenGate replication after flashing back

Getting further into the guts of what makes the Oracle Database product, this article "How to recover GoldenGate replication after flashing back (or recovering to a precious point at) source database?" in MOS note 1626736.1 helps to get a bit more understanding.  It is a very good step by step explanation of how to flashback to a specific transaction SCN and then changing the GoldenGate extract so that it catches back up from that point.

Saturday, April 12, 2014

R12 Receivables: Unapplied Receipts Journal Report has wrong data

In what seems like a fairly important issue, in R12 the Unapplied Receipts Journal Report shows as off from the R11 counterpart.  In My Oracle Support note 1628501.1, the cause is listed as a query missing a where clause but luckily it also lists the patch which has the fix available as well.

Friday, April 11, 2014

R12: Expense Reports get stuck after approval

Today I got to deal with a new A/P issue that we've reported to Oracle development, where APEXP workflows will spawn off the AME approval process successfully but after approval the workflow doesn't report back to the parent workflow.  Instead of having the child process report back, the parent workflow sits there at the Block stage until you retry the most recent Active stage which was the AP Approval Process and then the parent workflow goes all the way to the end allowing the invoice to be imported and paid.  We're not sure why certain expense reports fail in this way, as most succeed without issue, but I wanted to put this out there so you can try the workaround and I'll follow up with what we find as a resolution or cause.

Thursday, April 10, 2014

Hyperion: Planning PSU application breaks Financial Reporting Studio

Our team had applied a Hyperion Planning PSU in DEV to try and resolve a report issue, but they reported that they started receiving an error in Financial Reporting Studio starting with "HARSnapin Initialize() Error -2147467259 - ; nested exception is: java.rmi.UnmarshalException: error unmarshalling return" when they tried to open any report.  The key here was the PSU that was deployed, as My Oracle Support note 1518423.1 was applied to "refresh" Financial Reporting Studio but if there wasn't a new PSU deployed note 1311069.1 could have applied where a file was corrupted on the server that needed replacing.

Wednesday, April 9, 2014

Conference reminders!

Don't forget to check Twitter for the hashtag #C14LV or click here for the Twitter link to keep up with this year's Collaborate conference from OAUG!

Looking to the future, the call for proposals deadline for Oracle Open World this year is fast approaching on April 15th so you only have a few more days to get your abstracts polished and submitted!