#Script

SCRIPT: Send an Email with PL/SQL

Posted by in Oracle EBS
No Comments

Sometimes it’s needed to send an email using PL/SQL. This can be done with few lines of code pasted below. The variables $server.address, $domain, $sender_email, $recipient_email should be replaced with the relevant information. DECLARE l_retVal INTEGER; v_connection UTL_SMTP.connection; BEGIN v_connection := UTL_SMTP.open_connection(‘$server.address’); UTL_SMTP.helo(v_connection, ‘$domain’); UTL_SMTP.mail(v_connection, ‘$sender_email’); UTL_SMTP.rcpt(v_connection, ‘$recipient_email’); UTL_SMTP.open_data(v_connection); UTL_SMTP.write_data(v_connection, ‘From: $sender_email’ || UTL_TCP.crlf); UTL_SMTP.write_data(v_connection, …

Read More →

HOW-TO: Transfer an Oracle Form Personalization to a Different Environment

Posted by in Oracle EBS
One Comment

After 2 weeks of holiday… I finally wrote the script FormPersonalizationTransfer.sh that automate the transfer of one or more form personalization from an environment to another. This script will take in input the function names associated to each form personalization, will download the *.ldt files and will create the installation script to be executed on …

Read More →