Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Wants to know how to disable the Past date in the Calendar LOV in Orcle Forms ?

Ashok AnburajMar 20 2022 — edited May 7 2024

Team
I am Developing a Custom Form for that
I want to know how to disable the Past date in the Calendar LOV or Show an error Message when the user Enter the Past date(This Error Show Not Show for Existing Data , it only shows when user enters the data)

I used when new item Instance ,Post text Item ,When Validate item,Pre text Item Triggers But Nothing Works

When I use The Above triggers It fires for existing data but I want to Show the Error while user Enters the Past date

Query I am Using in Triggers
BEGIN
IF :XX_RESP_DB.END_DATE < SYSDATE-1 THEN
fnd_message.set_string('Please enter Today date or Future Date');
fnd_message.Error;
raise form_trigger_failure;
END IF;

END;

Kindly Help Me It is Very Urgent

Comments
Post Details
Added on Mar 20 2022
7 comments
814 views