Create a LOV in WebADI using an API Issue
Create a LOV in WebADI using an API
Using the below API for the same.
DECLARE
a NUMBER;
BEGIN
BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV
(P_APPLICATION_ID => 101,
P_INTERFACE_CODE => 'GL_INTERFACE_120',
P_INTERFACE_COL_NAME => 'ATTRIBUTE7',
P_ID_COL => 'VENDOR_NAME',
P_MEAN_COL => 'VENDOR_NAME',
P_DESC_COL => 'VENDOR_NAME',
P_TABLE => 'AP_SUPPLIERS',
P_ADDL_W_C => null,
P_WINDOW_CAPTION => 'SUPPLIER',
P_WINDOW_WIDTH => 400,
P_WINDOW_HEIGHT => 300,
P_TABLE_BLOCK_SIZE => 10,
P_TABLE_SORT_ORDER => 'ascending',
P_USER_ID => 2);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(SQLERRM);
END;
But the LOV is getting populated with Blank values