Delete XML Publisher Records of a Concurrent

SELECT *
  FROM XDO_DS_DEFINITIONS_B
WHERE DATA_SOURCE_CODE = 'XX_DATA_DEF_CODE';

SELECT *
  FROM XDO_DS_DEFINITIONS_TL
WHERE DATA_SOURCE_CODE = 'XX_DATA_DEF_CODE';

SELECT *
  FROM XDO_LOBS
WHERE LOB_CODE = 'XX_DATA_DEF_CODE';

SELECT *
  FROM XDO_CONFIG_VALUES
WHERE DATA_SOURCE_CODE = 'XX_DATA_DEF_CODE';

Delete the Data Definitions:

-- API to delete Data Definition from XDO_DS_DEFINITIONS_B  and XDO_DS_DEFINITIONS_TL table
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW (,);
COMMIT;
END;

-- Delete Data Templates, xml schema etc. from XDO_LOBS table (There is no API)
DELETE FROM XDO_LOBS
         WHERE LOB_CODE =
            AND APPLICATION_SHORT_NAME =
            AND LOB_TYPE IN
                   ('XML_SCHEMA',
                    'DATA_TEMPLATE',
                    'XML_SAMPLE',
                    'BURSTING_FILE');

-- Delete from XDO_CONFIG_VALUES (if required)
DELETE FROM XDO_CONFIG_VALUES
      WHERE APPLICATION_SHORT_NAME =
            AND DATA_SOURCE_CODE = ;

Queries for the Templates:

SELECT *
  FROM XDO_TEMPLATES_B
WHERE TEMPLATE_CODE = 'XX_TEMPLATE_CODE';

SELECT *
  FROM XDO_TEMPLATES_TL
WHERE TEMPLATE_CODE = 'XX_TEMPLATE_CODE';

SELECT *
  FROM XDO_LOBS
WHERE LOB_CODE = 'XX_TEMPLATE_CODE';

SELECT *
  FROM XDO_CONFIG_VALUES
WHERE TEMPLATE_CODE = 'XX_TEMPLATE_CODE';

Delete the templates:

-- API to delete Data Definition from XDO_TEMPLATES_B and XDO_TEMPLATES_TL table
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW (, );
COMMIT;
END;

-- Delete the Templates from XDO_LOBS table (There is no API)
DELETE FROM XDO_LOBS
      WHERE     LOB_CODE =
            AND APPLICATION_SHORT_NAME =
            AND LOB_TYPE IN ('TEMPLATE_SOURCE', 'TEMPLATE');

-- Delete from XDO_CONFIG_VALUES (if required)
DELETE FROM XDO_CONFIG_VALUES
      WHERE     APPLICATION_SHORT_NAME =
            AND TEMPLATE_CODE =
            AND DATA_SOURCE_CODE = ;

XML report template migration from one instance to another

RTF template migration from A instance to B instance.
Here XX is the custom application

---template definition download command
SELECT 'FNDLOAD apps/app5 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ' ||
       template_code || '.ldt XDO_DS_DEFINITIONS'
  FROM xdo_templates_b
 WHERE application_short_name = 'XX';

---template definition upload command
SELECT 'FNDLOAD apps/apps 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ' ||
       template_code || '.ldt'
  FROM xdo_templates_b
 WHERE application_short_name = 'XX';

--template file download command
SELECT 'java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME -DB_PASSWORD -JDBC_CONNECTION -LOB_TYPE ' ||
       lob_type || ' -APPS_SHORT_NAME ' || application_short_name ||
       ' -LOB_CODE ' || lob_code || ' -LANGUAGE ' || LANGUAGE ||
       ' -TERRITORY ' || territory
  FROM xdo_lobs
 WHERE application_short_name = 'XX';

--template file upload command
SELECT 'java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME -DB_PASSWORD -JDBC_CONNECTION -LOB_TYPE ' ||
       lob_type || ' -APPS_SHORT_NAME ' || application_short_name ||
       ' -LOB_CODE ' || lob_code || ' -LANGUAGE ' || LANGUAGE ||
       ' -TERRITORY ' || territory || ' -XDO_FILE_TYPE ' || xdo_file_type ||
       ' -FILE_CONTENT_TYPE ''' || file_content_type || ''' -FILE_NAME ' ||
       lob_code
  FROM xdo_lobs
 WHERE application_short_name = 'XX';