Query to get all profile options which are recently changed.

--Query to get all profile options which are recently changed.
SELECT DISTINCT p.profile_option_name SHORT_NAME
      ,n.user_profile_option_name "PROFILE NAME"
      ,DECODE(v.level_id, 10001, 'Site Level',
              10002, 'Application Level',
              10003, 'Responsibility Level',
              10004, 'User Level',
              10005, 'Server Level',
              10007, 'SERVRESP',
              'UnDef') LEVEL_SET
      ,DECODE(TO_CHAR(v.level_id), '10001', '',
              '10002', app.application_short_name,
              '10003', rsp.responsibility_key,
              '10005', svr.node_name,
              '10006', org.name,
              '10004', usr.user_name,
              '10007', 'Serv/resp',
              'UnDef') "CONTEXT"
       ,v.profile_option_value VALUE
       ,v.LAST_UPDATE_DATE
   FROM fnd_profile_options p
       ,fnd_profile_option_values v
       ,fnd_profile_options_tl n
       ,fnd_application app
       ,fnd_responsibility rsp
       ,fnd_nodes svr
       ,hr_operating_units org
       ,fnd_user usr
  WHERE p.profile_option_id = v.profile_option_id (+)
    and p.profile_option_name = n.profile_option_name
    and usr.user_id (+) = v.level_value
    and rsp.application_id (+) = v.level_value_application_id
    and rsp.responsibility_id (+) = v.level_value
    and app.application_id (+) = v.level_value
    and svr.node_id (+) = v.level_value
    and org.organization_id (+) = v.level_value
    and v.LAST_UPDATE_DATE is not null
    --and upper(n.user_profile_option_name) like upper('BNE%')
    and trunc(v.LAST_UPDATE_DATE) between trunc(sysdate-10) AND trunc(sysdate)
 ORDER BY last_update_date desc
         ,short_name, level_set;

FNDLOAD LDT Script for Download and Upload.

FNDLOAD LDT Script for Download and Upload.

1. CONCURRENT PROGRAM.

--Download Script
 FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUSTAPP" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM";

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE;

2. DATA DEFINITION AND ASSOCIATED TEMPLATE.

--Download Script
 FNDLOAD apps/appspwd 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XX_CUSTOM_DD_CODE' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_CUSTOM_DT_CODE';

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD ${XDO_TOP}/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt;

3. DATA_TEMPLATE (Data Source .xml file)

--Download Script
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST='XX_HOST_NAME')(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME;

--Upload Script
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST='XX_HOST_NAME')(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME XXCUST -LOB_CODE XX_TEMPLATE -NLS_LANG en -TERRITORY 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME DATA_TEMPLATE_XXCUST_XXGL_XX_TEMPLATE.xml -CUSTOM_MODE FORCE -LOG_FILE $LOG_FILE_NAME;

4. RTF TEMPLATE (Report Layout .rtf file)

--Download Script
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST='XX_HOST_NAME')(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME;

--Upload Script
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST='XX_HOST_NAME')(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -APPS_SHORT_NAME XXCUST -LOB_CODE XX_TEMPLATE -LANGUAGE en -TERRITORY 00 -XDO_FILE_TYPE RTF -FILE_NAME TEMPLATE_SOURCE_XXCUST_XX_TEMPLATE_en.rtf -CUSTOM_MODE FORCE -LOG_FILE $LOG_FILE_NAME;

5. ALERTS.

--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - ALERT_NAME";

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE; 

6. VALUE SET.

 --Download Script
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX - Value_Set_Name";

--Upload Script
 $FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE; 

7. VALUE SET WITH VALUES.

 --Download Script
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="XX - Value_Set_Name";

--Upload Script
 $FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

 8. WebADI - Web Desktop Integrator.

 --Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR.ldt BNE_INTEGRATORS INTEGRATOR_ASN="XXCUST" INTEGRATOR_CODE="XX_INTEGRATOR_CODE";


--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE; 

9. FND MESSAGES.

--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="XX MESSAGE_NAME" ;


--Upload Script 
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE; 

10. PROFILE.

 --Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRFL.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST";

--Upload Script 
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRFL.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

11. LOOKUP.

--Download Script--
--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE";

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

12. REQUEST SET.

--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET.ldt REQ_SET REQUEST_SET_NAME='XX - REQUEST SET NAME';

--Upload Script
FNDLOAD apps/appspwd O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

 13. FORM FUNCTION.

 --Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt FUNCTION FUNCTION_NAME="XXFORM_FUNCTION_NAME";

--Upload Script 
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE; 

14. REQUEST GROUP

--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REQST_GRP.ldt REQUEST_GROUP REQUEST_GROUP_NAME="XX - Request Group Name" APPLICATION_SHORT_NAME="XXCUST"; 
 

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REQST_GRP.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE;

Function not available to this responsibility. Change responsibility or contact your System Administrator.

After every fresh clone of any Test/Development instance from Production instance, application team used to report that:

'Function not available to this responsibility. Change responsibility or contact your System Administrator.'  

error when they are trying to access custom form.

CAUSE:  There is missing the entry of CUSTOM_TOP in default.env file.

Solution:

1. Login to APPLMGR user to application Linux server.

 
[applmgr@TEST]$ sudo su – applmgr

2. Go to $INST_TOP/ora/10.1.2/forms/server directory.

 
[applmgr@TEST]$ cd $INST_TOP/ora/10.1.2/forms/server

3. Add the missing CUSTOM_TOP entry to default.env file.

 
XXCUSTOM_TOP=/U01/applmgr/r12/CUSTOM/XX_CUSTOM/12.0.0

4. Restart the middle tier services.

5. Retest the issue.