I have a custom integrator, created a layout and mapping
and I have update the BNE_INTERFACE_COLS_B table for the column that I want as an LOV.
LOV_TYPE = STANDARD
val_obj_name = 'FA_BOOK_CONTROLS_SEC'
val_addl_w_c= 'NVL(DATE_INEFFECTIVE,SYSDATE) >= SYSDATE AND BOOK_CLASS IN (''CORPORATE'',''TAX'')',field_size = 15
val_component_code = 'FA_BOOK_TYPE_CODE'
val_component_app_id = 140
val_type = TABLE
The LOV is showing up fine, but when I select the value the , selected value is not getting populated in the excel cell.
Can you please help me resolve this? This is urgent.
Please use ' Web ADI - Interface Columns Integrator' to solve your issue.
For this you need to do following things :
SET ENABLED_FLAG = 'Y'
where integradtor_code= 'INTERFACE_COLS;
Then create a web adi function and attach to web adi menu.Call form function association integrator and attach the form function to your integrator.( Interface_cols)
Then download your custom integrator using ' Web ADI - Interface Columns Integrator' and then change the property of yor interface columns
Can you please give more details?
On my end I have the same issue but one of my LOVs is not populating the cell while the other does. But I never performed any of the action you mentionned.
So I would like to try your solution for the remaining LOV that does not populate my Excel cell. What is the purpose of "Then create a web adi function and attach to web adi menu.Call form function association integrator and attach the form function to your integrator.( Interface_cols)"? and what kind of "function" should we create?
Thanks and regards,
Edited by: Gaël on 21 sept. 2012 08:16