Fields of XI_AF_MSG table

[Former Member]

Hi Experts,

I need a small help.

I need to know what are the fields of the table XI_AF_MSG ?

And if I want to use this table in java code using JDBC then what information I should know to access this table?

Regards,

Bhargav Joshi

[Former Member]

Hi

fields of the table XI_AF_MSG

MSG_ID NOT NULL NVARCHAR2(119)

DIRECTION NOT NULL NVARCHAR2(8)

REF_TO_MSG_ID NVARCHAR2(254)

CONVERSATION_ID NVARCHAR2(254)

SEQUENCE_NBR NUMBER(10)

CONN_NAME NOT NULL NVARCHAR2(80)

MSG_TYPE NOT NULL NVARCHAR2(4)

STATUS NOT NULL NVARCHAR2(4)

TO_PARTY_NAME NOT NULL NVARCHAR2(60)

TO_PARTY_TYPE NOT NULL NVARCHAR2(120)

FROM_PARTY_NAME NOT NULL NVARCHAR2(60)

FROM_PARTY_TYPE NOT NULL NVARCHAR2(120)

TO_SERVICE_NAME NOT NULL NVARCHAR2(60)

TO_SERVICE_TYPE NOT NULL NVARCHAR2(80)

FROM_SERVICE_NAME NOT NULL NVARCHAR2(60)

FROM_SERVICE_TYPE NOT NULL NVARCHAR2(80)

ACTION_NAME NOT NULL NVARCHAR2(120)

ACTION_TYPE NOT NULL NVARCHAR2(80)

DELIVERY_SEMANTICS NOT NULL NVARCHAR2(4)

MSG_BYTES BLOB

SENT_RECV_TIME TIMESTAMP(6)

TRAN_DELV_TIME TIMESTAMP(6)

SCHEDULE_TIME NOT NULL TIMESTAMP(6)

PERSIST_UNTIL TIMESTAMP(6)

TIMES_FAILED NUMBER(10)

RETRIES NUMBER(10)

RETRY_INTERVAL NUMBER(19)

MSG_PROFILE NOT NULL NVARCHAR2(40)

TRANSPORT NOT NULL NVARCHAR2(40)

ADDRESS NVARCHAR2(254)

CREDENTIAL NVARCHAR2(254)

TRAN_HEADER NCLOB

VALID_UNTIL TIMESTAMP(6)

NODE NOT NULL NUMBER(10)

ERROR_CODE NVARCHAR2(127)

ERROR_CATEGORY NVARCHAR2(64)

PP_USER NVARCHAR2(128)

PP_HASH BLOB

VERS_NBR NOT NULL NUMBER(10)

VERS_CREATE_USER NOT NULL NVARCHAR2(128)

VERS_CREATE_DATE TIMESTAMP(6)

VERS_CREATE_TYPE NOT NULL NVARCHAR2(1)

VERS_CREATE_SOURCE NVARCHAR2(254)

VERS_WAS_EDITED NVARCHAR2(1)

Also check note Note 823116

Thanks

[prateek]

I have been referring to this forum post for the field information

Regards,

Prateek