How to update Customer Bill to business purpose Payment Terms ar.hz_cust_site_uses_all.payment_term_
Running R12.1.3 11.2.0.4 db on 64bit SLES11.
We have a need to blank out the Payment Terms of the Business purpose for Customers in a certain Org that have a certain Customer Profile Class.
Background :
The Customer Profile Class 'ENF Class' is changing Payment Terms from 'Net 30' to 'Immediate'. Hence Invoices for all Customers in Org 'ENF' that are attached to Customer Profile Class 'ENF Class' need to have the Payment Terms default to 'Immediate' and not 'Net 30'.
Currently all such Customers are set up with the Cust Account Site Bill-to Business purpose Payment Term as 'Net 30'.
If the Business purpose Payment Terms ar.hz_cust_site_uses_all.payment_term_id is blanked out, then when a new Invoice is created for such Customers, the 'Payment Term' on the Invoice will default from the Payment Terms of Customer Profile class and display as 'Immediate'.