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
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 set function in sql .E.g.What is difference between union and union all
Steps for DFF registration
can we pass bind variablein lexical parameter?
How to register a form and stored procedure in oracle apps
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
What is request group
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
What are do's and dont's of Interface?
explain p2p cycle? what are the tables used for this?
HOW CAN U KNOW THE STAUS OF PO?
where is setup of business group done?
why r u move in the cus_top only why not move another top