Information Systems:OMS - Outbound Message System

Overview

OMS is a UNITY extension that allows for outbound emails to be sent from the extensions programs. Its known major usages are:

• Email order confirmations for POS orders
• Remittance advices
• An email version of the catalogue, where the catalogue is written to the email body (quite horrible).

Design

The main tables are:

• OMSQUEP (OMS-Outbound Message Queue File)
• OMSMHDP (OMS-Outbound Message Header File)
• OMSLINP (OMS-Outbound Message Lines File)
• OMSOUTP (OMS-Outbound Message Holding File)

Program flow:

• Job OMSPOSTPRD runs OMSNEP01CL (OMS-Process Outbound Email Msgs), a CL program. This runs all day in subsystem OMSSUBPRD.
• OMSNEP01CL calls RPG program OMSNEP01 (OMS-Process The Outbound Email Msgs for OMS System). This takes lines from OMSLINP and writes them
• OMSNEP01 calls OMSCRTFL (OMS-Create The IFS File For Domino Process) to create an IFS file for the database record (file member). This file goes into /omsfiles.
• OMSNEP01CL issues the Domino command TELL AMGR RUN "OMSMAIL.NSF" 'OMS3-4' and then goes into a never-ending job, activating every 7 minutes.

OMSMAIL Domino agent

The CL/RPG side of OMS produces a text file in /omsfiles. A Domino agent (written in LotusScript) is what actually parses the contents of this file. It then builds and sends the email, deletes the IFS file, and SQL-updates the OMS tables. The script is located in /domino/maggie/data/. It can be viewed/edited in HCL Designer.

Notes

• 2021-06 omsagent.nsf has been changed to archive the text file upon processing (instead of deleting). This is so I have some sample files to work with for the Java re-factoring. -norwizzle (talk)