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?

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

tell me the scenarios of the independent in reports

0 Answers   Accenture, IBM,


What do you understand by a set of books?

0 Answers  


how to call report from oracle oracle apps11i?

3 Answers   Genpact,


In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,


while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  


Tell me where we find the status of order information?

0 Answers  


What is REF Cursor?

19 Answers   Infosys, Intelligroup,


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

2 Answers   Sony,


A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,


In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,


in GL module specifing org_id or not?

1 Answers  


wht is the use of Xml reports over reports6i?

5 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)