Pipeline Updates for Party Identification Documents
In this release, the STG_CUSTOMER_IDENTIFCTN_DOC table has been replaced with the STG_PARTY_IDENTIFICATION_DOC table. Existing customers must load data to the new table.
To accommodate the change, the following pipelines have been updated:
- Load Customer Staging Data
- Data Loading File Transfer
- Load Customer Add On Data
The V_CUST_TYPE_CD column is now nullable in the following tables:
- FCC_CUST_ID_DOC
- FCC_KYC_P_CUST_ID_DOC
- FCC_CM_CASE_CUST_ID_DOC
- FCC_CM_CASE_CUST_ID_DOC_AUDIT
- FCC_CM_CUST_ID_DOC_EV
These pipeline updates provide greater integration with other Oracle Cloud products.
Steps to Enable
For new customers, no changes are required to Out-of-Box pipelines.
Existing customers must load data to STG_PARTY_IDENTIFICATION_DOC by updating their pipelines using these steps:
- Load Customer Staging Data: Replace the STG CUSTOMER_IDENTIFCTN_DOC table widget with the STG_PARTY_IDENTIFICATION_DOC table widget. The template for this table is STG_PARTY_INDENTIFICATION_DOC.csv
- Data Loading File Transfer:: Replace the STG CUSTOMER_IDENTIFCTN_DOC table widget with the STG_PARTY_IDENTIFICATION_DOC table widget. The template for this table is STG_PARTY_INDENTIFICATION_DOC.csv
- Load Customer Add On Data: Replace the Stage Customer ID Documents dataset with the Stage Party ID Documents dataset and modify the Customer ID Documents persist widget to incorporate this dataset. Then, map all columns of the Stage Party ID Documents table (excluding the V_CUST_TYPE_CD column) to the KYC Customer ID Doc table.