How to Setup, Map, and Print Custom Reports with a Barcode / MICR Font

Introduction

Introduced in XML Publisher 5.6.0 is a new tab named Administration. This replaces the xdo.cfg configuration file and its goal is to simply the administration of XML Publisher as part of an Oracle E-Business Suite environment

Most of the company's will have a check print report where we use custom MICR string defined by the bank.

To achieve this we need to do the following setups.

Step 1:  Decide Your MICR True Type Font

Decide the MICR font you are going to use (eg.,MICRE13B) . This font should be installed in your system in order to use this in the MS Word.

Step 2:  Design your rtf file

Design your rtf file, for the MICR string use the font that you installed, this can be chosen from the MS Word Drop fonts down

Step 3: Register your font in EBS

Register the font file that you have in XML Publisher Administration. Here are the steps to do it.

EBS Navigation - XML Publisher Administration ->Administration ->Font Files

Font Name: for Font Name, choose any descriptive name

File: File browse your font file in your machine. Click on Apply.

Step 4:  Create font mapping set

You have completed registering your font, Now you have to create the Font mappings for the font  you have created.

EBS Navigation - XML Publisher Administration ->Administration -> Font Mappings -->Create Font Mapping Set

Mapping name: Mapping name is the name you will give to a set of fonts.

Mapping code: Mapping code is the internal name you will give to this set

Type: 'PDF Form' for PDF templates. 'FO to PDF' for all other template types.

Step 5: Create Font Mapping

This allows you to add fonts to a set

Font Family: Font Family is the exact same name you see in MS Word under Font. If you don't use the same name the font will not be picked up at run time.

Style and weight: Style and weight must also match how you use the font in the RTF or PDF layout template. Normal and Normal are good defaults.

Language and Territory: Language and Territory should remain blank (NULL) unless you have a strong business reason, as these fields can cause the font not to be picked up at run time.

Step 6: Change the FO Processing Configuration window

You have created a font and included it to a mapping set. Now you have to change the configuration to set the Font mapping set to your mapping set.

Once this is done, all set and you are ready to go.

Run your payment/report and you should see the MICR string printed in the output.

For any suggestion or issues with the above code, please leave your comments. I will try to reply back as soon as possible.