My Oracle Support Banner

The EMS_OUT Job Picks Up Records With MEDIA Type As 'MAIL' (Doc ID 2633127.1)

Last updated on DECEMBER 18, 2020

Applies to:

Oracle FLEXCUBE Universal Banking - Version 14.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.1.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
EMS_JOB picks up records from the table 'mstbs_dly_msg_out' which are of the media type 'MAIL'.

EXPECTED BEHAVIOR
-----------------------
EMS_JOB should only pick up 'SWIFT' messages

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create MM contract and enter all SWIFT details in ADVICES tab to generate SWIFT mesg.
2. Run EMS_JOB from the screen SMSJOBBR
3. EMS_JOB picks up records from the table 'mstbs_dly_msg_out' which are of the media type 'MAIL'.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Messages get stuck with the status as 'W'.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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