# Oracle EBS Standard Reports by Module and Sample XML for BI Publisher > Source: https://netray.co/erp-help/oracle-ebs-standard-reports-by-module-and-bi-publisher-sample-xml > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Oracle EBS standard reports are concurrent programs run from Standard Request Submission (View > Requests > Submit a New Request) and limited by each responsibility's request group. To redesign one in BI Publisher, run the program so it produces XML output, save that XML as sample data, load it into the template builder, and register the template against the program's data definition. ## Kind how-to ## System oracle-ebs ## Erp Oracle E-Business Suite R12 ## Module Standard Reports / BI Publisher ## Query oracle ebs standard reports ## Alternate Queries - sample xml for oracle ebs report - oracle ebs standard reports list by module - oracle ebs run standard request submission - bi publisher sample xml oracle ebs ## Applies To Oracle E-Business Suite R12.1 and R12.2 with XML Publisher / BI Publisher. Report names vary slightly by release and installed modules. ## Steps ### Run a standard report and get sample XML **Items:** - Log in with a responsibility for the module and choose View > Requests, then Submit a New Request, and select Single Request. - Search the program name, enter the parameters, and submit. If it is missing, your request group does not include it; ask an administrator to add it. - Check the output in View > Requests and confirm the output format. For BI Publisher reports, the program generates XML first and then applies a template. - To get raw XML, run the program with output format XML where the program allows it, or use the XML Publisher Administrator tools to retrieve data for a data definition, and download the output file. - Save the XML to a file, open Word with the BI Publisher Desktop add-in, and use Insert > Sample XML to load it. - Build the template with fields, tables and groups from the XML, then upload it as an RTF or Excel template in XML Publisher Administrator under the matching data definition. - Submit the program again with the template and check layout, totals and page breaks. ## Sections ### Finding standard reports by module **Body:** Standard reports are grouped by module and by request group. In General Ledger, typical reports cover trial balance, journals and account analysis. Payables has invoice registers and trial balances, Receivables has aging and statements, Purchasing has purchase order and receiving reports, and Inventory has valuation and transaction reports. Names differ by release, so search the program list by keyword rather than relying on a printed list. To see every report available to a responsibility, check its request group in the System Administrator responsibility under Security > Responsibility > Request. To see all programs in the system, query the concurrent program tables. **Code:** SELECT cp.user_concurrent_program_name, cp.concurrent_program_name, a.application_short_name FROM fnd_concurrent_programs_vl cp, fnd_application a WHERE a.application_id = cp.application_id AND a.application_short_name = 'GL' ORDER BY cp.user_concurrent_program_name; ### What sample XML looks like **Body:** BI Publisher data is XML with a root element, repeating groups and fields. The template builder only needs the structure and a few rows to map fields. If a program does not give you XML directly, build the structure by hand from the program's data template or query and fill in a few rows. A small sample is enough for layout work; keep one with a long text value and one with an empty value, so you can test wrapping and blank handling. **Code:** 204 10045 Acme Industrial 2026-09-14 1 AB-1001 25 112.50 ### Registering the template **Body:** In XML Publisher Administrator, a data definition ties a concurrent program to its XML data source, and templates attach to the definition. Create the template with the same code as the program, upload the file, choose language and territory, and set the output types. Then submit the program as a normal request. Changes to templates need no code deployment, which makes layout fixes quick, but treat them as controlled changes in production and keep the template file in version control. ## Pitfalls - Designing a template on made-up XML whose structure differs from the real data. - Forgetting that the report is not in the responsibility's request group. - Editing a delivered template in place instead of copying it. - Using only one or two sample rows, then failing on long text or empty values. - Changing layouts in production without testing and a rollback copy. ## Ai Angle Many report requests are really questions that a standard report only partly answers. An assistant grounded in your EBS data can answer them directly and show the query, and when a formal printable output is needed, it can help draft the data template and sample XML for BI Publisher. Netray runs it on-prem so reports containing financial data are not sent outside. ## Faq ### Where do I run standard reports in Oracle EBS? **Answer:** Use View > Requests > Submit a New Request in the module responsibility, select Single Request, and choose the program. You can only see programs included in the responsibility's request group. ### How do I get sample XML for an EBS report? **Answer:** Run the program with XML output where available, or retrieve the data for its data definition, and download the file. If neither is possible, build a small XML file by hand from the program's query structure. ### Can I change the layout of a standard report? **Answer:** For BI Publisher reports, yes: copy the delivered template, edit the copy in Word or Excel, and upload it. For older Oracle Reports programs, customization requires changes to the report definition, which is more involved. ### Why can I not see a report in the list? **Answer:** Your responsibility's request group does not include it. A system administrator can add the program to the request group or give you a responsibility that has it. ## Search terms oracle ebs standard reports, sample xml for oracle ebs report, oracle ebs reports by module, oracle bi publisher sample xml, oracle ebs standard request submission, oracle ebs request group reports, xml publisher data definition, oracle ebs report template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json