Quick Navigation
Integration Guide: Oracle Fusion Cloud ERP & SCM
Learn how to embed dynamic, high-resolution barcodes into BI Publisher reports without the complexity of server-side font management.
Define Barcode Logic in Data Model
Construct the barcode URL directly within your SQL query. This allows BI Publisher to fetch the correct image for each record dynamically.
SELECT
invoice_num,
-- Construct the API URL dynamically
'https://www.barcodesoft.com/barcode/v1/code128?data=' || invoice_num || '&width=300&height=100' AS barcode_url
FROM
ra_customer_trx_allConfigure the RTF Template
Since Fusion Cloud is a SaaS environment, we use Alt Text in Microsoft Word to handle dynamic image loading.
- Insert a small placeholder image into your RTF template.
- Right-click the image > Format Picture > Alt Text.
- In the Description field, enter:
url:{barcode_url}
url:{concat('https://www.barcodesoft.com/barcode/v1/qrcode?data=', INVOICE_NUM)}
High-Resolution Optimization
For industrial SCM labels (Zebra/Honeywell printers), resolution is vital for high-speed scanning.
DPI Scaling
Append &dpi=300 to your URL to increase line density for thermal printers.
Data Encoding
Use utl_url.escape for complex strings containing special characters or Application Identifiers (AI).
Security & Whitelisting
Oracle Fusion Cloud's Content Security Policy (CSP) requires external domains to be whitelisted before images can be rendered in reports.
Go to Setup and Maintenance > Manage Safe Domains > Add https://www.barcodesoft.com for both Image and Connect sources.
Why Fusion Developers Choose Cloud API
| Feature | Font-Based Method | Cloud API Method |
|---|---|---|
| Setup Time | Hours (Server Uploads) | Minutes (URL String) |
| Excel/PDF Consistency | Fonts often "drop" | 100% Native Rendering |
| GS1 Compliance | Requires complex coding | Built-in Logic |
| Maintenance | Server updates break fonts | Zero Maintenance |
Instant Access to Barcodesoft Cloud API
A subscription provides unlimited access to GS1-128, QR Code, DataMatrix, and Code 128 generation for your Oracle integration. Credentials delivered immediately via email[cite: 3, 4].
