DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, October 28, 2014

Oracle Application User(s) List With Age Threshold

The Below script will List the Oracle Application users with the specified age limit


select papf.employee_number,papf.full_name, papf.date_of_birth
from per_all_people_f papf,fnd_user fu
where papf.person_id=fu.employee_id 
and substr(papf.date_of_birth,8) <= 56  --year (2014-58=56)
--Here the user with the birth year less than or equal to 56 will be listed
and fu.END_DATE is NULL
--Specify whether to list end dated user or active users
and trunc(sysdate) between papf.effective_start_date and 
papf.effective_end_date order by DATE_OF_BIRTH



For clear view use the query in Toad

5 comments:

murali karthik said...

Hi friends, This is Murali from Chennai. I am a technology freak. Your technical information is really useful for me. Keep update your blog.
Regards..
Oracle Course in Chennai

Steve Hawks said...

There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this. FITA chennai reviews

jhansi joe said...

This technical post helps me to improve my skills set, thanks for this wonder article I expect your upcoming blog, so keep sharing.
Regards,
cognos Training in Chennai|cognos Training Chennai|cognos Training

data scientist training in hyderabad said...

Data Scientist Training in Hyderabad Ameerpet Introduction to our data science class helps in surveying the foundational topics, in present data science. data scientist training in hyderabad

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.