Article ID: 122152, created on Jun 24, 2014, last review on Jun 24, 2014

  • Applies to:
  • Business Automation


Credit card payments are stuck in Hold status, Payment Orders for them are stuck in New status.


There is no New status in Payment orders Order Flow. Payment orders must be created in Open status.


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');

Search Words

Orders are not approving manually

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF