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 [...]

Purpose
The Purpose of this Form Personalization is to restrict the list of responsibilities that a user can assign using the ‘Users’ function that access the form FNDSCAUS.
Description
The implementation of this Form Personalization is divided in 3 steps:
1. Restrict the List of Values of the Responsibilities.
2. Restrict the Direct Responsibility List.
3. Restrict the Usernames List.
Form Personalization Function Definition
Responsibility: [...]

Sometimes it’s needed to check what a user can do in the system.
The script functions_x_user.sql can be customized to know which function a user can access.
If you find it useful don’t forget to leave your comment!

Purpose
The Purpose of this Form Personalization is to limit the access to the profile option settings restricting the LoV of the profile options displayed.
Description
The implementation of this Form Personalization is divided in 2 steps:
1. Restrict the Profile Options List of Values.
2. Hide and Disable the un-needed fields.
Form Personalization Definition
Responsibility: System Administrator
Navigate: Application -> Function
Define a [...]

In case there is a misconfiguration of the system, it can happen that when a user tries to reset his password clicking the link ‘Forgot your password?’ the password request approval is sent as a notification and not as email. Obviously if a user doesn’t remember is password cannot access the notifications.
This problem affects any [...]

General Description
The Audit Trail is an Oracle inbuilt functionality that lets audit specific columns belonging to selected tables. This implementation enhances the security of the system.
Purpose
Purpose of this document is to instruct the user to setup the Oracle AuditTrail on the following tables:
• FND_PROFILE_OPTION_VALUES (Profile Option Updates)
• FND_USER (New User Creations or Updates)
• WF_LOCAL_USER_ROLES (Responsibility Assignments)
Getting Started
For [...]