To Create LOV and Date (calendar)LOV for WebADI

To create window LOV (value set) and Date LOV(calendar) for WebADI cloumns

--To Create LOV
declare
  ln_application_id  number;
  lc_integtr_code    varchar2 (50);
  lx_interface_code  varchar2 (50);
  lx_param_list_code varchar2 (50);
  ln_application_id  number;
begin
  bne_integrator_utils.create_table_lov (
  p_application_id => 800,
  p_interface_code => '<INTERFACE_CODE>',
  p_interface_col_name => '<P_FULL_NAME>', ----proc params
  p_id_col => 'LOOKUP_CODE',
  p_mean_col => 'LOOKUP_CODE',
  p_desc_col => null (or 'DESCRIPTION'),
  p_table => 'FND_COMMON_LOOKUPS',
  P_ADDL_W_C => ' LOOKUP_TYPE=''XX'' AND ENABLED_FLAG =''Y''',
  p_window_caption => 'SELECT Full Name',
  p_window_width => 400, p_window_height => 300,
  p_table_block_size => 10,
  p_table_sort_order => 'Yes',
  p_user_id => 83087 );
end;
/


-- To Add Date LOV(calender) to Web ADI Column
   declare
   ln_application_id    number;
   lc_integtr_code      varchar2 (50);
   lx_interface_code    varchar2 (50);
   lx_param_list_code   varchar2 (50);
   ln_application_id    number;
begin
   bne_integrator_utils.create_calendar_lov
                                (p_application_id          => 800,
                                 p_interface_code          => '<interface_code>',
                                 p_interface_col_name      => 'P_START_DATE',--proc params
                                 p_window_caption          => 'Select Date',
                                 p_window_width            => 400,
                                 p_window_height           => 300,
                                 p_table_columns           => 'START_DATE',
                                 p_user_id                 => 83087
                                );
end;
/

To Delete an Integrator and Interface from back end

-- To Get Integrator_code :
 SELECT applicatioN_id, Integrator_code, user_name FROM bne_integrators_vl
WHERE user_name  = '<Integrator Name>';

--To Get Interface Code :
SELECT * FROM bne_interfaces_b WHERE Integrator_code = '<Integrator_code>';

-- To Get interface columns :
SELECT * FROM bne_interface_cols_b WHERE interface_code = '<interface_code>';

--To Delete an Interface :
DECLARE
   v_value   NUMBER;
BEGIN
   V_VALUE :=
      bne_integrator_utils.DELETE_INTERFACE (800, '<interface_code>');
   DBMS_OUTPUT.put_line (v_value);
END;
/
commit;
/
 *800 is Application_id

--To Delete an Intergrator :
declare
l_number number:=0;
begin
l_number:=BNE_INTEGRATOR_UTILS.DELETE_INTEGRATOR(P_APPLICATION_ID => 800 ,
P_INTEGRATOR_CODE => '<integrator_code>');
dbms_output.put_line(' l_number : '||l_number);
end;
/
COMMIT;
/
*800 is Application_id

"BNE_UIX_PHYSICAL_DIRECTORY is not configured".

While generating the document through WEB ADI, the below error message is coming.
"BNE_UIX_PHYSICAL_DIRECTORY is not configured".

Solution

Make sure that no value for the profile option BNE_UIX_PHYSICAL_DIRECTORY exists in all R12 templates.

To implement the solution, please execute the following steps:

1. Go into the responsibility: System Administrator

2. Navigate to Profile -> System -> Profile: BNE%Directory%

3. Remove any value in the profile BNE_UIX_PHYSICAL_DIRECTORY (null value is the default)

4. Bounce the web server and retest the issue.

 

WebADI Web Applications Desktop Integrator

Web Applications Desktop Integrator

Web ADI brings Oracle E-Business suite to the desktop where familiar desktop tool like Excel can be used to create spreadsheet, enter(create) and modify(Update) data in the spreadsheet and finally upload the data into the Oracle Applications with or without validation.

Prerequisite steps to ensure that Web ADI works for you:

Add Responsibility to the user

• System Admin -->Security --> User --> Define
• Assign ‘Desktop Integration Manager’ and 'Desktop Integration' responsibility to your user. This responsibility has the menu ‘Desktop Integration Manager Menu’ and 'Desktop Integration Menu' associated with it.

Set Profile Option

•  System Admin --> Profile --> System
• Set profile option  ‘BNE Allow No Security Rule’ to ‘Yes’  at site level.

Enable Macros for Excel 2007

• Enable macros for Microsoft Excel.

Macros in excel 2007 for web adi(Oracle E-Business Suite)

 Excel 2007:

• Open Start button and select Microsoft Office Excel 2007
• Click the Office Button (top-left button in the window) 
• Click the 'Excel Options' button.
• Click 'Trust Center' link from the menu on the left.
• Click 'Trust Center Settings' button.
• In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
• Under 'Macro Settings' check ‘Enable all Macros(not recommended; potentially dangerous…’).
• Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
• Click 'OK' button to close the 'Trust Center' window.