ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F1D2E3C4B5A697081A2B3C4D5E6F7081Y select null action_, null status_, null message_, null request_id_, null modified_columns_, fmv.user_menu_name, fmv.menu_name, fmv.description menu_description, xxen_util.meaning(fmv.type,'MENU_TYPE',0) type, fme.entry_sequence, fmet.prompt, fmv2.user_menu_name sub_menu, fffv.user_function_name function_name, fmet.description entry_description, xxen_util.meaning(fme.grant_flag,'YES_NO',0) grant_flag, to_char(null) delete_record, row_number() over (order by fmv.menu_name, fme.entry_sequence) upload_row from fnd_menus_vl fmv, fnd_menu_entries fme, fnd_menu_entries_tl fmet, fnd_menus_vl fmv2, fnd_form_functions_vl fffv where 1=1 and fmv.menu_id=fme.menu_id and fme.menu_id=fmet.menu_id and fme.entry_sequence=fmet.entry_sequence and fmet.language=userenv('lang') and fme.sub_menu_id=fmv2.menu_id(+) and fme.function_id=fffv.function_id(+) Wrapped the Success SQL driving tables in an inline view, so that the result report renders on Oracle Database 11g, where an outer joined table may reference at most one other table. Added the missing upload_row column, to retain the uploaded row order in the result U A xxen_fnd_upload.menu_entry US FND Menu Entry Upload Upload to create, update and delete menu entries in FND Menus. Useful for adding entries to existing menus, e.g. during Supply Chain Hub installation. Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can enter new menu entries. Create, Update -------------- Downloads existing menu entries matching the Menu Name filter for review and update. New rows can be added to create additional entries in the same upload. Fields ====== - User Menu Name: Display-only. Shows the translatable menu name. - Menu Name: Required. The internal menu name (e.g. INV_NAVIGATE). - Entry Sequence: The sequence number for the entry within the menu. Auto-assigned if not provided for new entries. - Prompt: The display text shown in the menu for this entry. - Entry Description: Optional description of the menu entry. - Sub Menu: The sub-menu to navigate to. Either Sub Menu or Function Name must be specified. - Function Name: The form function to launch. Either Sub Menu or Function Name must be specified. - Grant Flag: Y (default) = entry is grantable via security, N = not grantable. - Delete Record: Set to Y to delete an existing menu entry. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update 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 Y US Upload Mode 2 20 1=1 fmv.user_menu_name=:user_menu_name LOV custom Y select fmv.user_menu_name value, fmv.menu_name description from fnd_menus_vl fmv where fmv.user_menu_name is not null order by fmv.user_menu_name US User Menu Name 3 30 1=1 fmv.menu_name=:menu_name LOV custom Y select fm.menu_name value, fmt.user_menu_name description from fnd_menus fm, fnd_menus_tl fmt where fm.menu_id=fmt.menu_id and fmt.language=userenv('lang') order by fm.menu_name US Menu Name 4 40 1=1 fffv.function_name=:function_name LOV FND Function Name 8E2FF36EDEBB79D2E0530100007F1FF2 Y select fffv.function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.function_name US Function Name 5 50 1=1 fffv.user_function_name=:user_function_name LOV FND User Function Name 8E2FF36EDE8A79D2E0530100007F1FF2 select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ','')||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.user_function_name US User Function Name 6 60 1=1 exists (select null from fnd_responsibility_vl frv where frv.menu_id=fmv.menu_id and frv.responsibility_name=:responsibility_name) LOV custom Y select frv.responsibility_name value, fa.application_short_name description from fnd_responsibility_vl frv, fnd_application fa where frv.application_id=fa.application_id order by frv.responsibility_name US Responsibility 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 USER_MENU_NAME LOV custom varchar2 80 Y select fmv.user_menu_name value, fmv.menu_name description from fnd_menus_vl fmv where fmv.user_menu_name is not null order by fmv.user_menu_name select fmv.user_menu_name from fnd_menus_vl fmv where fmv.menu_name=:$column$.menu_name Y 7 MENU_NAME LOV custom varchar2 30 Y select fm.menu_id id, fm.menu_name value, fmt.user_menu_name description from fnd_menus fm, fnd_menus_tl fmt where fm.menu_id=fmt.menu_id and fmt.language=userenv('lang') order by fm.menu_name select fmv.menu_name from fnd_menus_vl fmv where fmv.user_menu_name=:$column$.user_menu_name Y 8 MENU_DESCRIPTION Char varchar2 240 select fmv.description from fnd_menus_vl fmv where fmv.menu_name=:$column$.menu_name 9 TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='MENU_TYPE' and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning select xxen_util.meaning(fm.type,'MENU_TYPE',0) from fnd_menus fm where fm.menu_name=:$column$.menu_name 10 ENTRY_SEQUENCE Number number select ceil(nvl(max(fme.entry_sequence),0)/10)*10+10 from fnd_menus fm, fnd_menu_entries fme where fm.menu_name=:$column$.menu_name and fm.menu_id=fme.menu_id 11 PROMPT Char varchar2 60 12 SUB_MENU LOV custom varchar2 80 Y select fm.menu_id id, fmt.user_menu_name value, fm.menu_name description from fnd_menus fm, fnd_menus_tl fmt where fm.menu_id=fmt.menu_id and fmt.language=userenv('lang') order by fmt.user_menu_name 13 FUNCTION_NAME LOV custom varchar2 80 Y select fffv.function_id id, fffv.user_function_name value, fffv.function_name description from fnd_form_functions_vl fffv order by fffv.user_function_name 14 ENTRY_DESCRIPTION Char varchar2 240 15 GRANT_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning('Y','YES_NO',0) 16 DELETE_RECORD LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 17 UPLOAD_ROW Number number Y U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_menu_id in Number MENU_NAME U 5 p_entry_sequence in Number ENTRY_SEQUENCE U 6 p_sub_menu_id in Number SUB_MENU U 7 p_function_id in Number FUNCTION_NAME U 8 p_prompt in Char PROMPT U 9 p_description in Char ENTRY_DESCRIPTION U 10 p_grant_flag in Char GRANT_FLAG U 11 p_delete_record in Char DELETE_RECORD Error SQL Order By upload_row, menu_name, entry_sequence Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.user_menu_name, xu.menu_name, xu.menu_description, xu.type, nvl(fme.entry_sequence,xu.entry_sequence) entry_sequence, nvl(fmet.prompt,xu.prompt) prompt, nvl(fmv2.user_menu_name,xu.sub_menu) sub_menu, nvl(fffv.user_function_name,xu.function_name) function_name, nvl(fmet.description,xu.entry_description) entry_description, nvl(xxen_util.meaning(fme.grant_flag,'YES_NO',0),xu.grant_flag) grant_flag, to_char(null) delete_record, to_number(xu.upload_row) upload_row from ( select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, fmv.user_menu_name, fmv.menu_name, fmv.description menu_description, xxen_util.meaning(fmv.type,'MENU_TYPE',0) type, to_number(xu.entry_sequence) entry_sequence, xu.prompt, xu.sub_menu, xu.function_name, xu.entry_description, xu.grant_flag, xu.upload_row, fmv.menu_id from xxen_fnd_menu_entry_upl_1137_u xu, fnd_menus_vl fmv where xu.status_code_='S' and xu.menu_name=fmv.menu_name ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped fnd_menu_entries fme, fnd_menu_entries_tl fmet, fnd_menus_vl fmv2, fnd_form_functions_vl fffv where xu.menu_id=fme.menu_id(+) and xu.entry_sequence=fme.entry_sequence(+) and xu.menu_id=fmet.menu_id(+) and xu.entry_sequence=fmet.entry_sequence(+) and fmet.language(+)=userenv('lang') and fme.sub_menu_id=fmv2.menu_id(+) and fme.function_id=fffv.function_id(+)