We use a PeopleSoft query as our data source for our XML Publisher reports. We added a field to a PS query then regenerated the XML (Reporting Tools-XML Publisher-Data Source). The regenerated XML now has the PS query record letter prefixed to each field name. For example, previously the XML looked like this:
After adding the new field and regenerating the XML, it now looks like this:
As a test we removed the new field from the query and regenerated the XML. Now the XML reads like this:<FIELD1>FIELD1</FIELD1>. There is only one table in the query. Why would one new field change the XML to this?