OFTP Message Queue

The Odette FTP Message Queue represents the central repository in IBM® Sterling B2B Integrator database for all inbound and outbound OFTP messages and receipts.

Each entry in the queue has a status which indicates the current status of the processing step.

Outbound

To send a message with the Odette FTP adapter to a remote partner you have to schedule the message in the Odette FTP Message Queue. The Odette FTP Queue Service can be used to create a new entry for a virtual file or EERP/NERP with initial status SCHEDULED.

Inbound

For each inbound message or receipt the Odette FTP Adapter creates a new entry with initial status RECEIVING.

During processing the Odette FTP Adapter updates the status of each entry in the queue according to the current processing status. All entries in the Queue reach a final state which indicates successful or failed processing. Entries that have reached final states, may be purged by the Odette FTP Scheduler service after a configurable time interval.

The following table contains an extract of the most important fields in the Odette FTP Message Queue (database table OFTP_OBJECT):

Field Description Possible Values
TYPE

The message type FILE is used for OFTP virtual files.

EERP is a positive end-to-end-acknowledgement.

NERP is a negative acknowledgement.

FILE

EERP

NERP

CERTIFICATE
STATUS The status of the message or receipt that has been scheduled, sent, received or forwarded.
Initial Status:
  • SCHEDULED
  • RECEIVING
Intermediate Status:
  • RETRY
  • WAIT_ON_FORWARDING
  • FORWARDED_WAIT_ERP
  • RETRY_FORWARDING
  • NERP_IGNORED
  • WRONG_ERP_RECEIVE
Outbound direction - Final Success Status:
  • SENT
  • SENT_AND_GOT_ERP
Outbound direction - Final Error Status:
  • FAIL
  • SENT_WAIT_ERP
Inbound Direction - Final Success Status:
  • RECEIVED
  • RECEIVED_AND_EERP_CREATED
  • FORWARDED
  • FORWARDED_AND_GOT_ERP
Inbound Direction - Final Error Status:
  • FORWARD_FAIL
  • FWD_FAIL_AND_CREATED_NERP
  • RECEIVE_FAIL
MESSAGE_ID

Mailbox Message ID for the message to send. This field is used for Mailbox Mode, only.

For outbound messages the mailbox message is created by the Odette FTP Queue Handler before a new entry in table OFTP_OBJECT is created. For inbound messages the Odette FTP Adapter creates the Mailbox message and a new entry in OFTP_OBJECT when a message is received.

0, if the Mailbox System is not used
DOCUMENT_ID Document ID of the message to send.  
LPC Logical Partner Contract as defined in the Odette FTP Partner Profile  
PPC

Physical Partner Contract as defined in the Odette FTP Partner Profile

  
SFIDDSN The OFTP Virtual File Dataset Name as used in the “Start File” SFID command  
SFIDDATE_TIME Virtual File Date stamp as used in the “Start File” SFID command  
SFIDTIMEC Virtual File Time stamp as used in the “Start File” SFID command  

SFIDDEST

 OFTP Destination as used in the “Start File” SFID command  
SFIDORIG OFTP Originator as used in the “Start File” SFID command