EMS_IN Job Is Not Inserting Incoming SWIFT Message into PMZB_MSG_DLY_MSG_IN Table (Doc ID 3064982.1)

Last updated on JANUARY 13, 2025

Applies to:

Symptoms

Actual Behaviour:
-------------------------------

As per document (https://docs.oracle.com/cd/F72109_01/PDF/IF/IF_EMS.pdf)
The message files are to be placed in the EMS\SWIFT\In\Ready, in the EMS server. The
incoming message service (In-service) copies the file to the folder EMS\SWIFT\IN\WIP and
performs further processes like formatting etc. Once the processes are completed, the file is
moved to the folder EMS\SWIFT\IN\PROCESSED. At this stage the message should get inserted in PMZB_MSG_DLY_MSG_IN.

The message is moved to Processed folder but not available in PMZB_MSG_DLY_MSG_IN table.

Expected Behaviour:
-------------------------------

EMS Job should inserts the message in PMZB_MSG_DLY_MSG_IN table.

Exceptions Observed:
---------------------------
Following exception in EMS_IN.log are observed:

[20240904 15:46:56 256]FCJobCacheFactory.getMediaMapDetail--> From media map getting media details for Node=KERNEL11G.WORLD Mcs=SWIFT Media=SWIFT
[20240904 15:46:56 256]EMSInEJBBean.getEMSIntMsgs---->SQLException = No MCS Maintained for [node=KERNEL11G.WORLD; mcs=SWIFT; media=SWIFT] !!!
[20240904 15:46:56 256]EMSInEJBBean.getEMSOutMsgs-->Transaction getting roll back due to exception
[20240904 15:46:56 257]java.lang.Exception: No MCS Maintained for [node=KERNEL11G.WORLD; mcs=SWIFT; media=SWIFT] !!!
at com.ofss.fcc.EMSInEJBBean.doProcessing(EMSInEJBBean.java:627)
at com.ofss.fcc.EMSInEJBBean.getEMSInMsgs(EMSInEJBBean.java:267)


They have already maintained MSDMGMCS - Media Message Control Maintenance
They have maintained MCS = SWIFT and Media = SWIFT
They have also specified EMS Sever paths in and out directory.


BUSINESS IMPACT
-----------------------
The incoming Swift messages are practically not reaching OBPM and are not visible on front end.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.