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



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 difference between po_headers_all and po_headers

2 Answers   NTT Data,


What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,


what is back order in OM

4 Answers   IBM, Oracle,


Tell me some thing about SQL-LOADER.

2 Answers   IBM,


what is difference between API and Interface?

2 Answers   Infogain,






how many layout sections are tehre in layout editor?

1 Answers  


What is SET-OF-BOOKS?

3 Answers  


How do u identity its name of report?

3 Answers  


what is the difference between credit memo and debit memo?...

2 Answers   Sony,


what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,


What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,


maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)