Find the URL of the Application in the database: Option 1:select HOME_URL from icx_parameters; Option 2: Select PROFILE_OPTION_VALUEFrom FND_PROFILE_OPTION_VALUESWHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME =’APPS_FRAMEWORK_AGENT’) AND LEVEL_VALUE=0;
What is Function? A function is a part of an application’s functionality that is registered under a unique name for the purpose of assigning it to, or excluding it from, a responsibility. What are the Function Types? There are two types of functions:a] Form (Form Function) A form function (form) invokes an Oracle Forms […]
Oracle Application has a file system as shown in the below picture for the APPL_TOP Directory. GL_TOP: (APPL_TOP/GL/11.5.0) is one of the Module Directory of Oracle Applications. It consists of a release directory (i.e. 11.5.0) under which Forms, Reports, BIN, LIB, SQL, etc.,Forms/US: Forms directory to store all .FMX (Compiled) Form files of a specific […]
SELECT DECODE (fpov.level_id, 10001, ‘Site’, 10002, ‘Appl’, 10003, ‘Resp’, 10004, ‘User’, ‘Unkown’ ) “Level”, DECODE (fpov.level_id, 10002, fa.application_name, 10003, fr.responsibility_name, 10004, fu.user_name, ‘-‘ ) “Location”, fpov.profile_option_value “Value” FROM apps.fnd_profile_option_values fpov, apps.fnd_profile_options fpo, apps.fnd_profile_options_tl fpot, apps.fnd_responsibility_tl fr, apps.fnd_user fu, apps.fnd_application_tl fa WHERE fpov.profile_option_id = fpo.profile_option_id AND fpo.profile_option_name = fpot.profile_option_name AND fpov.level_value = fr.responsibility_id(+) AND fpov.level_value = fu.user_id(+) […]
— To Check Value Sets (Table Type) SELECT * FROM apps.fnd_flex_validation_tables WHERE flex_value_set_id IN ( SELECT flex_value_set_id FROM apps.fnd_flex_value_sets WHERE flex_value_set_name = ‘<VALUE SET NAME>’) — To Check Value Sets (Independent) SELECT * FROM apps.fnd_flex_values WHERE flex_value_set_id IN ( SELECT flex_value_set_id FROM apps.fnd_flex_value_sets WHERE […]
Recent Comments