Script to set Profile Value at Responsibility level from backend

declare 
   v_check            boolean;
   v_profile_name1 varchar2(240) := 'MO: Operating Unit';
   v_value1          varchar2(240) := '111'; --select ORGANIZATION_ID from hr_operating_units where name ='XXXX US OU'
   v_profile1           varchar2(240);
   
   v_resp_name    varchar2(240)   := 'XXXX US OM Super User';
   v_resp_id      number;
   v_resp_app_id number;
begin 

    select profile_option_name
    into v_profile1
    from fnd_profile_options_tl
    where 1=1
    and user_profile_option_name = v_profile_name1 ;
  
    select responsibility_id      
        , application_id   
    into v_resp_id      
        , v_resp_app_id   
    from fnd_responsibility_tl  
    where responsibility_name = v_resp_name ;

     
v_check := fnd_profile.save( x_name => v_profile1   --profile_option_name          
, x_value => v_value1 --profile_option_value
                                , x_level_name => 'RESP'               
                                , x_level_value => v_resp_id             
                                , x_level_value_app_id => v_resp_app_id) ; 


if v_check then
dbms_output.put_line('Profile '||v_profile_name1||' updated with '||v_value1);
commit;
else
dbms_output.put_line('Error while updating Profile '||v_profile_name1||' with value '||v_value1);
end if;

exception
when others then
      dbms_output.put_line('Error: '||sqlerrm);
end;
/

FNDLOAD to Download and Upload XML Data Definition and Template

Download Script for Data Definition and Template
-------------------------------------------------------------
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct SUBS_QUOTE_RPT_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXSSS' DATA_SOURCE_CODE='SUBS_QUOTE_RPT'

Upload Script for Data Definition and Template
-----------------------------------------------------------
FNDLOAD apps/<pwd> 0 Y UPLOAD ${XDO_TOP}/patch/115/import/xdotmpl.lct SUBS_QUOTE_RPT_DD.ldt

DATA_TEMPLATE (Data Source .xml file)
--------------------------------------------------------------

Download
--------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -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
-------------
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -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 -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME



RTF TEMPLATE (Report Layout .rtf file)
----------------------------------------------------------

Download
-------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -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 US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME


Upload
-------------
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME

How to use Division formula in rtf template XML Publisher Report

By using <?xdofx: CS_AMOUNT div CS_QUANTITY?>  in form field help text.

How to display Sequence number in xml publisher?

By using the <?position()?> in form field help text.

It will display the number from 1.