Category: EBS

APEX, DBA, dbaOnTap, dbcapoeira, E-Business Suite, EBS, OBIEE, ODI, Oracle, User Group

Georgia Oracle Users Group – Reboot

Looking for an Oracle User Group home in Atlanta? I want to re-introduce everyone to the Georgia Oracle Users Group (GaOUG).  For over 20 years, this group has been laser focused on supporting the DBA community in the metro Atlanta area by hosting monthly educational meetings where individuals, both members and non-members presented on topics of …

cool stuff, Database, EBS, EBS 11i, Oracle, Security

Data Security with VPD in Oracle EBS

Enhance data security by using VPD and EBS Profile Options to prevent viewing of sensitive data.  In this example we will look at blocking employee SSN or National Identifier, as they are called in EBS, in PER_ALL_PEOPLE_F .  As most people familiar with Oracle EBS know, there are a number of delivered views that have embedded security.  Take …

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

E-Business Suite, EBS, HCM, Hints and Tip, HRMS, Oracle, PLSQL, SQL

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 …

Database, DBA, dbcapoeira, EBS, Error, Hints and Tip, Hints and Tips, Java, JDK, JRE, SQLDev

Installing SQL Dev 4.0 (JRE 1.6 and JDK 1.7)

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 …

12C, BI, conference, Databases, dbcapoeira, EBS, oow13, Oracle, SQLDev, Troubleshooting

Oracle Open World 2013 – Wrap up (#OOW13)

So if you know anything about me, you will know that I am always amp’d up when it’s time for Oracle Open World.  This year was quite a different experience for me.  In previous years, I found myself running all across the Conference Complex attending session after session.  This year however, I took a different …

Discoverer, EBS, Oracle, Reporting

Discoverer – Complex Folders Part 2

A couple of days late, but here is the how to guide for creating Complex Folders in Discoverer.  This post assumes knowledge of the Discoverer Administrator Tool. First we need to add the desired folders to a Business Area and Join the folders on the appropriate columns: Once you have created the Join, you need …