ITPub博客

首页 > 数字化转型 > ERP > Flexcube EMS -- Incoming

Flexcube EMS -- Incoming

原创 ERP 作者:soaringwen 时间:2014-01-09 21:19:33 0 删除 编辑

Incoming EMS process:

Key Tables/Procedure

 

Name

Type

Usage

IFPKS_MSG_INCOMING

Package

Entry point for incoming message processing

mstb_dly_msg_in

Table

Table to store the incoming message

mstb_dly_swift_msg_notif

Table

Table to store the incoming ACK/NAK message

 

1.       EMSInMDBBean is listening to the EMS_INQ, once message arrives, it will pick the message and call Flexcube package IFPKS_MSG_INCOMING.pr_process_inmsg

2.       The package will then do the necessary validation and insert in the mstb_dly_msg_in table provided the parameter maintenance (message queue mapping, STP rule…) is correct

3.       If the message is SWIFT ACK/NAK message, the message will be inserted to mstb_dly_swift_msg_notif table and update the related message ACK status as A or N
 

Manual SWIFT message upload by calling a store procedure
Sample:

DECLARE

p_message VARCHAR2(10000):='{1:F01BXXFFCN20AXXX1078021034}{2:O1031415130923BXTFCNB0AXXX11510139941309231415N}{4:
:20:cwu2309141337
:23B:CRED
:32A:130923USD678,
:50K:/123
TEST
:59:/1234
ABCD
:70:ABCC
:71A:OUR
-}{5:{CHK:70CAF67D31AB}{TNG:}}';

p_err VARCHAR2(100);
p_routingFlg VARCHAR2(100);
p_dsn VARCHAR2(100);

BEGIN

 IFPKS_MSG_INCOMING.PR_PROCESS_INMSG(p_message,'SWIFT',p_err,p_routingFlg,p_dsn);

END;
/




来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22624809/viewspace-1069045/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-09-29

  • 博文量
    4
  • 访问量
    13864