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

What is multoorg and what is it's level or structure

4 Answers IBM,

Which oracle apps version you are very confident in?

0 Answers

what is multi org structure?

3 Answers Covansys, TCS,

What are the benefits of using soa architecture?

0 Answers

what is instead of trigger in where u will use?

2 Answers TCS,

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

0 Answers Accenture,

How to develop XML report without rdf?

4 Answers Oracle,

we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?

1 Answers

please explain open interface import

2 Answers

what is difference between procedure and function

5 Answers E Logic,

what do you mean by value sets

8 Answers Convergys,

Stored procedure?

4 Answers

For more Oracle Apps Technical Interview Questions Click Here