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

how to customize the report,please tell me customization steps

5 Answers Accenture,

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

3 Answers IBM,

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers Oracle,

how will u do documentation

2 Answers

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers IBM,

After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers IBM,

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,

How can you achieve loose coupling in soa framework?

0 Answers

How can a process be deployed in soa?

0 Answers

what is mutating table and mutating error and how to solve that?

3 Answers

What is a flexfield? List out its types.

0 Answers

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers CTS, iGate,

For more Oracle Apps Technical Interview Questions Click Here