Category: ACE

12cR2, ACE, Beginner Series, Database, DBA

Installing Oracle Database 12cR2 on Linux 7.3

What do you do when Oracle releases the long awaited 12cR2 version of the database? You download it and install it. So let’s get started. Visit the Oracle Download site and download the version 12cR2 of the database. This time it’s just a single zip file. So grab that and unzip it in a directory …

ACE, Opinion Piece, Oracle

Oracle ACE: What’s In It for Me?

Earlier this year I was honored by being awarded the Oracle ACE Associate designation.  After almost a year, I continue to get similar questions from coworkers, friends, and members of the public and private sector. “What’s do you get for being an ACE?”  My response is simple.  I get recognized by the community for doing …

ACE, Conferences, Open World 2014, Oracle, technology, User Group

Oracle Open World 2014 in Review

Oracle Open World 2014 in Review Oracle Open World was such a blur. This conference completely shuts down a section of San Francisco to the residents as 60,000+ attendees descend upon the Moscone Center.  The logistics and planning behind this event are phenomenal.  Hey Oracle, can you offer a behind the scenes pass next year?  …

#odtug, ACE, kscope14

Get Involved. Network. Share. Who knows where it will take you

My favorite Oracle conference starts soon. This year, KScope14 is about much more than going to all the great sessions presented by a phenomenal group of experts.  This time it’s about involvement.  What could I do over the course of the year to contribute to an organization that has been instrumental in the development of …

#odtug, ACE, ACEA, concurrent program, E-Business Suite, EBS, EBS 11i, Hints and Tip, Hints and Tips, hobby, Implementation, LINUX, Oracle, request set, Shell Script, support, technology, UNIX

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 …

ACE, ACEA, BI, BI Publisher, Database, Discoverer, E-Business Suite, EBS, EBS 11i, EBS XML, Oracle Report, Reporting, SQL, SQLDev, technology, XML, XML Publisher

XML/BI Publisher in Oracle EBS – Bye Bye Discoverer

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 …

ACE, Alerts, Date Tracking, EBS, EBS 11i, HRMS, Life Event, Oracle

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 …

accepting change, ACE, ACEA, EBS, EBS 11i, EBS XML, EBS XML gateway., gateway, XML, xml gateway

Oracle XML Gateway: How I was Forced to Eat Ice Cream

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, …