How to create check printing report and attached to Payment Process Profile in Oracle Apps.

How to create check printing report and attached to Payment Process Profile in Oracle Apps

 

When we run the Payment Batch , we do payment of multiple invoices in this payment batch. When the payment batch runs , it creates Payment Instructions file in the data base. This payment instruction file is the standard file in the xml format. IT contains all the information’s about payments , Like payment information , Payee information’s , payer’s information , Invoices information which is going to be pay in this payment batch.  This all information’s is available in the xml form and in the different -different groups of the xml. This is same , like when we create xml report from oracle RDF reports xml output.

 

This xml output is our base to design the check printing report which will be run automatically for all payments which will be create in the payment batch. This is same like designing the RTF template through RDF report xml output.

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.

How to create check printing report and attached to Payment Process Profile in Oracle Apps.