Monday, August 8, 2016

R12 Purchasing: PO lines are validated even though they were cancelled

On R12.1.1 "Canceled PO Lines Are Getting Validated During PO Approval" in Purchasing per My Oracle Support note ID 2169842.1 when at least one line is cancelled from a PO that has already been approved!  The good news is that there is a patch, and that you can design a testing scenario to validate that this issue does not come back in the future!

Sunday, August 7, 2016

Weekend Learning: Exadata Database Machine and Exadata Storage Server versions

Have you ever asked yourself what the latest and greatest versions of Exadata components are?  So have I!  Well we are all in luck, as MOS document 888828.1 for the note "Exadata Database Machine and Exadata Storage Server Supported Versions" has all of the information you would ever need about Exadata versions!!

Saturday, August 6, 2016

Weekend Learning: Oracle Key Vault - Master Note

Are you responsible for the security of your Oracle installation or the EBS application?  Do you know what Oracle Key Vault is, or how it can enhance your current security measures?  Find out more from MOS note 2120572.1 for the article "Master Note For Oracle Key Vault" so you can research!

Friday, August 5, 2016

Drastic increase in blog traffic!

As you may remember when we celebrated the blog's fourth anniversary, I reached 100,000 views and am approaching 1,000 posts, which is why last month I was SO surprised to get over 10,000 hits with 85% of those coming from Russia alone!  I wonder if other people are experiencing this type of traffic increase as well, and I also wonder if that type of pattern will be maintained going forward!

Thursday, August 4, 2016

R11i/R12 Payables: What data does the table PO_HISTORY_VENDORS hold?

If you are on R11i or R12 check out article "What is the purpose of PO_HISTORY_VENDORS?" from My Oracle Support via note ID 2169186.1 to find out what data the table holds and how it relates to purging programs!

Wednesday, August 3, 2016

R12.1: Enabling TLS in Oracle EBS

Read up on MOS article 376700.1 to learn how to start working on "Enabling TLS in Oracle E-Business Suite Release 12.1" for your environment today so you can get away from SSL as many third party vendors are going away from SSL due to all of the issues like POODLE.

Tuesday, August 2, 2016

ZFSSA: Network Data Management Protocol (NDMP) backups can fail after configuration backup starts

Check out My Oracle Support note "All ZFS Storage Appliance (ZFSSA) Software Network Data Management Protocol (NDMP) Backups Will Fail After a Configuration Backup Has Been Initiated" via document ID 2165712.1 where the NDMP daemon needs to be restarted in certain cases!

Monday, August 1, 2016

OOW16 Rejection!

In past years I have been rejected by the Oracle OpenWorld, and last year I was positive I would get selected, but this year I was even MORE positive I would get selected yet it was not to be!  Maybe next year, since I just gave my AppsTech presentation, which was really well received and pushed me a bit so if I add some more polish it I could get accepted for OOW17!!

Monday, July 11, 2016

R12.1.3 Assets: Unsecured books show up in LOV

Did you know that Asset books that are not secured show up in the application?  That is exactly what My Oracle Support document "All Asset Books Appear in the List Of Values in FA After Doing Security By Book Setup for Some Asset Books" via note ID 1582935.1 teaches us as the key here is not all books have been secured, and the unsecured books will show up in the LOV while in the other books!

Thursday, July 7, 2016

Register for OAUG's Connection Point - AppsTech conference today!

I may have mentioned that I am presenting at OAUG's Connection Point - AppsTech conference, and it is never too late to register for it!  This will be an online only conference so you do not need to travel at all, and you can check out the great lineup for the event too!!

Wednesday, June 29, 2016

Assets: How can you reverse an already amortized adjustment?

Look no further than My Oracle Support note "How To Reverse An Amortized Adjustment?" via document ID 1251976.1 for the short steps on how to do this for and after (which I will assume applies for R12 as well)!

Tuesday, June 28, 2016

Happy (belated) Birthday to the blog!!

Four years, and a week, ago I started this blog and interestingly enough exactly four years ago I made my second post too!  What has changed in that time?  I have finally hit 100,000 views, I am almost at 1,000 posts, and I even posted every day for 365 days in a row!  I have presented many times over the past few years, and I have another coming up next month as well!!

I am looking forward to what else is coming during the next year, and now that my newest presentation has been finalized and approved, I will be able to spend more time with the blog.  There are some plans I have in mind for the blog, so next year it may not look the same, or even be the same, but I hope you'll join me on where ever the journey takes me!

Tuesday, June 7, 2016

R12.1.3 Receivables: Autoinvoice Import fails with APP-AR-11526/ORA-04063 errors

Did you know that in R12.1.3 the "AutoInvoice Import Fails With Error: APP-AR-11526: ORA-04063: package body "APPS.ARP_PROCESS_RETURNS" has errors"?  Well looking at My Oracle Support document 2143556.1 it appears that there are mismatched versions causing this, and the required patches are listed in the document!

Monday, June 6, 2016

Presenting again!! OAUG Connection Point - AppsTech 2016

Hi everybody!!  Have you been wondering what I have been up to lately?  Well, the cat is out of the bag now with the presenter list for the OAUG Connection Point - AppsTech 2016 conference now online and my brand new presentation "R12: Reducing the data footprint of Oracle E-Business Suite" is listed!!  This is a great honor as this was by invite only, and this project is the one I alluded too earlier in the year in my Happy New Years post which I have been doing work on for quite some time but now I feel confident that I have enough material for a new presentation!  Do not miss this opportunity to learn from a lot of experts in application technology by registering today!!

Monday, May 23, 2016

JDBC connection throws ORA-01489 error when querying

Even though article "ORA-01489 When Running Query" in My Oracle Support document 2141406.1 is about JDBC, the underlying issue is likely one you could see outside of a JDBC environment so take a moment to read up on this error and find out why it is happening!