Thursday, August 23, 2012

Oracle Apps: Install Jdeveloper 10g on Linux

Oracle Jdeveloper 10g installation steps on Linux Platform

Software: Oracle Linux 5 installed on Oracle VM on windows 7

Installing Sun SDK 1.4.2_03 for Linux:
For JDeveloper to run successfully, you must install Java SDK release 1.4.2_03 (or later releases). Perform the following steps:
1. Download the self-extracting binary file of version 1.4.2_03 (or later release) of the Sun J2SE for Linux  to your Linux machine.

oracle website for downloading JAVA SDK:
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase14-419411.html#j2sdk-1.4.2_30-sol-JPR

2. Follow the instructions provided on the JavaSoft Web site to install the Java SDK. Note the install location when it is complete.Execute below command using root user in the directory where you downloaded the file
       ./j2sdk-1_4_2_19-linux-i586.bin

Note:
preferably install it in  /usr/java, I got it installed it in /media/sf_ebusiness/j2sdk1.4.2_19


Installing JDeveloper
To install JDeveloper, perform the following steps:
1. Download Oracle10g JDeveloper 9.0.5.1 from http://otn.oracle.com/software/products/jdev/index.html.

2. Open a terminal window and execute the following:
               cd /home/oracle
               mkdir -p jdevoaf
               cd jdevoaf
               unzip <path to zip file>/jdev9051.zip
                  
The JDeveloper software installation is complete. The software now must be configured.


Configuring JDeveloper and SDK
1. Using the text editor gedit or your editor of choice, open the file /home/oracle/jdevoaf/jdev/bin/jdev.conf .

2. Find the SetJavaHome parameter. Change
      # SetJavaHome c:\jdk1.4.2_03
                          to the location where the Java SDK was installed.
      Example:
        SetJavaHome /media/sf_ebusiness/j2sdk1.4.2_19

3. Save the jdev.conf file and exit gedit .


Modifying Your .bash_profile
Now that you have installed JDeveloper, you need to update the /home/oracle/.bash_profile and change your path accordingly. Perform the following steps:

1. Applications>System tools>File Browser
    Because the .bash_profile is hidden you need to enable show hidden files in the browser
    For this tick View>Show hidden files
    Now the file will be visible double click to edit it.

2. Make sure the PATH includes the location for JDeveloper and the Java SDK. Modify the file as below

           JDEV_HOME=/home/oracle/jdevoaf        
           PATH=$PATH:$JDEV_HOME/jdev/bin:/media/sf_ebusiness/j2sdk1.4.2_19;
           export PATH
           export JDEV_HOME

3. Save the .bash_profile file

4. You now need to source the file. Open a terminal window and execute the following commands:
          cd
          . ./.bash_profile


Configuring OC4J
To deploy applications in JDeveloper, you must configure OC4J. Perform the following steps:
1. From a terminal window, execute:                        
        cd /home/oracle/jdevoaf/j2ee/home
        java -jar oc4j.jar -install
                             
    At the prompt, enter the password oracle .

Modifying Permissions of Files in Linux
You must carry out a few tasks before running JDeveloper. Perform the following steps:1.  To set the proper permissions, execute the following commands from your terminal window:
chmod -R g+r /home/oracle/jdevoaf/
chmod +x /home/oracle/jdevoaf/jdev/bin/jdev
chmod +x /home/oracle/jdevoaf/jdev/bin/ojc
chmod +x /home/oracle/jdevoaf/jdev/bin/start_oc4j
chmod +x /home/oracle/jdevoaf/jdev/bin/stop_oc4j
chmod -R g+w /home/oracle/jdevoaf/j2ee/home/application-deployments
chmod -R g+w /home/oracle/jdevoaf/j2ee/home/applications
chmod -R g+w /home/oracle/jdevoaf/j2ee/home/config


Adding an Icon to Your Panel
To create an icon on your panel in JDeveloper, perform the following steps:1. Right-click on the desktop (not in the toolbar, an icon, or a window). Select New Launcher from the drop-down menu.

2.  In the Create Launcher Applet window, enter the following and then click No Icon.

           Name: JDeveloper 10g 9.0.5.1
           Comment: JDeveloper 10g 9.0.5.1
           Command: /home/oracle/jdevoaf/jdev/bin/jdev

3.  Enter /home/oracle/jdevoaf/jdev/bin/ in the directory field and select coffee.png .
     Then click OK.

4.  Click OK again to create the icon on the panel.


Running JDeveloper
To run JDeveloper, perform the following steps:
1. Click the icon that you just created in the panel.

2. The first time you run JDeveloper, you may get a message stating that your jdevhome directory does not exist and asking if you want to create it. Click Yes.


at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database 

Tuesday, August 14, 2012

Oracle XML Publisher Report: An Invalid character was found in text content

The following Error can be observed when Oracle XML Report data can contain foreign characters like Norwegian æøå, or french êèé. The  Output processor fails to process the data and the report logs shows follwoing error

"An Invalid character was found in text content"

Solution:
1. Find out the encoding that has been setup at the SITE leve using this query

SELECT po.user_profile_option_name, po.profile_option_name "NAME"
, DECODE (TO_CHAR (pov.level_id), '10001', 'SITE'
, '10002', 'APP', '10003', 'RESP', '10004', 'USER', '???') "LEV"
, DECODE (TO_CHAR (pov.level_id)
, '10001', '', '10002', app.application_short_name
, '10003', rsp.responsibility_key, '10004', usr.user_name, '???')
"CONTEXT"
, pov.profile_option_value "VALUE"
FROM apps.fnd_profile_options_vl po, apps.fnd_profile_option_values pov
, apps.fnd_user usr, apps.fnd_application app, apps.fnd_responsibility rsp
WHERE (po.profile_option_name = 'FND_NATIVE_CLIENT_ENCODING')
AND pov.application_id = po.application_id AND pov.profile_option_id =
po.profile_option_id
AND usr.user_id(+) = pov.level_value AND rsp.application_id(+) =
pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value AND app.application_id(+)
= pov.level_value
ORDER BY "NAME", pov.level_id, "VALUE"

2. Based on the above value setup in the PROFILE, set the XML TAG LINE as the first line of the Program output.

<?xml version="1.0" encoding="UTF-8"?>

<?xml version="1.0" encoding="UTF-16"?>
<?xml version="1.0" encoding="ISO-8859-1"?>

 <?xml version="1.0" encoding="windows-1252"?>

Also if none of the above options works try to use REPLACE function and remove the Special characters from the XML Output.

So your output should look like this

<?xml version="1.0" encoding="UTF-8"?><REPORT>
<REC><GL_PERIOD>01-12</GL_PERIOD><FISCAL>2012</FISCAL><QT>Q4-12</QT></REC>
</REPORT>



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database 



Oracle XML Publisher Report: Number/Date format in Excel

Leading zero issues/ Number Formatting while opening in Excel
In case of Oracle XML Publisher report which needs to be opened in Excel, Excel tends to manipulate with the formats of Number and Date. This is really annoying as all the formatting that has been achieved through the Program or Formatting tags in Template don't seem to work.

A simple solution for this problem is to override the Excel formatting, by enclosing your XML tag in the template with below XML code

Before:
<?STAT?>

After:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?STAT?></fo:bidi-override>








at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database