Patent 7945601 was granted and assigned to Oracle on May, 2011 by the United States Patent and Trademark Office.
Embodiments described in the application provide for reports that are generated in many different formats using an Approval Workflow Engine (AWE) and an XML Publisher (XMLP) component. The AWE can accept user parameters to extract data from at least one data source, transform the data, and generate a structured XML data file appropriate for the report. The AWE can pass this XML file, along with at least one report template and other necessary information to the XMLP, which is able to generate reports in any of a number of specified formats. Such an approach keeps the data separate from the formats and components, and allows for multiple reports to be generated without accessing an application for each format. The AWE also can store an audit history record for each transaction passing through the AWE in order to provide a concise location from which to retrieve the information.