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
10123 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

what is instead of trigger in where u will use?

2 Answers TCS,

can u explain which situation automonus transaction is used

2 Answers

What are the requests groups?

3 Answers

How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers Deloitte, Intelligroup,

What is set function in sql .E.g.What is difference between union and union all

2 Answers IBM, TCS,

Plz anybody send me Technical specification for AP Interface

0 Answers Satyam,

What is cursor?

3 Answers

why r u transer the data base tables to flat file and what is use

3 Answers Wipro,

What is ERP? Architecture of apps?

3 Answers TCS,

What is secuirity's in R12 features.