BNE_UIX_PHYSICAL_DIRECTORY is not configured in WebADI

Solution:

1. Navigate to System Administrator responsibility > Profile > System

2. Search for Profile ‘BNE UIX Physical Directory’.

3. Delete the value setup at the ‘Site’ level. Save your changes.

4. Bounce Application Server (or Apache) services.

5. Now go back and retry launching the Web ADI. The error will not appear any more.

If point 1 to 3 does not work, then try resetting the profile from SQLPLUS through the following command:

Begin
value := fnd_profile.save(‘BNE_UIX_PHYSICAL_DIRECTORY’,”,’SITE’);
commit;
End
----------------

SET PROFILE
----------
BNE Allow No Security Rule - YES

Read More ->>

WebADI Settings for Excel & Internet Explorer

When we are working with WEBAdi, we face macro setting issue in Excel.
Below are the steps to resolve it.

• Excel Settings

1) Open excel

2) File - Option - Trust Center - Trust Center Setting - Enable all macro & click on below check box (Trust center to the VBA project)

3) File - Option - Trust Center - Trust Center Setting - External Content - Prompt user about data & Prompt user on automatic update

• Internet Explorer Settings

Tools - Internet Options - Custom Level - Allow Status Bar via script - Enable

Read More ->>

Download RTF Template from Database

1 BY 1

========

SELECT file_name, file_content_type, file_data  FROM XDO_LOBS

WHERE xdo_file_type          = 'RTF'

AND   application_short_name = 'XXTEST'

ONCE IN A WHILE (Not guarntee to download all files)

====================================================

DECLARE

  l_file      UTL_FILE.FILE_TYPE;

  l_buffer    RAW(32767);

  l_amount    BINARY_INTEGER := 32767;

  l_pos       INTEGER := 1;

  l_blob      BLOB;

  l_blob_len  INTEGER;

  v_directory VARCHAR2(20) := 'ECX_UTL_LOG_DIR_OBJ';

  CURSOR c1 IS

   SELECT file_name, file_content_type, file_data  

   FROM   xdo_lobs

   WHERE  xdo_file_type          = 'RTF'

   AND    application_short_name = 'XXTEST';

BEGIN

 FOR r1 IN c1 LOOP

  IF UTL_FILE.is_open(l_file) THEN

      UTL_FILE.fclose(l_file);

    END IF;

  l_blob_len := DBMS_LOB.getlength(r1.file_data);

  l_file := UTL_FILE.fopen(v_directory,r1.file_name,'wb', 32767);

  -- Read chunks of the BLOB and write them to the file until complete.

  --

  WHILE l_pos < l_blob_len LOOP

   DBMS_LOB.read(r1.file_data, l_amount, l_pos, l_buffer);

   UTL_FILE.put_raw(l_file, l_buffer);

   l_pos := l_pos + l_amount;

  END LOOP;

  UTL_FILE.fclose(l_file);

 END LOOP;

 EXCEPTION

  WHEN OTHERS THEN

    -- Close the file if something goes wrong.

    DBMS_OUTPUT.PUT_LINE ( SQLERRM );

    IF UTL_FILE.is_open(l_file) THEN

      UTL_FILE.fclose(l_file);

    END IF;

END;

Read More ->>

GL Account Description

Below is the query for getting description of GL Account, change your Org_ID, Account_Code, Segment & CCID accordingly.

f

select gcc1.segment2||'.'||
(select gl_flexfields_pkg.get_description_sql
                                     ((select distinct ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id = 141),--- chart of account id
                                      2,----- Position of segment
                                      '404007'--gcc.segment2 ---- Segment value
                                     )
from gl_code_combinations gcc
where gcc.code_combination_id = 1013)
from gl_code_combinations gcc1
where gcc1.code_combination_id = 1013

Read More ->>

Ge the value of DFF

Flex field value and Description

select v.flex_value, v.flex_value_meaning, v.description
  from FND_FLEX_VALUE_SETS s, fnd_flex_values_vl v
 where s.flex_value_set_name = 'DEPARTMENT'
  and s.flex_value_set_id = v.flex_value_set_id;

Read More ->>

(ref:) tag in xml publisher template

Hi Friends,

When I was using MS Office 2010  for xml template, I face (ref:) tag issue in my template field, due to which my concurrent request are going into warning.

Here are the solution for this problem.

1) Open your report template

2) At the above right corner, go to Option button

3) On the Build tab click the Backward Compatible  radio button

4) Upload your template at XML Publisher Template

5) Run your request

Read More ->>

Oracle Report Builder Temporary Error

Sometime when we use Oracle Report Builder, a popup of temporary occurs, we can solve it through some changes in registry edit.
Below are the steps :


run --- regedit --- hk_current_user_machine --- software --- oracle --- devsuitehome1 ---- report_temp.

Change the value of report_temp from (C:\users\Admin~1\AppData\Local\Temp) to (C:\users\support1\AppData\Local\Temp)

Here support1 is my  windows user login A/c.

Read More ->>