About Pending Transaction Statuses

A pending transaction can have a status of:

  • PENDING. Default. Identifies a Pending transaction that requires evaluation before you release it to the STAR accounting engine for processing. You can modify transactions with a Pending status.
  • HOLD. Indicates that you assigned the transaction a Hold status, making the transaction ineligible for release to the STAR accounting engine. You can modify transactions with a Hold status.
  • PROCESSING. Indicates that the system is temporarily processing the transaction.
  • RELEASED. Indicates that the transaction was successfully released from the PENDING_TRADES table to the STAR accounting engine for processing. You cannot modify transactions with a Released status.
  • FAILED. Identifies a transaction that was unsuccessfully released from the PENDING_TRADES table. You cannot update or release failed transactions. You can repair a failed transaction in Workflow Manager and submit it to the STAR accounting engine for processing.
  • <CUSTOM STATUS>. You can add additional custom statuses to group different types of "pending" transactions. The system provides the default values of Pending and Hold in the PEND_TRD_STATUS code category, but you can add your own code values. You cannot add the statuses of Released and Failed because those statuses are already used internally by pending trade processing. If you use custom statuses with pending transactions, be aware that you cannot use flagged position rules to assign custom statuses. Flagged position rules enable the system to assign transactions a status of Pending. If you use custom statuses, the system can receive transactions from an upstream system that have a custom pending transaction status assigned. The incoming transaction's Pending Trade Flag field (tag 3695) has a value of Y and the transaction's Pending Trade Status field (tag 3720) has a value equal to the custom status code value. You can then use the pending trade process to release that transaction in order for the STAR accounting engine to process the transaction.