Blitz Report™ Library

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

Collections

2 reports

DescriptionDownload
IEX Dunning History
Dunning letters sent by Advanced Collections, one row per dunning, with the customer, account or bill-to site dunned, the dunning plan, the letter template, the delivery method and the amount due at the time of the dunning. The customer, account and bill-to site are derived from the dunning level: a customer level dunning has no account, and a delinquency level dunning shows the delinquent transaction with its due date and the days past due on the dunning date. Collector is the collector of the bill-to site profile, else of the account profile, else of the party profile.
 Enginatics, R12 only XLS XML
IEX Collection Note Upload
Creates and updates Collection Notes in Oracle Collections (IEX) - the same notes shown in the Collections work area. Each note is attached at a single Note Level: Customer (party), Account, Bill To, or Collections Transaction. The Note column is limited to 2,000 characters. The upload will reject the row if the note exceeds this. The Note Detail column is limited to 4,000 characters. Note details exceeding this will be truncated. Party Level Notes: Pary Name is required Party Number is required only when the Party Name is not unique. Account Level Notes: Party Name and Account Number…
full description		 Enginatics, R12 only, Upload XML