Automatic Payment Response Report

Oracle Revenue Management and Billing enables you to extract the response received for automatic payment clearing records from the auto clearing house along with the current payment status through an FOP report. While generating the automatic payment response report, you can specify the following parameters - Search By, Start Date, End Date, Division, Customer Class, Person Name, Person Identifier Type, Person Identifier, Account Identifier Type, Account Identifier, and Automatic Payment Response. The Search By filter enables you to extract the automatic payment clearing records either using the following values:

• AUTOPAY_​EXTRACTION_​DATE - If you set the Search By parameter to AUTOPAY_​EXTRACTION_​DATE, the system considers the automatic payment clearing records whose extract date falls within the start and end dates.

• UPLOAD_​DATE - If you set the Search By parameter to UPLOAD_​DATE, the system considers the automatic payment clearing records whose response from the auto clearing house is uploaded within the start and end dates.

The Search By, Start Date, and Division are mandatory. If you do not specify the end date, the system by default sets it to the system date. You can generate the automatic payment response report from the user interface or through a batch process in either PDF or Excel format. We have shipped the following automatic payment response reports in this release:

• FOPAPAYHBPDF - Used when you want to generate the automatic payment response report through the C1-RPTGN batch in the PDF format.

• FOPAPAYHBXLS - Used when you want to generate the automatic payment response report through the C1-RPTGN batch in the Excel format.

• FOPAPAYHOPDF - Used when you want to generate the automatic payment response report from the user interface in the PDF format.

• FOPAPAYHOXLS - Used when you want to generate the automatic payment response report from the user interface in the Excel format.