We will discuss about Custom check printing in Oracle Apps.
Sometimes AP team in the organization has to send the checks to the Suppliers/Employees(Internal Employee Expenses), so we need a one check format according to the Bank guidelines.
Oracle provides couple of predefined check formats in the system but most of the times we have to add our custom formats.

Here we will cover below Topics
1. Download Standard Check Format
2. Add your company logo and address
3. Add your bank account,amount and check number
4. Assign it to Payment Process Profile

Download Standard Check Format:

Navigation: XML Publisher Administrator -> Templates
Data Definition Name: Oracle Payments Funds Disbursement Payment Instruction Extract 1.0

Open Standard Check Format template and download the RTF template to check meet business/bank requirements.

Generally we have to customize the standard check printing template i.e. adding the bank name, adding company logo on the check and couple of other formats like bank account number, check number printing, transaction amount format etc.

IBYDC_STD1.rtf: Standard RTF template looks like below without a bank name and company name/logo.

Custom Template:

In order modify the standard template we should know XML tags first.
Actual check printing concurrent program name is Format Payment Instructions

Now we need to know the XML tags, we can get XML tags by two process.
1. Change Format Payment Instructions output type as XML.
If we change the output type to XML and run the PPR process for checks we will get the XML tags.
2. Get the XML tags from IBY_TRXN_DOCUMENTS table and the column is Document.

Sample XML Tags:

XML Template Design:

XML Tags used in above template

Now the template is ready assign it to PPR process.
We will discuss about PPR in another blog. The PPR(Payment Process Request) will be used to create the payments by AP team in Oracle Apps.
In order to run the PPR process, most of the times we will create the payment process profile and attach it to the PPR.
We will assign this custom check to the payment process profile.

Creating Custom Check Template:

Create Payment Format:

Define a payment format and link the XML publisher template (RTF) to format.
Payables Manager -> Setup -> Payment -> Payment Administrator -> Formats -> Formats


Select type as Disbursement Payment Instruction and click on create button.

Code & Name: XXCUS_CHECK_FORMAT
Data Extract: Oracle Payments Funds Disbursement Payment Instruction Extract, Version 1.0
XML Publisher Template: Custom Check Template (We defined above the check format)

Assign this Payment Format to the Payment Process Profiles:

Payables Manager -> Setup -> Payment -> Payment Administrator -> Payment process Profiles

Assign the custom format what we created(XXCUS_CHECK_FORMAT) to payment process profile

Run the Payment Process Request for Checks:

Payables Manager -> Payments -> Entry -> Payments Manager
Go to payment process requests tab and click on submit single request button.

We have to assign our payment process profile to PPR request in order to pick up our custom check template.
Once we submit the PPR(Payment Process Request) there are certain steps to perform, which we will talk about in another blog.
In the 3rd step or Payment Process/Format Payment Process the check program(Format Payment Instructions) will be executed.
Output the program: