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
- 10128 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 u did after ur btech(2009) till now? why did u prefer oracle apps technical?
where do u specify in org_id?
What is a value set? List its various types.
What is instead of trigger in where we will use?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
what is item status? name the related table.
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
Is soa a part of oracle fusion middleware?
How can a process be deployed in soa?
what is MRC? Why it is needed?
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
How to find which company will be conducted Oracle appa interview? Plz help me
Oracle Apps Technical 
