How to delete the report definition via SQL?
Hi,
Somehow my XMLP tables got out of synch when I created a new Report Definition. So when I tried to Save, the report definition I received the error message (235, 112) - At least one currently active template file must exist for each template.
From SQL Developer, I delete the record from the following tables:
PSXPRPTTMPL
psxptmpldefn
PSXPTMPLFILEDEF
PSXPRPTOUTFMT
PSXPRPTPROP
PSXPRPTDEFN
There were no records for my record definition in the tables
select * from sysadm.PSXPRPTCAT
select * from SYSADM.psxprptscopefld
select * from sysadm.psxprptsrchkeys
Once I delete the records, I cleared browser cache, closed the browser and opened another browser. When I try to add the report definition, I am getting the error 'Report Definition already exists'.