XML Publisher report data definitions and data template definitions codes names are unique in nature, if you want to delete the defined templates and definitions you can use the below delete scripts to delete those entries from Oracle and the sequence of the scripts given below.
Below is sequence in which you need to the records on the standard tables
BEGIN
DELETE FROM XDO_TEMPLATES_B
WHERE template_code = ‘IRC_CAND_DET_RPT’;
DELETE FROM XDO_TEMPLATES_TL
WHERE template_code = ‘IRC_CAND_DET_RPT’;
DELETE FROM XDO_LOBS
WHERE lob_code = ‘IRC_CAND_DET_RPT’;
DELETE FROM XDO_DS_DEFINITIONS_B
WHERE data_source_code = ‘IRC_CAND_DET_RPT’;
DELETE FROM XDO_DS_DEFINITIONS_TL
WHERE data_source_code = ‘IRC_CAND_DET_RPT’;
COMMIT;
END;
Run the below to check the deleted values:
select * from XDO_TEMPLATES_B where template_code = ‘IRC_CAND_DET_RPT’;
select * from XDO_TEMPLATES_TL where template_code = ‘IRC_CAND_DET_RPT’;
select * from XDO_LOBS where lob_code = ‘IRC_CAND_DET_RPT’;
select * from XDO_DS_DEFINITIONS_B where data_source_code = ‘IRC_CAND_DET_RPT’;
select * from XDO_DS_DEFINITIONS_TL where data_source_code = ‘IRC_CAND_DET_RPT’;
All the above select should return no records after the delete statements are executed.
