jump to navigation

Protected: Configuration of Oracle Workflow 2.6 Notification Mailer with Oracle Applications 11i April 16, 2008

Posted by Muhammad Habib in Oracle Applications, Oracle Financials.
Enter your password to view comments.

This content is password protected. To view it please enter your password below:

Fellow Bloggers are Welcomed March 28, 2008

Posted by Muhammad Habib in Oracle General.

Dear all visitors ..

This blog was created just to share knowledge and experiences of Oracle. That was a small effort started a year ago. Number of visitors has been raising day by day and around 45,000 visitors have visited it till now.

I want to continue this effort of helping people through technology but due to work load its becoming difficult for me to maintain this blog and to write new posts.

Anybody who is interested to write here on any topic related to oracle specially Oracle Applications, please contact me. All his/her posts will be posted by his/her own name. A user ID will be given to manage posts.

Help others by sharing knowledge…


Download “Oracle Business Intelligence Suite” February 22, 2008

Posted by Muhammad Habib in Oracle Applications, Oracle Financials, Oracle General.

To download Oracle Business Intelligence Suite..

. Go to the site: http://edelivery.oracle.com
. Select English language,
. Fill the user / email form,
. accept it and press go.
. Select E-Business Suite, Microsoft Windows 32-bit and press Go button.
. Select “Oracle® Applications 11i Release 10.2 Media Pack for Microsoft Windows” and press Go button.
. Download “Oracle Business Intelligence Suite Enterprise Edition Windows Programs” part 1, 2 and 3.


Oracle Payables Certification Preparation January 21, 2008

Posted by Muhammad Habib in Oracle Applications, Oracle Financials.

If you want to certify Oracle Payables, I have sudy material for these:

1z0-211 and

You may contact me for details.


Send Email via Oracle Developer December 28, 2007

Posted by Muhammad Habib in Oracle Developer.

Dear All

I found one query regarding how to send email from Oracle Developer. I have posted it here.

create or replace procedure E_MAIL(

p_to in varchar2,
p_from in varchar2,
p_subject in varchar2,
p_text in varchar2 default null,
p_html in varchar2 default null,
p_smtp_hostname in varchar2,
p_smtp_portnum in varchar2)
l_boundary varchar2(255) default ‘a1b2c3d4e3f2g1’;
l_connection utl_smtp.connection;
l_body_html clob := empty_clob; –This LOB will be the email message
l_offset number;
l_ammount number;
l_temp varchar2(32767) default null;
l_connection := utl_smtp.open_connection( p_smtp_hostname, p_smtp_portnum );
utl_smtp.helo( l_connection, p_smtp_hostname );
utl_smtp.mail( l_connection, p_from );
utl_smtp.rcpt( l_connection, p_to );

l_temp := l_temp || ‘MIME-Version: 1.0’ || chr(13) || chr(10);
l_temp := l_temp || ‘To: ‘ || p_to || chr(13) || chr(10);
l_temp := l_temp || ‘From: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Subject: ‘ || p_subject || chr(13) || chr(10);
l_temp := l_temp || ‘Reply-To: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Content-Type: multipart/alternative; boundary=’ ||
chr(34) || l_boundary || chr(34) || chr(13) ||

— Write the headers
dbms_lob.createtemporary( l_body_html, false, 10 );

— Write the text boundary
l_offset := dbms_lob.getlength(l_body_html) + 1;
l_temp := ‘–‘ || l_boundary || chr(13)||chr(10);
l_temp := l_temp || ‘content-type: text/plain; charset=us-ascii’ ||
chr(13) || chr(10) || chr(13) || chr(10);

— Write the plain text portion of the email
l_offset := dbms_lob.getlength(l_body_html) + 1;

— Write the HTML boundary
l_temp := chr(13)||chr(10)||chr(13)||chr(10)||’–‘ || l_boundary ||
chr(13) || chr(10);
l_temp := l_temp || ‘content-type: text/html;’ ||
chr(13) || chr(10) || chr(13) || chr(10);
l_offset := dbms_lob.getlength(l_body_html) + 1;

— Write the HTML portion of the message
l_offset := dbms_lob.getlength(l_body_html) + 1;

— Write the final html boundary
l_temp := chr(13) || chr(10) || ‘–‘ || l_boundary || ‘–‘ || chr(13);
l_offset := dbms_lob.getlength(l_body_html) + 1;

— Send the email in 1900 byte chunks to UTL_SMTP
l_offset := 1;
l_ammount := 1900;
while l_offset < dbms_lob.getlength(l_body_html) loop
l_offset := l_offset + l_ammount ;
l_ammount := least(1900,dbms_lob.getlength(l_body_html) – l_ammount);
end loop;
utl_smtp.quit( l_connection );


After creating this procedure, we can call it from any form or trigger etc. 

Hope it will be helpful.

Regards ….

Installation / Re-Installation of Oracle Database 10g on Windows November 17, 2007

Posted by Muhammad Habib in DBA.
1 comment so far

1.    Take back-up of data (Full Database).
2.    Shutdown your database. (Shutdown Abort).
3.    Take back-up of SP file.
(If you have set some parameters previously according to your environment)
4.    Note the size and names of all table spaces.
5.    Delete Database through wizard (If previously installed).
6.    Run Installer and uninstall Oracle from your system.
7.    Remove Oracle entries from registry.
8.    Restart your system.
9.    Remove Oracle Directory from System.
10.    Check services from Administrative tools. Please verify that there should not any Oracle related service existing in the list. No TNS, no oracle home etc.
11.    Reboot your system.
12.    Run Oracle Installer and start installation. Follow wizard and select options according to your requirements.
13.    When Database is created, verify your work by connecting to database.
14.    Shutdown Database.
15.    Restore SP file.
16.    Start Database.
(Note if you find any error on startup, then you have to generate SP file from init.ora file)
17.    Install patch from its installer and run the related scripts. (It will take around 45 minutes so no need to worry).
18.    Reboot your machine.
19.    Create table spaces by same name and size as we noted in step 4.
20.    Load (Import) backup from dmp file. Create log file as well.
(View log file. If you find any error of “table space already exists”, then don’t worry. It is because we have created the table spaces our selves.)

Good Luck!!!

PO Interface Tables November 13, 2007

Posted by Muhammad Habib in Oracle Applications, Oracle Purchasing.

If some customized system have the data and we want to Generate the interface of PO and to generate the PO directly in Oracle Purchasing; means we enter the data in our system and want a interface that directly generate the entry in PO tables, two interface tables are involved PO_HEADERS_INTERFACE and PO_LINES_INTERFACE:

INSERT INTO po.po_headers_interface
(interface_header_id, batch_id, process_code,
note_to_vendor, action, document_type_code,
currency_code, payment_terms,closed_code,
created_by, rate_type,  rate_date, rate,
agent_name, agent_id, vendor_id,  vendor_site_id,
ship_to_location_id, bill_to_location_id)

INSERT INTO po.po_lines_interface
interface_header_id, line_num,
line_type, item_id, item_description,
unit_of_measure, quantity,
unit_price, promised_date,