ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 424FC1B6E3CA06E8E0636DFB09057CCB select null action_, null status_, null message_, null modified_columns_, xue.id, xue.name, xue.date_of_birth from xxen_upload_example xue where 1=1 Y U A xxen_upload_example_api.create_update_record_no_params US Blitz Upload Example (API without parameters) Example upload, which can be used as a template by copying (Tools>Copy Report) to create new uploads using an API without parameters. This API will be called just once by the upload framework and all the uploaded records can be accessed within the API by selecting them from the Data View eg: select * from xxen_blitz_upload_examp_9718_u xu where xu.status_code_=xxen_upload.status_valid 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_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ID Number number Y 6 NAME LOV custom varchar2 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 Y 7 DATE_OF_BIRTH Date date Y Error SQL Order By id Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xue.id, xue.name, xue.date_of_birth from xxen_blitz_upload_examp_9718_u xu, xxen_upload_example xue where xue.id=xu.id and xu.status_code_=xxen_upload.status_success