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 …
Category: EBS 11i
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 …
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 …
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 …
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, …
