Discover the secret of perfectly formatted Oracle EBS Excel report creation in under 10 minutes
Introduction
Creating new Oracle EBS reports with formatted Excel output can be time-consuming, especially given the complexities around BI Publisher and the necessary formatting requirements.
In this article, we create an Inventory item change tracking report in less than 10 minutes. We will assign version control add parameters and nominate a specific user for testing.
Steps
1. Download and install Blitz Report or use our development instance here
2. Logon as a developer and open the Blitz Report form.
3. Click on setup and create your new EBS Blitz Report.
4. Add report run-time parameters.
5. Configure excel report template.
6. Assign to user(s) for testing.
Blitz Report Installation
Blitz Report is seeded with 500+ reports and is free to use for the first 30 reports. The installation process typically takes less than 15 minutes. Blitz Report is a Java professional form available from the standard EBS menus and uses the application foundation functions such as concurrent requests and value sets.
The form can optionally be assigned to all your responsibilities depending on your requirements.
Development Process
The developer has access to the developer form and can create new reports with re-usable parameters from any other Oracle or Blitz Report. All reports can be run from the Java form or scheduled via the standard concurrent request process. Version controls allow developers to record comments and have traceability back to older versions of the reports.