Initializing apps

DECLARE
   L_APPL_ID             number;
   l_appl_name           VARCHAR2 (100) := 'PER';
   L_USER_ID             number;
   l_user_name           VARCHAR2 (100) := 'XX_ADMIN';
   l_responsibility_id   NUMBER;
   l_resp_name           VARCHAR2 (200) := 'US Super HRMS Manager';
BEGIN

-- To get the Application ID of given Application.
   SELECT application_id
     INTO l_appl_id
     FROM fnd_application
    WHERE application_short_name = l_appl_name;

-- To get the User ID information of  given user
   SELECT user_id
     INTO l_user_id
     FROM fnd_user
    WHERE user_name = l_user_name;

-- To get the Resp ID information of the given responsibility.
   SELECT responsibility_id
     INTO l_responsibility_id
     FROM fnd_responsibility_tl
    WHERE responsibility_name = l_resp_name AND application_id = l_appl_id;

--Initialixze the Application to use the API.
   fnd_global.apps_initialize (l_user_id, l_responsibility_id, l_appl_id);
END;

How to format XML in Notepad++?

I have notepad++ and I got some XML code which is very long. When I pasted it in Notepad++,
there is a long line of code.(difficult to read and work with.)
Now, I want to know if there is a simple way to make the text readable. (by readable I mean properly tabbed code)

Here is the solution follow the process.
--plugins --plugin manager --show plugin manager --check XML tools
--install
--restart NOTEPAD++
--open xml file --plugins --XML tools --pretty print(xml only -- with line breaks)

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.