1.1.1 Oracle Banking Treasury Management

OBTR needs below resources before deployment. Create the following queues and connection factories in the application server.

Table 1-1 JMS Connection Factories

QCF Label QCF
Notify Destination QCF NotifyDestQCF
Deferred QCF DefferedDestQCF
Notify QCF NOTIFY_MDB_QCF
Incoming QCF EmsQcf
GI Upload QCF GI_UPLOAD_QCF
Sanction Check QCF SNCKREQQCF
<Internally Referred> ELMDBQCF
<Internally Referred> EL_NOTIFY_QCF

Table 1-2 Queues

QUEUE Label QUEUE
Notify Destination Queue Name NOTIFY_DEST_QUEUE
Deferred Queue Name DEFFERED_DEST_QUEUE
Notify Queue Name NOTIFY_QUEUE
Dead Letter Queue name NOTIFY_QUEUE_DLQ
Incoming BackupQueue name EMS_QUEUE_BACK
Incoming Dead Letter Queue name EMS_QUEUE_DLQ
Incoming Queue Name EMS_INQUEUE
Outgoing Queue Name EMS_OUTQUEUE
SFMS Incoming Queue SFMS_INQUEUE
RTGS Incoming Queue RTGS_INQUEUE
GI Upload Queue Name INTERNAL_GI_UPLOAD_QUEUE
GI Upload Dead Letter Queue Name INTERNAL_GI_UPLOAD_DLQ
BulkerMDB Queue EMS_BULKERQUE
Sanction Check Request Queue SNCKREQ_QUEUE
Sanction Check Response Queue SNCKRES_QUEUE
Sanction Check Listener Queue SNCKASYNC_QUEUE
<Internally Referred> ELMDB_REQ_Q
<Internally Referred> ELMDB_RES_Q
<Internally Referred> ELMDB_DLQ
<Internally Referred> EL_NOTIFY_REQ_Q
<Internally Referred> EL_NOTIFY_RES_Q
<Internally Referred> EL_NOTIFY_DLQ

Table 1-3 Data Source

Datasource Name Datasource Label Type Default Value
INIT_DATASOURCE Data Source NON-XA jdbc/fcjdevDS
BRANCH_CENTRALIZED_DS Data Source XA jdbc/fcjDevXADS
SCHEDULER_DS Scheduler Datasource XA jdbc/fcjSchedulerDS

Note:

You need to create two more data sources for Oracle FCUBS.
  • Scheduler: You need to create an XA data source for Oracle FCUBS with the JNDI name ‘_XA’ for the scheduler. For example, if the Oracle FCUBS HOST Non XA data source JNDI name is jdbc/fcjdevDS, then you need to create another data source for FCUBS with the JNDI name jdbc/fcjdevDS_XA.
  • Batch Process: You need to create the data source for Oracle FCUBS with the JNDI name ‘_ASYNC for the batch process. For example, if the Oracle FCUBS HOST Non XA data source JNDI name is jdbc/fcjdevDS, then you need to create another data source for FCUBS with the JNDI name jdbc/fcjdevDS_ ASYNC.