Implementation Steps

Oracle EBS Barcode Integration Guide

Learn the most robust method for barcode generation in Oracle E-Business Suite using XML Publisher (BI Publisher). This approach eliminates the need for complex font installations on Unix/Linux concurrent managers.

Step 1

Define Data Logic in Data Template

Modify your Data Definition (.xml or PL/SQL source) to generate the barcode URL. This ensures the barcode image is fetched dynamically during the request run.

SQL Snippet for EBS XML Publisher
SELECT 
    wip_entity_name AS job_number,
    'https://www.barcodesoft.com/barcode/v1/code128?data=' || wip_entity_name || '&width=400&height=120&dpi=300' AS barcode_url
FROM 
    wip_entities
WHERE 
    organization_id = :p_org_id
Step 2

Create the RTF Template Mapping

Instead of relying on local fonts, use an image placeholder in Microsoft Word to handle the dynamic rendering.

1. Insert Placeholder

Insert a generic .jpg into your RTF template where the barcode belongs.

2. Assign Alt Text

Right-click image > Format Picture > Alt Text. Enter:
url:{BARCODE_URL}

Step 3

Configure Concurrent Programs

  • Output Type
    Set the Concurrent Program output to XML.
  • Template Registration
    Attach your RTF through XML Publisher Administrator.
  • Network Security
    Ensure the EBS server can perform outbound HTTPS requests to the barcode domain.

High-Resolution SCM Labeling

For industrial printers (Zebra, Honeywell), resolution is critical to prevent scan failures in the warehouse.

  • DPI Tuning: Append &dpi=300 for sharp thermal printing.
  • GS1 Compliance: Format strings in PL/SQL before sending to the URL.
  • Module Width: Use &mwidth=2 to adjust bar thickness for small labels.

Why API Beats Local Font Installation

Feature Local Font Method Cloud API Method
Server Setup Manual Linux Font Installs Zero Setup
Format Support PDF Only (Usually) PDF, Excel, HTML
Maintenance Broken by OS Upgrades Persistent

Troubleshooting

Barcode appears as a red 'X' in PDF?

Check Proxy settings in XML Publisher Configuration > General. The server likely lacks internet access.

Barcode is too blurry to scan?

Increase the dpi parameter in the URL (e.g., set to 300 or 600) to match your printer's specs.

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].

Cloud barcode API order
Instant Setup OAuth 2.0 Secure[cite: 3, 4] 600 DPI Ready[cite: 3, 4]