Oracle Apps Developers

Wednesday, November 26, 2014

Status addition in Mantis Hub.

How to add new status on Mantis Hub.

http://www.mantisbt.org/manual/admin.customize.status.html

Configure webutill on forms 11g

https://community.oracle.com/thread/2346639?tstart=0

Download webutill on
http://www.oracle.com/technetwork/indexes/downloads/index.html#middleware

Tuesday, August 20, 2013

How to Run Foms on Window 7

Testing Oracle 10g developer forms locally (On Windows 7)

Okay guys, another post after another break :) This time we are going to figure out how to test your Oracle 10g developer forms locally. Until recent comments we were not knowing that fellow folks were having issues running developer 10g forms locally on Windows 7 machines. Okay here we go
Step 1
Install the latest java run time from here and make sure you are installing 32bit. Usually java 32bit gets installed under this path “C:\Program Files (x86)\Java\jre6″
Following is test environment


OS: Windows 7 64bit Professional Editions, 3GB 
Mem
10g Developer: Forms 
[32 Bit] Version 10.1.2.0.2 (Production)
Database: Oracle Database 10g Enterprise Edition 
Release 10.2.0.3.0 - Production

Usually when you try to run a form locally for the first time after starting the OC4J instance, an older version of java initiator is installed in your system. I don’t quite remember whether the installation offers any kind of customization so that the end user could change the path or other options. I won’t recommend one either!
If you have done a standard installation, the java initiator should get installed on this path “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22″.

Step 2
In order to let Developer 10g forms run locally you need to change the jvm.dll file found under “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22\bin\hotspot” with a most recent one. As we installed the latest java run time 32bit in “Step 1″, browse to the following folder “C:\Program Files (x86)\Java\jre6\bin\client” copy the jvm.dll which is above 2MB in size, and go back to folder “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22\bin\hotspot”
Now paste the new jvm.dll file inside this folder and try to run the forms again! It should work now!

Wednesday, April 17, 2013

Tool for performance and tuning.

It is a tools where we can evaluates the query performance with explain plan.
Download and Enjoy!

http://www.conquestsoftwaresolutions.com/page/clearsql_pr_description

Thursday, April 11, 2013

Data Encrytion

10G

http://www.oracle-base.com/articles/10g/transparent-data-encryption-10gr2.php#encrypted_column

11G
http://www.oracle-base.com/articles/11g/tablespace-encryption-11gr1.php

Column Level Encryption.

http://docs.oracle.com/cd/B19306_01/network.102/b14268/asotrans.htm

Wednesday, April 10, 2013

rita pmp 7th edition

http://www.4shared.com/get/UfVdldrD/PMP_Exam_Prep_7th_Edition_-_Ri.html

Sign Jacob.jar

Open a DOS command prompt.
Add OraHome\jdk\bin to the PATH:
set PATH=OraHome\jdk\bin;%PATH%
Sign the files, and check the output for success:
OraHome\forms\webutil\sign_webutil OraHome\forms\java\frmwebutil.jar
OraHome\forms\webutil\sign_webutil OraHome\forms\java\jacob.jar

Thursday, March 28, 2013

Froms 10g migration on Oracle ADF

http://download.oracle.com/otndocs/OTNVDD-REA/ppt/FormstoADF2.pdf

Forms Migration with Jheadstart

http://www.oracle.com/technetwork/developer-tools/jheadstart/overview/jhs11-fomrs2adf-overview-130955.pdf

Wednesday, March 27, 2013

How to Sign JAR file

Add OraHome\jdk\bin to the PATH:
set PATH=OraHome\jdk\bin;%PATH%
Sign the files, and check the output for success:
OraHome\forms\webutil\sign_webutil OraHome\forms\java\frmwebutil.jar
OraHome\forms\webutil\sign_webutil OraHome\forms\java\jacob.jar

Using Groovy expression to create summary function in ADF

http://e-ammar.net/Oracle_TIPS/using_groovy_expression_to_creat.htm

Friday, October 5, 2012

Default index page

Configuring the Default Index Page
This section applies to all users, whether you are using PHP as a module or as a CGI binary.
If you create a file index.php, and want Apache to load it as the directory index page for your website, you will have to add another line to the "httpd.conf" file. To do this, look for the line in the file that begins with "DirectoryIndex" and add "index.php" to the list of files on that line. For example, if the line used to be:

DirectoryIndex index.html
change it to:

DirectoryIndex index.php index.html

The next time you access your web server with just a directory name, like "localhost" or "localhost/directory/", Apache will send whatever your index.php script outputs, or if index.php is not available, the contents of index.html.

Multilaunguage







$db = mysql_connect('YOUR_DB_ADDRESS','YOUR_DB_USER','YOUR_DB_PASS') or die("Database error");


mysql_select_db('YOUR_DB', $db);





//SOLUTION::  add this comment before your 1st query -- force multiLanuage support


$result = mysql_query("set names 'utf8'");





$query = "select * from YOUR_DB_TABLE";


$result = mysql_query($query);





//-THE_REST_IS_UP_TO_YOU-





?>





Simply run the query "set names 'utf8' " against the MySQL DB and your output should appear correct.

Multilaunguage

Monday, August 8, 2011

Migration Forms into APEX 3.2

http://www.oracle.com/technology/obe/apex32/apex32frmmigr.htm#p

Tuesday, August 2, 2011

ORACLE SHORT KEYS

http://allhotkeys.com/oracle-hotkeys.html

ESAGE ERP

http://www.esageerp.com/products.html

Automatic Backup

http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
batch file for automatic dataexporter.

echo off
set baseDir=c:\backup\
set vDirName=%date:~0,2%%date:~3,2%%date:~6,4%
set vDumpFileName=%vDirName%-%time:~0,2%-%time:~3,2%-%time:~6,2%

set backupDir=%baseDir%%vDirName%
mkdir %backupDir%

echo direcotr create Date:%baseDir%%vDirName%
echo %vDumpFileName%

expdp scott/naveed schemas=SCOTT directory=TEST_DIR dumpfile=%vDumpFileName%.DMP logfile=%vDumpFileName%.log

move c:\backup\%vDumpFileName%.log c:\backup\%vDirName%
move c:\backup\%vDumpFileName%.DMP c:\backup\%vDirName%
echo successfuly moved.