ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 361E1A54C978D0F4E0630100007FEFB7 Blitz Upload Action Y select xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual union all select xxen_upload.action_meaning(xxen_upload.action_delete) value, null description from dual US 0EF78F69BCED104AE0630100007F95B0 select null action_, null status_, null message_, null modified_columns_, xue.rowid row_id_, xue.id, xue.name, xue.date_of_birth, xue.created_by, xue.creation_date, to_number(null) last_updated_by, to_date(null) last_update_date from xxen_upload_example xue where 1=1 Y U I xxen_upload_example US Blitz Upload Example (Interface Table) Sample upload to be used as a template by copying (Tools>Copy Report) to create new uploads using Interface Table. Enginatics Upload 1=1 1 10 1=1 xue.name=:name LOV custom 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 Name 1 ACTION_ LOV varchar2 Blitz Upload Action 361E1A54C978D0F4E0630100007FEFB7 Y select xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual union all select xxen_upload.action_meaning(xxen_upload.action_delete) value, null description from dual 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ROW_ID_ Rowid rowid Y 6 ID Number number Y 7 NAME LOV custom varchar2 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 Y 8 DATE_OF_BIRTH Date date Y 9 CREATED_BY Number number fnd_global.user_id Y 10 CREATION_DATE DateTime date sysdate Y 11 LAST_UPDATED_BY Number number fnd_global.user_id Y 12 LAST_UPDATE_DATE DateTime date sysdate Y U 1 id Number ID U 2 name Char NAME U 3 date_of_birth Date DATE_OF_BIRTH U 4 created_by Number CREATED_BY U 5 creation_date Date CREATION_DATE U 6 last_updated_by Number LAST_UPDATED_BY U 7 last_update_date Date LAST_UPDATE_DATE Error SQL Order By id Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_id_, nvl(xue.id,xu.id), nvl(xue.name,xu.name) name, nvl(xue.date_of_birth,xu.date_of_birth) date_of_birth, nvl(xue.created_by,xu.created_by) created_by, nvl(xue.creation_date,xu.creation_date) creation_date, to_number(null) last_updated_by, to_date(null) last_update_date from xxen_blitz_upload_examp_3434_u xu, xxen_upload_example xue where xue.rowid(+)=xu.row_id_ and xu.status_code_=xxen_upload.status_success