Sending Email using PL/SQL Procedure

Posted by Apurva at 3:34 AM

You can send mails using the following UTL_SMTP package DECLARE   v_From      VARCHAR2(80) := 'oracle@mycompany.com';  ...

Checking the File Versions with SQL Query

Posted by Apurva at 1:47 AM

Many a times we need to check the file versions from our environment. As functional consultants we generally don't have the database ...

Process to Debug a Concurrent Request

Posted by Apurva at 11:22 PM

If the program fails then set the following profiles at User level and rerun the program. Locate the Log and review for errors:  FND: D...

Find Profile Option values using SQL queries

Posted by Apurva at 3:24 AM

Many times we want to find a value for a particular profile option, but cannot find it as we may not have the System Administrator Responsi...