The following code will query some data from the Oracle Database and will export them on a CSV file.
The webserver where this script is executed should have the OCI8 library installed.
The execution of this script can be also scheduled to have a periodic backup of a certain table.
The script below will extract from the system [...]

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, ‘To: $recipient_email’ || UTL_TCP.crlf);
UTL_SMTP.write_data(v_connection, ‘The Subject!’ || [...]

The error ‘The Function Is Not Available Under The Responsibility’ appears rarely after the menu of a responsibility is updated. The problem resolution is quite straight forward.

Action Plan (1)
1) Manually run the ‘Compile Security’ concurrent program, set the parameter to YES.
In case the problem is not solved, then this is another solution.
Action Plan (1)
1) Manually [...]

The Timeout Parameters, can be easily changed through the profile option setup. I would recommend to change the default values against the corporate needs and policies.
The 3 profile options that control the timeout times are:
- ICX:Session Timeout – determines how many minutes a form session can be inactive before the session is disabled. This mean [...]

How often a password reset is required? How long does it take to find time to reset the password manually? Implementing the Self Service Password Reset can save a lot of manual workload and can be done in few easy steps. The workflow, before the to reset the password, will ask the user to [...]