August 13, 2011

R12 AP Check Printing

Check Printing Concepts in R12:
1.Check Data moved to Payments from Payables.
2.Can Update the RTF to change the template of check Printing.
3.No of lines to be printed can be set in Payment Process Profile.


How to download Check Printing RTF:
Download standard oracle template
Payables Manager>Setup>Payment>Payment Administrator>Formats>XML Publisher Format Templates>Query and downloa 'Standard Check Format' IBYDC_STD1.rtf


Generating XML Is Little Difficult.
Can Refer to metalink Note ID:457539.1
Go to Payables>Setup>Payment Administrator



Click on go task of Formats>XML Publisher Formats


Select Data Extract as Oracle Payment Funds Disburesement Payment Instruction Extract,Version 1.
And XML Publisher Type as data Extract Identity In format
Update in Bank Account Documents and in Pay Process request

Go to Payable Super user Responsibility and Create a batch process and submit  the SRS as below with required parameters.
PGM:Create printed Payment Instruction

XML Extract will be in the output file.


No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...