Setups required for the Check Printing and Extending Standard XML to get the additional data for check printing

Page-1

Setups required for the Check Printing and Extending Standard XML to get the additional data for check printing 

INTRODUCTION

Check printing from the E-Business Suite has historically required a third-party solution that can either query the necessary data and format the output or accept the existing flat text output generated by the provided check print programs. To then generate the checks, the format components had to be placed with pixel-perfect precision onto the page using the necessary MICR font to format the bank routing number and bank account of the payee. Alternatively customers could take the existing check print program and customize it to format the output correctly.

These solutions are costly in terms of their implementation, their ongoing maintenance and their complexity. This all adds to the total cost of ownership for the E-Business Suite.

Oracle XML Publisher offers integrated functionality that allows customers to

design their own check format using familiar desktop tools that can then be applied to a check print data source, whether that is the seeded Oracle Report or a custom solution.

This format is easily maintainable and can include all the necessary components required in the final output to be printed.

Steps Covered for check printing in this document

v  Format Payment Instruction Setup

§  Template creation.

§  Create Format.

§  Payment Document for bank account.

§  Payment Process Profile.

v  MICR Font Registration

§  Download the Micr Code ttf file as per the requirement.

§  Use this font while developing the check print template rtf.

§  Font file and font mapping setup in the application.

v  Extend the Standard XML to get the additional details for the template.(optional)

Setup Steps to be Followed for AP CHECK printing

Go to responsibility name ‘AP Super User’.

Step1: Create Template

  Navigation: Setup -> Payment -> Payment Administrator.

 

·         Go to Formats -> Xml Publisher Format Templates, Click on the Go to Task button.

Below page opens.

·         Click on the Create Template Button. Below page opens.

Enter the following details as shown in above screenshot.

Name: XXX

Code: XXX

Application: Payments

Data Definition: Oracle Payments Funds Disbursement Payment Instruction Extract 1.0

Type: RTF

Default Output Type: PDF

·         Browse the RTF File which is present in the remote Script folder ‘XXX_AP_CHECK.rtf’.

Language: English

·         Click on the apply button after entering above details.

The template is created.

For Create Format.

§  Payment Document for bank account.

§  Payment Process Profile follow the below link

http://oracleappskey.blogspot.com/2015/03/Steps234FormatPaymentDocumentandPaymentProcessProfile.html

For MICR Font Registration

§  Download the Micr Code ttf file as per the requirement.

§  Use this font while developing the check print template rtf.

§  Font file and font mapping setup in the application.

v  Extend the Standard XML to get the additional details for the template.(optional) 

follow the below link

 http://oracleappskey.blogspot.com/2015/03/MICRFontRegistrationandExtension.html