After execution of a report we get parameter layout where we have enter From

After execution of a report we get parameter layout where we
have enter From_date and To_date.After entering From_date
and without entering To_date what happen a report will
execute or not?

Question Posted / roshan

2 Answers
7145 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

After execution of a report we get parameter layout where we have enter From_date and To_date.After..

Answer / kumar

if you have not mentioned any initial values in the parameter
property sheet or if you have not used NVL function in your
query parameter, Obviously report will run without output,it
just display column headings.
otherwise (i mean if you have mentioned any initial values
in the parameter property sheet or if you have used NVL
function in your query parameter) report will run with output

Is This Answer Correct ?

9 Yes

1 No

After execution of a report we get parameter layout where we have enter From_date and To_date.After..

Answer / muneer

IF U NOT MENTION THE TO_DATE THEN BY DEFAULT IT WILL TAKE
NULL IN QUERY AND IT RETURN NULL
SO REPORT WILL RUN BUT DATA WILL NOT DISPLAY

MUNEER

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Oracle Apps Technical Interview Questions

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers Sierra Atlantica,

What are the files we submit while your program move to testing instance?

4 Answers Cap Gemini,

Exception Handilings?

1 Answers

Form development process?

1 Answers

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers IBM,

Are you familiar with internet architecture of oracle apps 11i?

0 Answers

what is meant by bind parameter?

2 Answers Satyam,

How to link modules in apps

3 Answers Zensar,

In report we have to show two Layout? how it is and how we can see from where it?

3 Answers IBM,

what is the use of format trigger?a

3 Answers

Hi Experts How to Create a purchase order without a requisition ?

6 Answers Amdocs, KPMG, Oracle,

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers

For more Oracle Apps Technical Interview Questions Click Here