Mappping missing For Transaction Processors (Doc ID 3006077.1)

Last updated on FEBRUARY 28, 2024

Applies to:

Goal

Need Mapping for below BDF's

1)v_paymnt_instrument_routing_cd is not mapped to instr_routg_cd in below
FrontOfficeTransaction.STG_ANNUITY_TXNS.sql
FrontOfficeTransaction.STG_MERCHANT_CARDS_TXNS.sql
FrontOfficeTransaction.STG_MM_TXNS.sql
FrontOfficeTransaction.STG_REPO_TRANSACTIONS.sql
FrontOfficeTransaction.STG_RETIREMENT_ACCOUNTS_TXNS.sql
FrontOfficeTransaction.STG_SWAP_ACCOUNT_TXNS.sql
FrontOfficeTransaction.STG_TERMDEPOSITS_TXNS.sql
FrontOfficeTransaction.STG_TRADING_ACCOUNT_TXNS.sql
FrontOfficeTransaction.STG_TRUSTS_TXNS.sql

2)8.1.2.4. BDF for transactions do not map v_card_no
The Processors for transactions do not map v_card_no in the CSA tables to
bank_card_id_nb. The field is present in the CSA tables as well as the front
and back office transactions tables. It hard codes null as the
bank_card_id_nb. This should map what is in the CSA for V_card_no to
bank_card_id_nb.

3)8.1.2.4 BDF v_instrument_code is not mapped for all transaction processors
as below
Scrty_intrl_id is hardcoded as NULL for the following processors (front and
back office).
stg_annuity_txns
stg_cards_payment_txns
stg_casa_txns
stg_correspondent_acct_txns
stg_leases_txns
stg_loan_contract_txns
stg_merchant_cards_txns
stg_mm_txns
stg_od_accounts_txns
stg_repo_transactions
stg_retirement_accounts_txns
stg_swap_account_txns
stg_termdeposits_txns

4)8.1.2.4 BDF v_origntr_to_benfcry_instrctns mapped in all processors for FOT
but is not mapped in below.
STG_MM_TXNS
STG_OD_ACCOUNTS_TXNS
STG_REPO_TRANSACTIONS

5)v_offset_account_id is mapped correctly for all Back Office Transaction
processors except for stg_swap_account_txns. It is hard coding null in that
bdf.

6)BDF 8.1.2.4 no mapping n_txn_amt_acy for BOT.stg_trusts_txns
he BDF are mapping N_TXN_AMT_ACY AS TRXN_RPTNG_AM in all back office
processors except BackOfficeTransaction.STG_TRUSTS_TXNS.sql. In this
processor n_txn_amt is being mapped to trxn_rptng_am which is inconsistent
with other processors.

Solution

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