Symptoms
Credit card payments are stuck in Hold status, Payment Orders for them are stuck in New status.
Cause
There is no New status in Payment orders Order Flow. Payment orders must be created in Open status.
Resolution
Initial status of the Payment Orders is specified in OrderOperation
table of PBA-E database:
pba=> select * from "OrderOperation" where "OperID" in ('makePaymentOrderByProv','makePaymentOrder');
OperID | VendorID | OrderStatusID | OrderTypeID | UserArc | DateArc
------------------------+----------+---------------+-------------+---------+---------
makePaymentOrderByProv | 0 | NW | PO | 1 | 1
makePaymentOrder | 0 | NW | PO | 1 | 1
(2 rows)
To correct initial status of the Payment Orders please execute the following update in PBA-E database:
update "OrderOperation" set "OrderStatusID" = 'OP' where "OperID" in ('makePaymentOrderByProv','makePaymentOrder');