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:
Intermediate Status:
Outbound direction - Final Success Status:
Outbound direction - Final Error Status:
Inbound Direction - Final Success Status:
Inbound Direction - Final Error Status:
|
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 |