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 meant by anchoring?
How to call oracle database stored procedure from form in form coding ?
what are the types of interfacing?
What is invoice?
Sys Admin Module?
what do u mean by debit/credit memo invoices?
3 Answers ACC, Convergys, Mascon,
While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions
What multi org tables . example - difference between app table non all table . Po_header and po_headers_all
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,
What is an Index , Types od index why we are use index.
What is OM Cycle and What do u mean by Alternate Item
What is SRW Package? (Sql Report Writer)