3. Message Formats
3.1 Introduction
Data exchanged between Oracle FLEXCUBE IS and the external systems will be in the form of XML messages. These XML messages are defined in FCUBS in the form of XML Schema Documents (XSD) and are referred to as ‘FCIS formats’. An XML Schema is uniquely identified by its Namespace and its Root Element (root node).The root node for XSDs of gateway messages will be generated as per the following pattern:
- <OPERATION>_<MESSAGE EXCHANGE PATTERN>_REQ
- <OPERATION>_<MESSAGE EXCHANGE PATTERN>_RES
- Where
- <OPERATION> refers to an Oracle FLEXCUBE IS operation like CREATEUNITHOLDER
- <MESSAGE_EXCHANGE_PATTERN> refers to the request and response
message patterns exchanged. The Message Pattern is of the following types
- FS (Full Screen) -This indicates that the payload will contain all the elements on the corresponding Oracle FLEXCUBE IS screen.
- IO (Input Only) - This indicates that the payload will contain the only input elements on the corresponding Oracle FLEXCUBE IS screen.
- PK (Primary Key): This indicates that the payload will contain only the Primary Key elements of the corresponding Oracle FLEXCUBE IS screen.
<MESSAGE_EXCHNAGE_PATTERN> is a combination of message patterns. The <MESSAGE_EXCHNAGE_PATTERN> available in Oracle FLEXCUBE IS is shown below:
- FSFS - Full Screen Request and Full Screen Response
- IOPK - Input Only Request and Primary Key Response
- IOFS - Input Only Request and Full Screen Response
Non-Query Formats
For example, consider the Operation ‘CREATEUNITHOLDER’. The root node of messages under this operation will be as under:
- CREATEUNITHOLDER_FSFS_REQ
- CREATEUNITHOLDER_FSFS_RES
- CREATEUNITHOLDER_IOPK_REQ
- CREATEUNITHOLDER_IOPK_RES
Query Formats
For instance, consider the Operation ‘QUERYUNITHOLDER’. The root node of messages under this operation will be as under:
- QUERYCUNITHOLDER_IOFS_REQ
- QUERYUNITHOLDER_IOFS_RES
This chapter contains the following sections
3.2 Oracle FLEXCUBE IS Envelope
This section contains the following topics:
A standard gateway message in the Oracle FLEXCUBE IS Envelope contains two main components namely:
- FCUBS_HEADER – This is a node that forms the header of the FCUBS Envelope. The tags under the header portion of a message will identify a partner system, a service, an operation, user, branch, etc. These tags are constant across all messages.
- FCUBS_BODY – This node contains the actual payload of a message.
The contents of this node will vary for each message.
3.2.1 FCUBS HEADER
The tags under FCUBS HEADER have been described below:
SOURCE
This indicates the name of the External system that is the source of the message.
UBSCOMP
This indicates the Oracle FLEXCUBE IS component of the message - whether FCIS or FCUBS
MSGID
This unique ID identifies each message – incoming or outgoing in Oracle FLEXCUBE IS. Every message will have a distinct message ID.
CORRELID
This is the id using which any system which has sent a request to FCUBS can correlate to the response. In the External system maintenance, the Correlation Pattern can be configured for each external system. It can be maintained that either the ‘MSGID’ or the ‘CORRELID’ of the request message is returned back as the ‘CORRELID’ in the response message. Depending on this maintenance, Oracle FLEXCUBE IS will set either the ‘MSGID’ or the ‘CORRELID’ of the request message in the response message.
USERID
For request messages, this ID is used to submit message requests. Oracle FLEXCUBE IS will process this request using this id.
For response messages, the value of this will be ‘null’.
BRANCH
This indicates the Oracle FLEXCUBE IS Branch Code where the request message needs to be processed. If the BRANCH is missing in the header, request message will be transmitted and processed in Head Office branch.
MODULEID
This indicates the module ID.
SERVICE
This provides details on the various services of Oracle FLEXCUBE IS. For every incoming message in Oracle FLEXCUBE IS, the service name is mandatory.
OPERATION
This indicates the functional operation.
SOURCE_OPERATION
This indicates the functional operation as registered in Oracle FLEXCUBE IS.
SOURCE_USERID
This is the User ID with which the request message was invoked from the SOURCE.
DESTINATION
For incoming messages, the destination will be Oracle FLEXCUBE IS. For response messages, system will populate the SOURCE of the request message as DESTINATION.
MULTITRIPID
This is a unique id which indicates overrides.
FUNCTIONID
This indicates the Oracle FLEXCUBE IS Function ID
ACTION
This indicates the action type.
MSGSTAT
This indicates whether the transaction is a SUCCESS or FAILURE.
PASSWORD
This indicates the password.
ADDL
This is used to send additional parameters i.e. parameters not available in Oracle FLEXCUBE IS
3.2.2 FCUBS_BODY
The FCUBS_BODY will contain the actual payload to perform the respective transaction. The contents of the payload will vary for each operation.
The following snapshot shows a sample FCUBS_BODY of QUERYUNITHOLDER operation.
FCUBS_BODY will contain additional nodes for error response and warning response. A diagrammatic representation of the Error response is as shown below:
3.2.2.1 FCUBS_ERROR_RESP
The error response message will be sent from Oracle FLEXCUBE IS when errors are raised in a transaction. The error response will have another tag ‘ERROR’ within it.
ERROR
The ‘ERROR’ node will have tags for error code and error description. The ‘ERROR’ node will be generated for each error raised by FCIS.
3.2.2.2 FCUBS_WARNING_RESP
The warning response message will be sent when overrides are raised in a transaction. The Warning response will have another tag ‘WARNING’ within it.
WARNING
This node will have tags for warning code and warning description. The ‘WARNING’ node will be generated for each override raised by FCIS.
3.3 Oracle FLEXCUBE IS NOTIFICATION
The notification messages are generated in a standard format. The notification messages will consist of two main components:
FCUBS_NOTIF_HEADER – This forms the header portion of a notification message. This contains a standard set of tags that can identify a notification. These tags are constant across all notification messages.
FCUBS_NOTIF_IDENTIFIER – This will identify the maintenance records based on the information provided under this node. The contents of this node will vary for each notification.
A diagrammatic representation of FCISS NOTIFICATION is as shown below:
3.3.1 FCIS NOTIFICATION HEADER
The tags under FCIS NOTIFICATION HEADER have been described below:
SOURCE
This indicates the name of the External system or the source of the message.
MSGID
This is the unique reference number generated by Oracle FLEXCUBE IS.
NOTIF_REF_NO.
This unique reference number identifies each notification message generated in Oracle FLEXCUBE IS.
BRANCH
This indicates the branch in which notification has been triggered.
NOTIF_CODE
This indicates the code for the notification that has been triggered.
DESTINATION
For incoming messages, the DESTINATION should be Oracle FLEXCUBE IS. For response messages, system will populate the SOURCE of the request message as DESTINATION.
MODULEID
This indicates the module ID.
Refer ‘Service-Documentation’ available under ‘Gateway’ for details about each message.