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 |
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
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
What are documents and test cases u followed.
What are the benefits of using soa architecture?
what is meant by Table space?
What is profile and what is level of profile option and it's hierarchy
How can u populate data into po_headers_all segment2 column?
why we can use synonym?
how can u link a org-id with a responsibility in reports?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
How to create user and how u attach with responsibility.