Processing ACH payments using API oe_order_pub.process_order
Giving explanation in detail issue we are facing
We are using oe_order_pub.process_order API to create a record in oe_payments table with p_header_payment_tbl argument.
For this API, we are passing following values:
l_header_rec.payment_type_code := 'ACH';
l_header_payment_tbl (l_header_payment_tbl.COUNT + 1) := oe_order_pub.g_miss_header_payment_rec;
l_header_payment_tbl (l_header_payment_tbl.COUNT).operation := oe_globals.g_opr_create;
l_header_payment_tbl (l_header_payment_tbl.COUNT).payment_trx_id :=p_payment_trx_id;
l_header_payment_tbl (l_header_payment_tbl.COUNT).payment_type_code := 'ACH';