Conductor Type Code Column Length Mismatch Between CSA And FCDM (Doc ID 2933911.1)

Last updated on APRIL 24, 2023

Applies to:

Goal

While we were mapping CSA table STG_CARDS_PAYMENT_TXNS, we realized that the column V_TXN_CNDTR_TYPE_CD is defined as VARCHAR2(1), while the target column in FCDM (CURRENCY_TRXN.CNDTR_TYPE_CD) is defined as VARCHAR2(3). According to the CSA specifications, the values allowed for column V_TXN_CNDTR_TYPE_CD are:

Type (Role) of the conductor in the transaction. List of Values are:
A-Person conducting transaction on own behalf;
B-Person conducting transaction for another;
D-Courier Service (private)

But the supported values for CNDTR_TYPE_CD are:

50 (Person conducting transaction on own behalf)
17 (Person conducting transaction for another)
23 (Person on whose behalf transaction is conducted)
58 (Common Carrier)

We're wondering how the values A, B or D are converted to the values expected by FinCEN (50, 17, 23 or 58) when the CTR is generated. We didn't find anything in the BDFs or T2Ts that would do this conversion.

 

Solution

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