Monday, September 06, 2010

Deleting Data Definition and Layout Templates

I was creating a new BIP report and i selected incorrect application name. There is no way to update application name for Data template or layout temple. I could have updated the xdo tables and corrected the application name but i preferred to delete records from xdo tables and re-enter data template and layout template details.

I used following sql statements to delete data template and layout template for my report.

select * from XDO_TEMPLATES_B where template_code = :p_template_code

delete from XDO_TEMPLATES_B where template_code = :p_template_code

select * from XDO_TEMPLATES_TL where template_code = :p_template_code

delete from XDO_TEMPLATES_TL where template_code = :p_template_code

select * from XDO_LOBS where lob_code = :p_template_code

delete from xdo_lobs where lob_code = :p_template_code

select * from XDO_DS_DEFINITIONS_TL where data_source_code = :p_template_code

delete from XDO_DS_DEFINITIONS_TL where data_source_code = :p_template_code

select * from XDO_DS_DEFINITIONS_B where data_source_code = :p_template_code

delete from XDO_DS_DEFINITIONS_b where data_source_code = :p_template_code

No comments:

Post a Comment