Generating a Flat File

Unless you activate a clearing record, you cannot extract the clearing record in a flat file. The Activate Automatic Payments (ACTVTAPY) batch allows you to activate a clearing record. It stamps the APAYACH batch control and incremental batch run number on the clearing record.

Once the clearing records are activated, you can extract the clearing records in a flat file. The Extract Automatic Payments (APAYACH) batch allows you to extract the clearing records with the latest batch run number in a flat file. The flat file is then sent to the auto clearing house for review. For more information about these batches, see Oracle Revenue Management and Billing Batch Guide.

Note: At present, you cannot activate and extract the automatic refund clearing records using the Activate Automatic Payments (ACTVTAPY) and Extract Automatic Payments (APAYACH) batches, respectively. The implementation team will have to write the custom logic to activate and extract automatic refund clearing records in a flat file.