Checking operating system version: must be 5.0, 5.1 or 5.2 . Actual 6.1

Error showing during installation of Oracle DevsuiteHome (Form & Reports)
Checking operating system version: must be 5.0, 5.1 or 5.2 . Actual 6.1

Solution:
 1) Find oraparam.ini file in DevsuiteHome Folder
2) Add value 6.0, 6.1 in Windows under [Certified Versions]
3)  Save & Continue at  DevsuiteHome Installation.

Next Screen could be shown a virtual memory error.
Soultion :
1) Right Click on My Computer
2) Advance System Setting
3) Advance 
4) Setting under Performance block
5) Again "Advance"  & click  on change
6) Uncheck Automatically managing paging...
7) Select  C drive, Custom Size radio button & Enter Recommended Value as mentioned below
8) Set & Ok
9) Continue to DevsuiteHome Installation.

Best of luck...

Read More ->>

Create Entry in Host File for Application

Facing problem when we create new entry in Host file, it save as with a  .txt file instead  of its original extension.

Follow  the below steps:

1. Go to Start > run Notepad.
2. Right click on the Notepad icon and select Run as a administrator.
3. Select Open from the File menu option.
4. Browse to c:\windows\system32\drivers\etc\hosts.
5. Add the host name and IP address to the bottom of the host file.
6. Save the host file.

Read More ->>

Integrator not showing in list in WebADI

First of  all ensure that you have check on "Create document page" during creation on integrator.

After that If your are not able to view the Custom Integrator in Create Document then follow the below steps :
1) Manage Integrator from Desktop Integrator Manager Responsibility
2) Query your integrator name & click on Update (Pencil)
3) Click on Next
4) Click on Add Functions 
5) Search By Code & Enter BNE_ADI_CREATE_DOCUMENT & Select
6) Again Search By Code & Enter BNE_CREATE_DOCUMENT & Select

Although I suggest you to create your objects (Integrator / Layout) with starting alphabets not by 'XX%'

Read More ->>

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 ->>