Button on tool bar to submit concurrent program on tool bar through form personalization

Button on tool bar to submit concurrent program on tool bar through form personalization

To verify Personalization Rules along with Scopes
Seq	Description	Level	Enabled	Trigger Event
20	To Launch Receipt Print Programe - 1	Form	Y	WHEN-NEW-FORM-INSTANCE
25	TO Launch Receipt Print Programe - 2	Form	Y	SPECIAL45
Trigger Object	Condition	Processing Mode	Context Level	Context Value
		Both	User	2,836
		Both	User	2,836

To verify Personalization Rules along with Actions
Seq	Description	Level	Enabled	Trigger Event	Trigger Object	Condition	Processing Mode
20	To Launch Receipt Print Programe - 1	Form	Y	WHEN-NEW-FORM-INSTANCE			Both
25	TO Launch Receipt Print Programe - 2	Form	Y	SPECIAL45			Both
Action Seq	Action Type	Action Description	Action Language	Action Enabled	PROPERTY_VALUE	ARGUMENT_TYPE	TARGET_OBJECT
10	S		*	Y		C
10	B		*	Y		C	RGW_FOLDER.M_TYPE
OBJECT_TYPE	FOLDER_PROMPT_BLOCK	MESSAGE_TYPE	MESSAGE_TEXT	BUILTIN_TYPE	BUILTIN_ARGUMENTS	PROPERTY_NAME	MENU_ENTRY
ITEM		S		C		1,550	SPECIAL45
ITEM		S		C	XXREP:XXMSRCTCL_M	1,550
MENU_LABEL	MENU_SEPERATOR	MENU_ENABLED_IN	MENU_ACTION	MENU_ARGUMENT_LONG	MENU_ARGUMENT_SHORT	ACTION_ID	REQUEST_APPLICATION_ID
To Submit Receipt Printing Programe	N				yellow_circle	95
	N					96

SELECT   ffcr.SEQUENCE "Seq", ffcr.description "Description",

--#########################################################

-- To verify Personalization Rules along with Scopes

--#########################################################    

     DECODE (ffcr.rule_type,

                  'F', 'Form',

                  'A', 'Function',

                  'Other'

                 ) "Level",

          ffcr.enabled "Enabled", ffcr.trigger_event "Trigger Event",

          ffcr.trigger_object "Trigger Object", ffcr.condition "Condition",

          DECODE (ffcr.fire_in_enter_query,

                  'Y', 'Both',

                  'N', 'Not in Enter-Query Mode',

                  'O', 'Only in Enter-Query Mode',

                  'Other'

                 ) "Processing Mode",

          DECODE (ffcs.level_id,

                  '10', 'Industry',

                  '20', 'Site',

                  '30', 'Responsibility',

                  '40', 'User',

                  'Other'

                 ) "Context Level",

          ffcs.level_value "Context Value"

     FROM apps.fnd_form_custom_rules ffcr, apps.fnd_form_custom_scopes ffcs

    WHERE 1 = 1

     --AND ffcr.function_name = 'ONT_OEXOEORD'

      AND ffcr.form_name = 'ARXRWMAI'

      AND ffcr.ID = ffcs.rule_id(+)

      AND  ffcr.SEQUENCE IN('20','25')

 ORDER BY ffcr.SEQUENCE, ffcs.level_id;

SELECT   ffcr.SEQUENCE "Seq", ffcr.description "Description",

--#########################################################

 -- To verify Personalization Rules along with Actions

--#########################################################       

 DECODE (ffcr.rule_type,

                  'F', 'Form',

                  'A', 'Function',

                  'Other'

                 ) "Level",

          ffcr.enabled "Enabled", ffcr.trigger_event "Trigger Event",

          ffcr.trigger_object "Trigger Object", ffcr.condition "Condition",

          DECODE (ffcr.fire_in_enter_query,

                  'Y', 'Both',

                  'N', 'Not in Enter-Query Mode',

                  'O', 'Only in Enter-Query Mode',

                  'Other'

                 ) "Processing Mode",

          ffca.SEQUENCE "Action Seq", ffca.action_type "Action Type",

          ffca.summary "Action Description", ffca.LANGUAGE "Action Language",

          ffca.enabled "Action Enabled", ffca.property_value,

          ffca.argument_type, ffca.target_object, ffca.object_type,

          ffca.folder_prompt_block, ffca.MESSAGE_TYPE, ffca.MESSAGE_TEXT,

          ffca.builtin_type, ffca.builtin_arguments, ffca.property_name,

          ffca.menu_entry, ffca.menu_label, ffca.menu_seperator,

          ffca.menu_enabled_in, ffca.menu_action, ffca.menu_argument_long,

          ffca.menu_argument_short, ffca.action_id,

          ffca.request_application_id

     FROM apps.fnd_form_custom_rules ffcr, apps.fnd_form_custom_actions ffca

    WHERE 1 = 1

    --and ffcr.function_name = 'ONT_OEXOEORD'

 AND ffcr.form_name = 'ARXRWMAI'

      AND ffcr.ID = ffca.rule_id(+)

      AND  ffcr.SEQUENCE IN('20','25')

 ORDER BY ffcr.SEQUENCE, ffca.SEQUENCE;

Script To List The Values Of A Profile Option At All Levels At User Level With All LAnguages

--Script To List The Values Of A Profile Option At All Levels At User Level With All LAnguages

SELECT fpo.profile_option_id, fpot.profile_option_name profile_short_name

, substr(fpot.user_profile_option_name,1,60) profile_name

, DECODE(fpov.level_id,10001,'site',10002,'Appl',10003,'Resp',10004,'User') profile_level

, substr(DECODE(fpov.level_id,10001,null, 10002,fa.application_short_name

,10003,fr.responsibility_name, 10004,fu.user_name),1,30) level_value

, fpov.profile_option_value profile_value

FROM fnd_profile_option_values fpov

, fnd_profile_options fpo

, fnd_profile_options_tl fpot

, fnd_application fa

, fnd_responsibility_tl fr

, fnd_user fu

WHERE

fpo.profile_option_name=fpot.profile_option_name

and fpo.profile_option_id = fpov.profile_option_id

and fa.application_id(+)=fpov.level_value

and fr.responsibility_id(+)=fpov.level_value

and fu.user_id(+)=fpov.level_value

AND fu.USER_NAME = UPPER(:P_USER_NAME) --'SANTOSH'; 'REYAZ' '

--and

--(fpo.profile_option_name like nvl('X',fpo.profile_option_name)

-- Not mandatory. Replace X with profile short name, ie 'ORG_ID'

--or fpot.user_profile_option_name like nvl('MO: Op%',fpot.user_profile_option_name))

-- Not mandatory. Replace Y with profile user name, ie 'MO: Op%'

-- How To Check If a Profile Option Is Set In Oracle Applications? (Doc ID 470102.1)

 SELECT   po.user_profile_option_name,

              po.profile_option_name "NAME" ,

              DECODE (TO_CHAR (pov.level_id), '10001', 'SITE' , '10002', 'APP', '10003', 'RESP', '10004', 'USER', '???') "LEV",

              DECODE (TO_CHAR (pov.level_id) , '10001', '', '10002', app.application_short_name , '10003', rsp.responsibility_key, '10004', usr.user_name, '???')  "CONTEXT",

              pov.profile_option_value "VALUE"

         FROM fnd_profile_options_vl po,

                  fnd_profile_option_values pov,

                  fnd_user usr,

                  fnd_application app,

                  fnd_responsibility rsp

      WHERE 1 = 1 -- (po.profile_option_name = upper('&profil_name'))

          AND pov.application_id = po.application_id

          AND pov.profile_option_id =   po.profile_option_id

          AND usr.user_id(+) = pov.level_value

          AND rsp.application_id(+) =  pov.level_value_application_id

          AND rsp.responsibility_id(+) = pov.level_value

          AND app.application_id(+)   = pov.level_value

ORDER BY "NAME", pov.level_id, "VALUE"

--How To Set A System Profile Value Without Logging In To The Applications (Doc ID 364503.1)