KScope14 was hosted in Seattle, the City of Music, and what an experience it was. For six days, Oracle experts and professionals descended upon the City to share with and learn from each other. We kicked off on Saturday with a Community Service event event with the Nature Consortium. After being stuck and scratched by …
Category: Oracle
Let The Games Begin! – #Kscope14
We kicked off KScope 14 with a great Community Service event with the Nature Consortium. If you saw my tweet earlier, we HANDLED that Himalayan Blackberry. I’ve got some of that stuff or a very close relative growing in my back yard, so I felt really good pulling that stuff out. Not to be beat …
Using Shell Scripts as Concurrent Programs in EBS
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 …
Oracle EBS: Life Events, Life_Event_Occurred_Date (lf_evt_ocrd_dt) and last_update_date
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 …
Auto End Date Separated Employees
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 …
Monitoring Windows Services – The quick and dirty way
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 …
Use Start-up Script to Modify State of your Pluggable Database to Open Read Write in SQL Developer 4.0 EA3 (ORA-01033)
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 …
Virtual Columns, Table Export, and Forums: A Love Hate Relationship (SQL Error: ORA-54013: INSERT operation disallowed on virtual columns)
Ok, so kind of a weird title, but let me explain. I believe that when you post to a forum, you are either seeking knowledge or sharing it. I was on the SQLDev forum a few days ago, and someone posted what can be perceived as an error when exporting a table. Here is what …
Hyperion Implementation is Difficult
You would not believe the number of times I’ve heard that. Every conference and product demo I went to. This was a common sentiment. To be honest, it is, but not impossible. By following some simple yet important considerations, you can have a successful Hyperion implementation. Define Requirements Why are we doing this and what …
Service: ODTUG Board of Directors (#ODTUG) Voting 10/9 – 10/29
Greetings ODTUG Family: I wanted to officially wait until October before putting this out. A great thing happened at Oracle Open World 2013. I was nominated for the Board of Directors of ODTUG. This is a great chance to serve, and I am humbled yet excited about the opportunity, therefore I am asking for your …
