for report i have to parameters those are from_date and to_date ,so to

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

Question Posted / raghava

3 Answers
10240 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

for report i have to parameters those are from_date and to_date ,so to_date should be greater when..

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

for report i have to parameters those are from_date and to_date ,so to_date should be greater when..

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

for report i have to parameters those are from_date and to_date ,so to_date should be greater when..

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

Post New Answer

More Oracle Apps Technical Interview Questions

Can you have two stored functions with in the same name?

3 Answers

What do you understand by concurrent programs?

0 Answers

What are Mandatory triggers to write in the block, which is created on view?

5 Answers Oracle,

Is that Possible To create package without Specification , If Yes Give any Examples