Oracle Apps: How to create validation for a date parameter using a value set for Oracle Concurrent Program

One of my colleague was looking for a solution to restrict a date parameter on a concurrent program not to allow future dates.This post is to just show how to do that as it could help someone else as well.

Step 1. 
Create a Special Value set as below

Format Type     : Standard Date
Validation Type : Special
 Event                : Validate

 
FND PLSQL "
DECLARE
  v_date DATE:= :!VALUE;
BEGIN
  IF v_date > SYSDATE THEN
    FND_MESSAGE.SET_NAME('FND','FND_GENERIC_MESSAGE');
    FND_MESSAGE.SET_TOKEN('MESSAGE','Please choose current or past date.');
    FND_MESSAGE.RAISE_ERROR;
  END IF;
END;
"

Step 2.
Attach this value set to the Concurrent Program Parameter.

Now try to enter a future date parameter while submitting the concurrent program.

Feel free to point out if anything is wrong/missing in this post

Oracle Apps: FRM-92102: A network error has occured.

At one of our client sites, some of the users were getting the below error when they try to access the environment after a clone.

"FRM-92102: A network error has occured.

        The Forms Client has attemted to reestablish its

              connection to the Server 1 time(s) without success.

                        Please check the network connection and try again later."

Initially we thought, it was something to do with their network connection. Once we confirm that the network is not an issue, we tried to do clear cache on the browser and restarting the machine etc. with no luck.

This got fixed after we cleared the Java cache. Steps to do that is given below.

1. Close all the brower windows

2. Open the Java Control Panel
        Control Panel --> Java

3. Click on Settings button

4. Click on Delete Files

5. Click OK

This will clear the Java Cache. Once the Java Cache is cleared we were able to open the forms screen without any issue.

Feel free to point out if anything is wrong/missing in this post