EBIFour.com > Training > Clarify Tips > PostgreSQL : Retrieve Message Status Code for Outbound EDI Transactions

PostgreSQL : Retrieve Message Status Code for Outbound EDI Transactions

14th August 2017

Cleo Clarify Postgre Log of Message Status Codes


When I was researching the status of outbound EDI documents in the PostgreSQL table:  LOG_OF_MESSAGE. I discovered each document had its own STATUS code.

There were some cases where the outbound EDI messages have MESSAGE_ID  = <null>, in some instances, and MESSAGE_ID != <null>. I was also finding that the status codes are different when “MESSAGE_ID” is populated versus not populated.

Examples of status codes:

Below are some examples of status codes. The complete list can be obtained from Cleo Clarify Support Team

STATUS: Completed

Cleo Clarify Postgre Log of Message Completed Status Code

STATUS: Generated

Cleo Clarify Postgre Log of Message Generated Status Code

For users unsure of accessing the internal PostgreSQL tables, we discussed access to the internal PostgreSQL database tables. 


By: on