AP_PAYMENTS_TEMPLATES
During our upgrade to 12.2.3 a consultant gave one of our payment templates an unfortunate name and description. The template is for our Canadian EFT payments. The consultant named it "Bank of Montreal" even though it is NOT tied to that bank.
The Payables team has been aware of the situation and works around it. However, management has started reviewing some Payables actions and the name is proving to be a source of trouble. We would like to change the template name and description (rather than setup a brand new template).
Our plan is to use SQL to change these two fields. We're not proposing changing any record IDs, just a name and a description. Here is the script we are planning to use.