X

Proactive insights, news and tips from Oracle Fusion Middleware Support. Learn Oracle from Oracle.

QR Codes in Oracle Reports

 

 QR codes are pretty popular, especially for paper based workflows and in
logistics. "Quick Response Code" is a two dimensional (2D) visual
representation of any alphanumeric string. Main purpose - same as with
barcodes - is to integrate paper with computers, aka offer machine
readability.

Depending on the use case, different variations of QR
codes are established, like Micro-QR-Code, Secure-QR-Code (SQRC),
iQR-Code. Typically their specifications differ in dimension and number
of elements (which basically refers to the amount of data  that can be
represented with it).

Also several (country specific) industrial
standards (like JIS X 0510, GB/T 18284, ISO/IEC 18004) as well as
de-facto standards (like OpenSource XZing) are in place, and so do many
programs generating them (QR Code Generator).

QR Code Sample

Oracle Reports has the ability to integrate external Java programs while the report is executed. Existing reports can be modernized that way and additional functionality can be added. A nice use case is demonstrated for the Barcode Bean. The barcode is generated on the fly and added for any destination format. Find details about the concept, implementation and coding in

Chptr. 43 Building a Report with a Barcode

 

of the main reference manual Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports 11g Release 2 (11.1.2).

For QR Codes integration into Oracle Reports, the same concept comes into place:

How to Generate 2D Barcode / QR Code in Oracle Reports (Doc ID 1678110.1)

This brand new sample code comes with demo RDF, Java coding required and setup instructions. It is based on OpenSource QR code generators.

Give it a try and let us know your experience!

Join the discussion

Comments ( 6 )
  • guest Thursday, February 5, 2015

    Hi,

    the link to Doc ID 1678110.1 is not working, can You pls. tell me where(how) I can find this note.

    Thank You in advance.

    Bye


  • Ahmed Ali Tuesday, March 31, 2015

    the link to Doc ID 1678110.1 is not working, can You pls. tell me where(how) I can find this note.

    Thank You in advance.


  • guest Tuesday, March 31, 2015

    Hello,

    many thanks for your interest in Oracle Develoment products.

    With respect to doc ID 1678110.1, I just checked the link and seeing it as valid working.

    Note that it is a reference to the My Oracle Support knowledge base and only accessible with a valid MOS account.

    Alternatively if you are inside MOS, just do a KM search for the note number 1678110.1 - this will lead you to the document.

    Regards

    Markus.


  • bex Monday, August 17, 2015

    The URL is broken for us poor non-Oracle employees outside of the firewall... this link works tho:

    https://support.oracle.com/epmos/faces/DocumentDisplay?id=1678110.1


  • John Poulin Friday, November 29, 2019
    Does NetSuites support QR codes?
  • Trimurtulu Merla Monday, January 6, 2020
    Wile run report on HP Unix server(12c Weblogic) below error displays. Same report is working fine in Report Build 11g

    The report terminated with error:
    REP-1401: A fatal PL/SQL error occurred in program unit cf_1formula. ORA-03147: missing mandatory TTC field .
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.