Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 10261 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mylapuram
while defining Parameters you can set range option(in
concurrent prog parameters window).
Select low for from_Date and high for to_Date.Then it will
not allow for from_date > to_date.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
Answer / baba
At the time of defining the concurrent program, in the
parameter window u can register from_date parameter, select
value set, which is provide bt ORACL. i.e FND_STANDARD_DATE
or else query like FND% then it will display some seeded
frormat DATES, then u can choose.
| Is This Answer Correct ? | 0 Yes | 1 No |
what is aim methodolozy
what are the balancing segments in AR?
Can you explain the difference between architecture followed in 10g & 11g?
Tell me some thing about SQL-LOADER.
What is responsibility?
What are do's and dont's of Interface?
How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?
Oder of firing triggers in form
What is workflow?Explain with a example?
Can We Create a Synonym On Trigger?
how many groups we can create for query?
difference b/w procedures&functions
Oracle Apps Technical 
