What's #OnTapToday
Using Shell Scripts as Concurrent Programs in EBS Recently, I started looking at way to address a scheduling problem when moving files associated with our business partners. We currently have a three step process: Schedule a Concurrent Program to produce a file Set up a cronjob to schedule a shell script to move and archive …
All good things must come to an end. It has been a long run with plenty of ups and downs. Getting Discoverer rolled out was one of my first tasks as I embarked upon my +Oracle E-Business Suite journey. Alas, we are saying our final goodbyes to Discoverer. This however opens new doors to address our reporting …
Whenever we talk about Date Tracking in EBS, we always refer to the effective_start_date and effective_end_date fields. Does code like this look familiar? SELECT * FROM per_all_people_f papf WHERE sysdate between papf.effective_start_date and papf.effective_end_date While this great for making sure you have the record on the date you are looking for, I find it to …
If you follow me on LinkedIn, I recently posted this: I did this because I found myself guilty doing that very thing. Wanting to do something the way it has always been done. It would have been easy. We had all the scripts and processes worked out. It was a no brainer. Our vendor however, …
To my social media friends and family. I am posting a letter from my friend Craig and if you are a fan of Jazz music, please support him at #WCLK Radio. To all my friends and family, Once again, I’m channeling my inner do-gooder as well as my radio personality. This Wednesday, March 26th, I …
A little while back, there was some concern that employees were being terminated in #Oracle E-Business Suite, but there was no process to ensure that those former employees couldn’t log back into EBS. This particular environment did not leverage any SSO technologies to manage user access, so each System Administrator was responsible for managing that …
You’ve probably heard me mention that I don’t like for my users to be my “system unavailable” alerts. I want to know as soon as, if not before, they do. The challenge is how to monitor these service states (Discoverer, Hyperion, Informatica, and Glassfish) on Windows boxes in the absence of some tool I have …
I was in the AT&T store recently helping my dad pick out a new iPhone when I came across the AT&T Wireless Home Phone system. It’s that little box right with the antennae (obviously I got one). Pros: it’s portable (I can take this device with me and connect to any regular phone), it can …
I’m in an environment where our 11i version of EBS (I know we need to upgrade) still requires JRE 1.6 to open Oracle Forms. Being an SQL Developer fan (listen to my podcast here), I decided to download and install SQL Dev 4.0. Anyone that’s been following this knows that the latest release requires JDK …
I’m playing around with Oracle’s SQL Developer 4 EA3 and Database 12c. Using SQL Dev, I quickly created a Pluggable Database (PDB). I try to open it, and I get this (ORA-01033). Then I remember reading that the Pluggable Databases don’t open automatically when the database services are started. Well that sucks because now I …
