- The programs are mostly written in PL/SQL or Oracle Reports and built based on a standard template provided by the application.
The R12 process cannot generate more than one format per payment batch. You can use the Payment Group feature to achieve this same result.
In case you’re insert data into a custom table from the Payment Format program, and using that event to fire an Oracle Alerts to send a notification a payment was made, you will need to use a user hook as the payment program is standard in R12 and inserting data on custom tables is not possible.
If you’re moving payment files to directories from where they’re picked and sent to your bank, ftp server or payment engine, as in R12 the files generated are standard concurrent outputs, the names are different and you will have to include logic in your process to make the appropriate name that’s based on concurrent programs output standards.