Oracle BI Publisher (BIP) — now called Oracle Analytics Publisher when delivered as part of Oracle Analytics Cloud — is Oracle’s enterprise-grade formatted report and document generation tool. Where OAC Workbooks and OBIEE Answers produce interactive, web-rendered analytical visualisations, BI Publisher produces formatted output documents — precisely laid out PDFs, Excel workbooks, Word documents, and HTML pages — from structured data sources. BI Publisher’s report templates (designed in Microsoft Word, Excel, or BI Publisher’s online editor) define the layout, formatting, fonts, tables, and conditional content of the output document; the report query (SQL, XML data model, or web service) provides the data; BI Publisher merges the template with the data to produce the formatted document at runtime. This template-plus-data architecture makes BI Publisher the tool of choice for Oracle ERP operational reports, statutory financial statement outputs, regulatory filings, and any document that must conform to a specific layout that interactive BI tools cannot reproduce.
BI Publisher Architecture
| Component | Function | Finance Use Case |
|---|---|---|
| Data Model | Defines the report’s data source — SQL query, stored procedure, XML feed, or web service — and structures the output data as an XML document | GL trial balance data model; invoice listing query |
| Report Template | Formatted document layout with field placeholders, conditional sections, tables, and charts | Board financial statement format; ZATCA invoice layout |
| Report Definition | Associates a data model with a template; defines output formats and scheduling | Monthly P&L report scheduled at close; VAT return PDF |
| Delivery Manager | Distributes generated reports to email, FTP, WebDAV, or content repository | Distribute management pack PDF to board members on close completion |
| Bursting | Splits a single report output into multiple documents by a key dimension and distributes each to the appropriate recipient | Generate one balance sheet per subsidiary and email to each subsidiary’s controller |
BI Publisher for ZATCA-Compliant Invoice Output in Saudi Arabia
Oracle BI Publisher is the standard tool for generating the formatted invoice documents required under ZATCA Phase 2 e-invoicing in Saudi Arabia — specifically the human-readable invoice (ZATCA requires both an XML clearance record and a human-readable PDF or A4-format invoice that shows the ZATCA QR code, the clearance UUID, and the required VAT disclosure fields in the mandated format and language). BI Publisher templates designed against Oracle EBS’s AR invoice data model can incorporate the ZATCA QR code (generated from the invoice’s XML content using BI Publisher’s barcode field), the Fatoora clearance UUID, and all required Arabic and English bilingual field labels in a single template that produces the ZATCA-compliant invoice PDF for distribution to buyers. This native Oracle stack integration — EBS generates the transaction, ZATCA integration clears the XML, BI Publisher generates the formatted PDF — avoids the need for a third-party e-invoicing document generation tool.
What Goes Wrong in Practice
The most common BI Publisher failure in GCC financial reporting environments is a report template that was designed for a specific paper size and margin configuration (A4) but is being printed on a different format (letter size or a custom management report layout) — producing a formatted financial statement where column headers, page footers, and conditional section boundaries are misaligned with the printed page. BI Publisher templates must be tested with the actual output format, printer configuration, and PDF viewer that production users will use — not just in the development environment’s on-screen preview.
How Loop Wise Solutions Uses BI Publisher
We use Oracle BI Publisher for all pixel-perfect finance output requirements in Oracle-stack GCC environments: statutory financial statements, ZATCA-compliant invoice outputs, management pack PDFs, and regulatory filing documents. BI Publisher bursting is a standard component of our close cycle automation — automatically distributing the correct financial statement to each entity’s finance team on close completion.
