Custom Check Printing in Oracle Apps R12: Step-by-Step Guide

---

💡 Introduction

Oracle E-Business Suite R12 offers robust Payment Process functionality, including check printing. Businesses often need custom check layouts that match branding, comply with regulations, or include extra info.

This blog guides you through customizing check printing in Oracle Apps R12—from setup to template deployment.

---

🎯 Why Custom Check Printing?

• Match company branding & legal requirements

• Add invoice or payment details

• Support bank-specific formats

• Improve check readability & security

---

🔍 Standard Check Printing Flow in Oracle R12

Oracle Payments handles check printing using:

• Check Print Program (APXCKMND) to generate payment data

• BI Publisher (XML Publisher) to merge data with templates

• Standard templates included but customizable

---

🛠️ How to Implement Custom Check Printing

---

Step 1: Understand Data Flow

• Payment batch processed → XML data generated → Template merges data → Check output produced

---

Step 2: Customize XML Data (If Needed)

You may want to include additional fields in the XML data sent to BI Publisher.

Sample XML snippet with added invoice_number:

<Check>
  <SupplierName>ABC Corp</SupplierName>
  <PaymentAmount>1500.00</PaymentAmount>
  <InvoiceNumber>INV-12345</InvoiceNumber>
  <PaymentDate>2025-07-26</PaymentDate>
</Check>

---

Step 3: Design/Modify BI Publisher Template

Use Microsoft Word with the BI Publisher plugin:

• Insert XML fields via Insert > Quick Parts > Field

• Format fonts, add company logos, borders, and signature lines

Sample template editor screenshot:

---

Step 4: Upload Template to Oracle

• Navigate to XML Publisher > Template Manager

• Upload your Word (RTF) template

• Assign it to the Check Print report

• Set it as default

---

Step 5: Test Check Printing

Run the Check Print Program (APXCKMND) for your payment batch and verify the output.

---

📝 Tips & Best Practices

Tip	Description
Backup originals	Always keep a copy of default templates
Test thoroughly	Use test batches to validate formatting
Secure fonts	Use clear, standard fonts to prevent fraud
Maintain version control	Track changes for audit and rollback purposes

---

🔗 Oracle Documentation

• Oracle Payments User Guide

• BI Publisher Developer Guide

---

🎯 Conclusion

Custom check printing empowers organizations to meet unique requirements with Oracle Apps R12. Leveraging XML data and BI Publisher templates ensures flexible, professional outputs.

---

💬 Questions?

Leave a comment below or ask for custom template samples or video tutorials!

---

If you'd like, I can prepare a sample custom template or a video walkthrough for the full process. Just let me know!