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 11.5.10.2 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!

Sunday, May 22, 2016

Weekend Learning: Configuring the Workflow Mailer for a Proxy Server

On Oracle EBS R12.1.3 you can follow the MOS document "How To Configure the Mailer to Connect To a Proxy Server" via article ID 2139133.1 and even if you do not plan on changing your configuration you may want to see what is required.  This article even has reference to the additional step required if you have moved on to R12.2 and want to do this!

Saturday, May 21, 2016

Weekend Learning: Transparent Data Encryption and Disaster Recovery

Want to learn more about Transparent Data Encryption?  How about what you need to know if you are using it in a Disaster Recovery situation?  Look no further than Lukasz Feldman's post on LinkedIn!

Thursday, May 19, 2016

Corruption in TEMP tablespace on 11.2.0.4 RAC system

There is a bug where if parallelism is turned on you could encounter the scenario described in "ORA-01578 in temp tablespace on RAC" from My Oracle Support document ID 2140124.1 across the nodes so really your only options are to turn parallelism off entirely!

Wednesday, May 18, 2016

11i Assets: Rolling back a journal entry fails due to batch status

If you are still on 11.5.9 or even 11.5.10.2 you will want to read the MOS note "Rollback Journal Entries Fails with Journal Entry Status Message" from article ID 452583.1 to learn why you cannot roll the journal entry back and the simple action you can take to get around this error message.

Tuesday, May 17, 2016

12c: KGLH0 process is causing Shared Pool ORA-04031 errors and latch contention

Are you looking to upgrade your Oracle database to 12.1.0.2 soon?  You might want to read "Bug 20370037 - Shared Pool from KGLH0 constantly growing causing ORA-04031 and Latch contention" from MOS note 2119923.1 because there seems to be several well known bugs with the KGLH0 process and this document has steps for different ways to mitigate this.  What does that mean?  If there are a lot of ways to encounter this in the system, then you need to prepare for encountering it so deploy the upgrade in QA and stress test to see if you run into this!!

Monday, May 16, 2016

R12.1.3 Payables: Invoice Validation program has performance issue

For the article "R12: AP: Invoice Validation program (APPRVL): Performance Issue - Insufficient Parameters" on My Oracle Support via document ID 2138625.1 you need to read up on the attached bug as well since it appears this dynamic query is actually being designed to run for an excessive amount of time if you do not provide an invoice date range.  That means that just entering an Operating Unit parameter does not actually limit the query as much as you would think, and Oracle Development has closed the bug as "not a bug" even though it really sounds like a bug!

Friday, May 13, 2016

Hyperion Essbase: Setup for automatically disconnecting users

Sometimes I post about things for your toolbox, and other times I post about investigating your own setup; and sometimes I post something from both columns like tonight!  Do you know how long users can be connected to your Essbase server?  If you read the MOS article "Specify when Users are Automatically Disconnected from an Essbase Server" from note 1054448.1 you will AND you will learn how to tell when running with Shared Services too!

Thursday, May 12, 2016

R12.2 Procurement: How to replace seeded FAQ

Check out MOS document ID 2132795.1 for "How can we replace seeded FAQs in iProcurement home page in Purchasing News Section with Business specific FAQs." for the official Oracle documentation on how to customize the PORFAQSS.htm file to fit your needs!