for report i have to parameters those are from_date and
to_date ,so to_date should be greater when compare to
from_date ,if we are giving to_date is less then it must
shows some error how we willmake
Answer Posted / rajesh
I have not been using reports since long back.But as per my
previous knowledge i am giving you this sugession.
We can also validate it at run time by writing small code
in 'After Parameter Form Trigger' like
If :p_from_date > :p_to_date then
srw.message(20001,'You should enter to_date > from_date');
--srw.message();
end if;
OR
If :p_from_date > :p_to_date then
return(false);
else if
return(true);
end if;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Plz anybody send me Technical specification for AP Interface
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
q)what are the validations in sql*loader
How many schemas we have? how many you have used?
Can you differentiate between mediator and osb?
How to move the one file from one instance to another instance? And your scripts also?
testing tools?
What is count(*) from po_vendors(any table)?
How can a process be deployed in soa?
tell my any difficult situtation you solved in your experience in your company?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
List the various types of value set.
tell me the scenarios of the independent in reports
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
is it possible to run the interface without using oracle apps?