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
What is instead of trigger in where we will use?
Explain what are the tables of auto invoice?
Can we create tables in apps schema?
Tell me how to debug the report?
What does appl_top directory contain?
Are you familiar with internet architecture of oracle apps 11i?
how to print multi lay outs,muti currency,muti language in xml publisher
List the various types of value set.
How to move the one file from one instance to another instance? And your scripts also?
what is the difference between request group and request security in oracle apps?
What are the Standard Reports and Forms in HRMS?
Can u give the Documentation of Custom.pll in oracle apps
is it possible to run the interface without using oracle apps?
What do you understand by soa?
What is oracle soa suite?