Check Printing process in oracle apps r12

Check Printing process in oracle apps r12

In this post , We will be discuss about the Check Printing process in oracle apps r12. I will share the complete process to print the checks in oracle apps r12. Oracle apps has given the standard check printing layout for printing check in oracle apps r12 but we can also design our custom check printing layout and print it in oracle apps r12. This post will help to share the complete Check Printing process in oracle apps r12. Please find below the detail about Check Printing process in oracle apps r12.

Detail Step by Step for Check Printing process in oracle apps r12

To start deigning the check printing report , which will be attached in the Payment process profile then , we need use this below query

When we run the Payment Process request in the payment manager , then once the payment process request completes then it creates payment instruction id.

SELECT document FROM apps.IBY_TRXN_DOCUMENTS where payment_instruction_id=( PPR/Payment Batch Instruction Id)

Copy the text in the Document field and put in the notepad and save the notepad date with extension .xml then this will create the xml file of this copy date.

Now we have xml file , then open the xml file and understand the xml groups and design the RTF template as per your Current Pre -printed check shared by the bank. You will get all the information which will be need to design any check printing report.

Once your Check printing RTF template has been created , then you need to register this as a XML template in the XML publisher Responsibility.

Step1:-

Register the Check Printing RTF template as below

Data Definition :- Oracle Payments Funds Disbursement Payment Instruction Extract 1.0

Application :- Payments

Now Template has been created. Here we will create Payment Formats.

Payables ==> Setupè Payment Administrator è Formats

Type: Disbursement Payment Instruction 

Data Extract : Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
Create Payment Format as Select Type ' Disbursement Payment Instruction and Click Create Button.

Here in the Formats we will attach the XML template created in Step1 (XX_CHECK_PRINTING).

Now we have created the check Printing Template and the Format now we will go to Payment Process Profile and Attach this format to the Payment process profile which we use for Payment Method Checks.

Find the Existing Payment Process Profile under Setupè Payment Administrator è Payment Process Profiles.

Check Printing process in oracle apps r12