Script to delete data definition and template in XML Publisher Reports in Oracle apps

Hi! This post will show you the script to delete the data definition and template in XML Publisher reports in Oracle apps.

Script to delete template and data definition in XML Publisher Reports:

BEGIN

DELETE from xdo_templates_b WHERE template_code = 'XXEMP';

DELETE from xdo_templates_tl WHERE template_code = 'XXEMP';

DELETE from xdo_lobs WHERE lob_code = 'XXEMP';

DELETE from xdo_ds_definitions_tl WHERE data_source_code = 'XXEMP';

DELETE from xdo_ds_definitions_b WHERE data_source_code = 'XXEMP';

COMMIT;

EXCEPTION WHEN OTHERS THEN

dbms_output.put_line('An unknown error occurred '||SQLERRM);

END;

In the above script, XXEMP is the sample template or data definition code which is nothing but the concurrent program short name.

Happy Learning!!