9.1 Adding New Message Type in NACHA

To add new NACHA message type in the Data Base (DB) perform the subsequent steps:

1. Goto ConvAchData.ctl file in the #FTPSHARE_PATH#/#INFODOM#/STAGE/US_NACHA/ conf directory.
2. The ConvAchData.ctl file has the entries for all NACHA Message types. To add an entry for the new message type, open ConvAchData.ctl file and follow the below example format to provide the entry.
   Entry for message type CCD:

   INTO TABLE FCC_ACH_IP
   WHEN (V_BTH_HDR_STANDARD_ENTRY_CODE='CCD') (
   V_NACHA_MSG_ID "SEQ_TF_NACHA.NEXTVAL",
   V_HDR_RECORD_TYPE_CODE POSITION(1:1) CHAR TERMINATED BY WHITESPACE,
   N_HDR_PRIORITY_CODE POSITION(2:3) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   V_HDR_IMMEDIATE_DESTINATION POSITION(4:13) CHAR TERMINATED BY WHITESPACE,
   V_HDR_IMMEDIATE_ORIGIN POSITION(14:23) CHAR TERMINATED BY WHITESPACE,
   V_HDR_TXN_DATE POSITION(24:29) CHAR TERMINATED BY WHITESPACE,
   V_HDR_TXN_TIME POSITION(30:33) CHAR TERMINATED BY WHITESPACE,
   V_HDR_FILE_ID_MODIFIER POSITION(34:34) CHAR TERMINATED BY WHITESPACE,
   V_HDR_RECORD_SIZE POSITION(35:37) CHAR TERMINATED BY WHITESPACE,
   V_HDR_BLOCKING_FACTOR POSITION(38:39) CHAR TERMINATED BY WHITESPACE,
   V_HDR_FORMATCODE POSITION(40:40) CHAR TERMINATED BY WHITESPACE,
   V_HDR_IMMEDIATE_DEST_NAME POSITION(41:63) CHAR TERMINATED BY WHITESPACE,
   V_HDR_IMMEDIATE_ORIGIN_NAME POSITION(64:86) CHAR TERMINATED BY WHITESPACE,
   V_HDR_REFERENCE_CODE POSITION(87:94) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_RECORD_TYPE_CODE POSITION(95:95) CHAR TERMINATED BY WHITESPACE,
   N_BTH_HDR_SERVICE_CODE POSITION(96:98) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   V_BTH_HDR_COMPANY_NAME POSITION(99:114) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_COMPANY_DISC_DATE POSITION(115:134) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_COMPANY_ID POSITION(135:144) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_STANDARD_ENTRY_CODE POSITION(145:147) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_COMPANY_ENTERY_DESC POSITION(148:157) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_COMPANY_DESC_DATE POSITION(158:163) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_EFFECTIVE_ENTRY_DATE POSITION(164:169) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_SETTLEMENT_DATE POSITION(170:172) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_ORG_STATUS_COD POSITION(173:173) CHAR TERMINATED BY WHITESPACE,
   V_BTH_HDR_ORG_DFI_ID POSITION(174:181) CHAR TERMINATED BY WHITESPACE,
   N_BTH_HDR_BATCH_NUMBER_RAW POSITION(182:188) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   V_ENTRY_RECORD_TYPE_CODE POSITION(189:189) CHAR TERMINATED BY WHITESPACE,
   N_ENTRY_TRXN_CODE POSITION(190:191) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   V_ENTRY_RECEVING_DFI_ID POSITION(192:199) CHAR TERMINATED BY WHITESPACE,
   V_ENTRY_CHECK_DIGIT POSITION(200:200) CHAR TERMINATED BY WHITESPACE,
   V_ENTRY_DFI_ACC_NUM POSITION(201:217) CHAR TERMINATED BY WHITESPACE,
   V_ENTRY_AMOUNT POSITION(218:227)CHAR TERMINATED BY WHITESPACE,
   V_ENTRY_INDIVIDUAL_ID_NUM POSITION(228:242) CHAR TERMINATED BY WHITESPACE,
   V_ENTRY_RCV_COMPANY_NAME POSITION(243:264) CHAR TERMINATED BY WHITESPACE,
   V_ENTRY_DISCRETIONARY_DATE POSITION(265:266) CHAR TERMINATED BY WHITESPACE,
   V_ENTRY_ADD_RECORD_INDICATOR POSITION(267:267) CHAR TERMINATED BY WHITESPACE,
   N_ENTRY_TRACE_NUMBER POSITION(268:282) CHAR TERMINATED BY WHITESPACE,
   N_TRACE_NUMBER POSITION(276:282) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   V_ADDENDA_TYPE_CODE POSITION(284:285) CHAR TERMINATED BY WHITESPACE,
   V_ADDENDA_RECORD POSITION(283:376) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_RECORD_TYPE POSITION(377:377) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_SERVICE_CODE POSITION(378:380) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   N_BTH_CTL_ENTRY_ADDENDA_COUNT POSITION(381:386) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   N_BTH_CTL_ENTRY_HASH POSITION(387:396) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   V_BTH_CTL_DEBIT_AMOUNT POSITION(397:408) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_CREDIT_AMOUNT POSITION(409:420) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_COMPANY_ID POSITION(421:430) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_MSG_AUTH_CODE POSITION(431:449) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_RESERVED POSITION(450:455) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_ORG_DFI_ID POSITION(456:463) CHAR TERMINATED BY WHITESPACE,
   V_BTH_CTL_BATCH_NUM POSITION(464:470) CHAR TERMINATED BY WHITESPACE,
   V_CTL_RECORD_TYPE POSITION(471:471) CHAR TERMINATED BY WHITESPACE,
   N_CTL_BATCH_COUNT POSITION(472:477) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   N_CTL_BLOCK_COUNT POSITION(478:483) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   N_CTL_ENTRY_COUNT POSITION(484:491) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   N_CTL_ENTRY_HASH POSITION(492:501) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   V_CTL_TOTAL_DEBIT_AMOUNT POSITION(502:513) CHAR TERMINATED BY WHITESPACE,
   V_CTL_TOTAL_CREDIT_AMOUNT POSITION(514:525) CHAR TERMINATED BY WHITESPACE,
   V_CTL_RESERVED POSITION(526:564) CHAR TERMINATED BY WHITESPACE,
   N_FILE_ID POSITION(565:571) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
   N_BTH_HDR_BATCH_NUMBER "trim(:N_FILE_ID
   )||''||trim(:N_BTH_HDR_BATCH_NUMBER_RAW)",
   N_TXN_ID "trim(:N_FILE_ID
    )||''||trim(:N_BTH_HDR_BATCH_NUMBER_RAW)||''||trim(:N_ENTRY_TRACE_NUMBER)",
   V_PATH POSITION(572:641) CHAR TERMINATED BY WHITESPACE,
   V_filename POSITION(642:900) CHAR TERMINATED BY WHITESPACE
   )

   Note:

   The V_HDR_RECORD_TYPE_CODE column name in FCC_ACH_IP table has the value of POSITION (1:1). This position is given per message specification. Similarly, entries will be added for other parameters per the Message standards.
3. Save and run the ConvAchData.ctl file to load the newly added message data in to the DB.

The Enterprise Data Quality (EDQ) configurations for each message must be configured in the FCC_ACH_EDQ_CONF table and Inline Processing Engine (IPE) configurations for each message must be configured in FCC_ACH_IPE_CONF table. For more information on FCC_ACH_EDQ_- CONF table and FCC_ACH_IPE_CONF table, see Oracle Financial Services Data Model Reference Guide