FND User Upload

➜ Back to Library
Description
Categories: Enginatics, Upload
Repository: Github
Listing and updating all EBS users and their responsiblities
select
y.*
from
(
select
null action_,
null status_,
null message_,
fu.user_name,
null unencrypted_password,
fu.description,
papf.business_group,
papf.full_name person,
papf.employee_number,
papf.first_name,
papf.last_name,
papf.sex gender,
papf.date_of_birth date_of_birth,
fu.email_address,
fu.fax,
fu.start_date user_start_date,
fu.end_date user_end_date,
fu.last_logon_date last_logon_date,
xxen_util.user_name(fu.created_by) created_by,
xxen_util.client_time(fu.creation_date) user_creation_date,
xxen_util.user_name(fu.last_updated_by) user_last_updated_by,
xxen_util.client_time(fu.last_update_date) user_last_update_date,
frv.responsibility_name,
frv.application_name responsiblity_application,
frv.security_group_name,
frv.start_date responsiblity_start,
frv.end_date responsiblity_end,
frv.description assignment_description
from
fnd_user fu,
(select pbg.name business_group, papf.* from per_all_people_f papf, per_business_groups pbg where papf.business_group_id=pbg.business_group_id and nvl(papf.effective_end_date,sysdate)>=trunc(sysdate)) papf,
(
select
furgd.user_id,
frv.responsibility_name,
fa.application_short_name application_name,
fsg.security_group_key security_group_name,
furgd.start_date,
furgd.end_date,
furgd.description
from
fnd_responsibility_vl frv,
fnd_application fa,
fnd_security_groups fsg,
fnd_user_resp_groups_direct furgd
where
2=2 and
frv.application_id=fa.application_id and
frv.data_group_id=fsg.security_group_id and
frv.application_id=furgd.responsibility_application_id and
frv.responsibility_id=furgd.responsibility_id
) frv
where
1=1 and
fu.employee_id=papf.person_id(+) and
fu.user_id=frv.user_id(+)
&not_use_first_block
&report_table_select &report_table_name &report_table_where_clause
&processed_run
)y
order by
case when nvl(y.user_end_date,sysdate)>=trunc(sysdate) then 1 else 2 end,
to_date(y.user_creation_date) desc,
y.user_name
Parameter NameSQL textValidation
Upload Mode
:upload_mode like '%' || xxen_upload.action_update
LOV
User Name
fu.user_name=:user_name
LOV
Has Access to Responsibility
fu.user_id in (
select
furg.user_id
from
fnd_responsibility_vl frv,
fnd_user_resp_groups furg
where
frv.responsibility_name=:responsibility and
frv.responsibility_id=furg.responsibility_id and
frv.application_id=furg.responsibility_application_id
)
LOV
Has Access to Application
fu.user_id in (
select
furg.user_id
from
fnd_application_vl fav,
fnd_user_resp_groups furg
where
fav.application_name=:application and
fav.application_id=furg.responsibility_application_id
)
LOV
Active only
sysdate between fu.start_date and nvl(fu.end_date,sysdate)
LOV
Creation Date From
fu.creation_date>=:creation_date_from
Date
Creation Date To
fu.creation_date<:creation_date_to+1
Date
Created within days
fu.creation_date>=sysdate-:days
Number
Download
Related Blitz Reports
FND Responsibility Access 11i FND Responsibility Access Blitz Report Assignments and Responsibilities FND Responsibilities INV Item Upload INV Items PON Solicitation data template PER Person Synchronization INV Onhand Quantities
Blitz Report™