Unable to see the LOV for the column in Custom Integrator
I have created a Custom Integrator for a Custom table.
Then Added a POPLIST for one of the column using the following command.
UPDATE bne_interface_cols_b
SET val_id_col = 'USER_NAME',
val_mean_col = 'USER_NAME',
val_type = 'TABLE',
lov_type = 'POPLIST',
val_obj_name = 'FND_USER',
val_addl_w_c = '(START_DATE > SYSDATE) AND (END_DATE < SYSDATE OR END_DATE IS NULL)'
WHERE interface_col_name = 'USER_NAME'
AND application_id = 101
AND interface_code = 'GCM_CUSTOM_IMPORT_3_INTF'
When I tried to create document to load the data, I am not able to see the POPLIST which I have attaced to the column (USER_NAME in my custom table also).