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 meant by anchoring?

3 Answers  


How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,


what are the types of interfacing?

3 Answers   TCS,


What is invoice?

3 Answers   Murugappa Group,


Sys Admin Module?

1 Answers  


what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,


While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,


What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,


hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me

2 Answers   Pathway Technologies,


What is an Index , Types od index why we are use index.

2 Answers   IBM,


What is OM Cycle and What do u mean by Alternate Item

3 Answers   IBM,


What is SRW Package? (Sql Report Writer)

1 Answers  


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)