PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to delete the report definition via SQL?

edited Jul 24, 2020 5:41AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

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'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center