ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 3C7A91E8D4B2470FA6E15C83B90D2F44Y select null action_, null status_, null message_, null modified_columns_, xrc.column_name, xrc.number_format, flv.description language, xrct.translation, xxen_util.user_name(xrct.created_by) created_by, xxen_util.client_time(xrct.creation_date) creation_date, xxen_util.user_name(xrct.last_updated_by) last_updated_by, xxen_util.client_time(xrct.last_update_date) last_update_date, null delete_, null upload_row from fnd_languages_vl flv, xxen_report_columns xrc, (select xrct.* from xxen_report_columns_tl xrct where :p_upload_mode<>xxen_upload.action_create) xrct where 1=1 and flv.language_code=:language_code and nvl(:p_create_empty_file,'x')<>'Y' and xrc.column_id=xrct.column_id(+) and flv.language_code=xrct.language(+) Initial version of the Blitz Report Column Translation Upload. U A xxen_report_upload.create_update_col_translation US Blitz Report Column Translation Upload Upload to maintain the Blitz Report column translations and number formats, which control how a report column heading is displayed in each language and how its values are formatted in Excel. Translations are matched to reports by column name at run time, so one row here applies to every report producing a column of that name. The Language parameter is required, because a single language already covers around twenty thousand column names. Run modes: - Create, Update: downloads the existing translations of the chosen language for editing. Set Delete to Yes to remove a translation. - Create with 'Missing Translations Only' = Yes: downloads only the column names that have no translation yet in the chosen language, ready to be filled in. - Create with 'Create Empty File' = Yes: opens an empty file to enter new column names. The Number Format is an Excel format mask held once per column name, not per language. It repeats on every language row of the same column and is only written when it differs from the stored value, so editing it on any one row is enough. Enginatics Upload 1=1 :language_code :p_create_empty_file :p_upload_mode 1 10 :p_upload_mode LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 :language_code LOV custom Y select flv.language_code id, flv.description value, decode(flv.installed_flag,'B','Base language','I','Installed') description from fnd_languages_vl flv order by decode(flv.installed_flag,'B',1,'I',2,3), flv.description select flv.description from fnd_languages_vl flv where flv.language_code=userenv('lang') Y US Language 3 30 :p_create_empty_file LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.upload_mode=xxen_upload.action_create US Create Empty File 4 40 1=1 xrct.translation is null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Missing Translations Only 5 50 1=1 xrc.column_name like :column_name_starts_with||'%' LOV custom Y select xrc.column_name value, xrc.number_format description from xxen_report_columns xrc order by xrc.column_name US Column Name starts with 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 COLUMN_NAME LOV custom varchar2 251 Y select xrc.column_name value, xrc.number_format description from xxen_report_columns xrc order by xrc.column_name Y 6 NUMBER_FORMAT Char varchar2 80 select xrc.number_format from xxen_report_columns xrc where xrc.column_name=:$column$.column_name select 'Excel number format mask for this column, for example #,##0.00 or dd-mon-yyyy. Held once per column name and shared by all languages.' from dual 7 LANGUAGE LOV custom varchar2 80 Y select flv.language_code id, flv.description value, decode(flv.installed_flag,'B','Base language','I','Installed') description from fnd_languages_vl flv order by decode(flv.installed_flag,'B',1,'I',2,3), flv.description select flv.description from fnd_languages_vl flv where flv.language_code=:$flex$.Language Y 8 TRANSLATION Char varchar2 753 9 CREATED_BY Char varchar2 Y 10 CREATION_DATE Date date Y 11 LAST_UPDATED_BY Char varchar2 Y 12 LAST_UPDATE_DATE Date date Y 13 DELETE_ LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 14 UPLOAD_ROW Char varchar2 Y U 1 status_ out Char STATUS_CODE_ U 2 message_ out Char MESSAGE_ U 3 p_column_name in Char COLUMN_NAME U 4 p_number_format in Char NUMBER_FORMAT U 5 p_language_code in Char LANGUAGE U 6 p_translation in Char TRANSLATION U 7 p_delete in Char DELETE_ Error SQL Order By upload_row, column_name, language Success SQL select null action_, xu.status_, xu.message_, xu.modified_columns_, nvl(xrc.column_name,xu.column_name) column_name, nvl(xrc.number_format,xu.number_format) number_format, nvl(flv.description,xu.language) language, nvl(xrct.translation,xu.translation) translation, xxen_util.user_name(xrct.created_by) created_by, xxen_util.client_time(xrct.creation_date) creation_date, xxen_util.user_name(xrct.last_updated_by) last_updated_by, xxen_util.client_time(xrct.last_update_date) last_update_date, xu.delete_, xu.upload_row from xxen_blitz_report_colum_9216_u xu, fnd_languages_vl flv, xxen_report_columns xrc, xxen_report_columns_tl xrct where xu.status_code_=xxen_upload.status_success and xu.language=flv.description(+) and xu.column_name=xrc.column_name(+) and xrc.column_id=xrct.column_id(+) and flv.language_code=xrct.language(+)