Key flexfield (KFF) validation in custom webadi template

I executed the following steps to  accomplish the validation of key flexfields :-

Step1 :- In the main procedure for the custom integrator, added a column which is not a table mapped column before registering the integrator. This column will only be present in the layout.Eg:- segment_name.

Step2 :- Updated the following columns of the bne_interface_cols_b for column(segment_name) mentioned in step1 using the update api present in the package BNE_INTERFACE_COLS_PKG.

LOV_TYPE='STANDARD',

OFFLINE_LOV_ENABLED='Y',

VAL_OBJ_NAME='oracle.apps.bne.integrator.validators.BneAccountingFlexValidator',

GROUP_NAME='TEST',

OA_FLEX_CODE='GL#' (code of KFF),

OA_CONCAT_FLEX='N'(to keep values in separate column on upload)

VAL_TYPE='KEYFLEX',

VAL_COMPONENT_CODE='OA_FLEX',

VAL_COMPONENT_APP_ID='231',

OA_FLEX_APPLICATION_ID='101'(application id of KFF),

DATA_TYPE=null,

UPLOAD_PARAM_LIST_ITEM_NUM=null

Step3 :- Updated the bne_interface_cols_b  for the child fields or table mapped fields for which the column created in step1 is parent using the package BNE_INTERFACE_COLS_PKG.Columns which should be updated :

DISPLAY_FLAG='N',

GROUP_NAME='TEST' (one created for parent),

VAL_TYPE='KEYFLEXSEG'.

Step4: Created the layout using Oracle WebADI responsibility and added the parent column in the layout. After  downloading the webadi, the parent column was an LOV(KFF) validated field and the data from the LOV(KFF) will be mapped to the child table mapped columns on upload.