B.3 Adding New Field in KYC Onboarding JSON Request

To add a new field in KYC OB Request JSON, follow these steps:

1. Open the KYCOBrequestJsonSchema.json file in the $FIC_HOME/Onboarding/ InitiateOnboardingService/WEB-INF/classes path.

   Replace the {new_field_business_name} placeholder value in the following script under the properties tag.

   "{new_field_business_name}": {
   "$id": "#/properties/OnboardingCustomer/properties/ {new_field_business_name}",
   "type": "string",
   "title": "The {new_field_business_name} Schema",
   "default": "",
   "examples": [
   ""
   ],
   "maxLength": 1
   }
   

2. Create a column in the FCC_OB_CUST table.

   Example: CUSTOM_FLAG_COLUMN_NAME

   Note:

   Make sure to take a backup of FCC_OB_CUST table when any official patch is getting applied.
3. 3. Replace the {CUSTOM_FLAG_COLUMN_NAME} and {new_field_business_name} placeholder values in the following script and execute it in the Atomic schema.

   MERGE INTO FCC_OB_PHY_BUS_COL_NM_MAP T USING ( 
   SELECT 'FCC_OB_CUST' TABLE_NAME, '{CUSTOM_FLAG_COLUMN_NAME}' 
   COLUMN_NAME, '{new_field_business_name}' BUSINESS_NAME, 'STRING' 
   COLUMN_TYPE, '' COLUMN_LENGTH FROM DUAL) S 
   ON ( T.TABLE_NAME = S.TABLE_NAME AND T.COLUMN_NAME = S.COLUMN_NAME )
   WHEN MATCHED THEN UPDATE SET T.BUSINESS_NAME = S.BUSINESS_NAME, 
   T.COLUMN_TYPE = S.COLUMN_TYPE, T.COLUMN_LENGTH = S.COLUMN_LENGTH 
   WHEN NOT MATCHED THEN INSERT 
   (TABLE_NAME,COLUMN_NAME,BUSINESS_NAME,COLUMN_TYPE,COLUMN_LENGTH)
   VALUES 
   (S.TABLE_NAME,S.COLUMN_NAME,S.BUSINESS_NAME,S.COLUMN_TYPE,S.COLUMN_LENGTH)

4. Execute the ant.sh file in the $FIC_HOME/Onboarding path.
5. Stop the OFSAA Services.
6. 6. Create the InitiateOnboardingService EAR/WAR file and redeploy this new war on the web application server. See the Behavior Detection Installation Guide for the steps related to deployment.
7. Restart the OFSAA services.