Oracle Check Printing and Evergreen

Finally got sign off from the bank on the checks. Well sign off on 1 of 3. What a long drawn out process. The 2 that failed are related the MICR toner not baking onto the check paper properly. Hardware issues not software or output since one batch passed.

A warning to the wise. Don't ever, ever change the default check printing report for Evergreen that Oracle provides. On the flip side. I've learned a lot about HP printer escape values. How to manipulate the report and get the results that were requested by the business.

The evergreen print driver has two sections. Each section has a set of codes. once section contains codes between 100 and 199 the other section 200 and 299. The codes control most of the formatting of the report. Where to place the signatures, MICR numbers, address info, and what font to use.

The report when it hits certain sections it will trigger a code that the print driver will interpret and return the proper esc characters.

Changing the format of the report is not fun. There are basically 3 sections each with multiple overlaid fields depending on whether you are using a check at the top, check at the bottom of an overflow page. Don't try formatting any of the fields in the report. The esc codes will override them.

updated 01/29/2209 Still want to customize, here are some customizations that I did.