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.

Query To get Run Results information

SELECT INITCAP(ppf.last_name
  ||','
  ||ppf.first_name) name,
  ety.element_name,
  to_number(rrv.result_value) commission
FROM per_all_people_f ppf,
  apps.per_assignments_f paf,
  apps.pay_assignment_actions pas,
  apps.pay_payroll_actions ppa,
  apps.pay_run_results rr,
  apps.pay_run_result_values rrv,
  apps.pay_element_types_f ety,
  apps.pay_input_values_f I
WHERE ppf.person_id          = paf.person_id
AND paf.assignment_id        = pas.assignment_id
AND pas.assignment_action_id = rr.assignment_action_id
AND ppa.payroll_action_id    = pas.payroll_action_id
AND rr.element_type_id       = ety.element_type_id
AND i.element_type_id        = ety.element_type_id
AND rrv.run_result_id        = rr.run_result_id
AND rrv.input_value_id       = i.input_value_id
AND sysdate BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND sysdate BETWEEN paf.effective_start_date AND paf.effective_end_date
AND sysdate BETWEEN ety.effective_start_date AND ety.effective_end_date
AND sysdate BETWEEN I.effective_start_date AND I.effective_end_date
AND i.name           = 'Pay Value'
AND ety.element_name = 'Salary' ;

To Reset Oracle Apps User id and Password From Backend

DECLARE
  v_user_name    VARCHAR2(30):=upper('HCM'); --HCM is username of my oracle Apps.
  v_new_password VARCHAR2(30):='welcome1';
  v_status       BOOLEAN;
BEGIN
  v_status   := fnd_user_pkg.ChangePassword ( username => v_user_name, newpassword => v_new_password );
  IF v_status =true THEN
    dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);
    COMMIT;
  ELSE
    DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
    ROLLBACK;
  END IF;
END;
/