ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 2CCA4AA59B94078CE06362FB09057337 select null action_, null status_, null message_, xus.id, xus.name, xus.date_of_birth from xxen_upload_example xus where 1=1 Y U A xxen_upload_example_api.create_update_record US Test Upload 010325 1=1 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 ID Number number Y Y 5 NAME LOV varchar2 FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name Test 6 DATE_OF_BIRTH Date date sysdate Y U 1 p_id in Number ID U 2 p_name in Char NAME U 3 p_date_of_birth in Date DATE_OF_BIRTH U 4 action_ in Char ACTION_CODE_ U 5 status_ out Char STATUS_CODE_ U 6 message_ out Char MESSAGE_ Error SQL select xxen_upload.action_meaning(xur.action_) action_, xxen_upload.status_meaning(xur.status_) status_, xur.message_, xur.id, xur.name, xur.date_of_birth from xxen_test_upload_010325_7432_u xur where xur.status_=xxen_upload.status_error Order By id Success SQL select xxen_upload.action_meaning(xxen_upload.action_processed) action_, xxen_upload.status_meaning(xxen_upload.status_success) action_, xur.message_, xus.id, xus.name, xus.date_of_birth from xxen_test_upload_010325_7432_u xur, xxen_upload_example xus where xus.id=xur.id and xur.status_=xxen_upload.status_success