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

what is the difference between procedure and function

3 Answers   Wipro,


what are the prerequisites for costing transactions?

0 Answers   Scan Steel,


What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,


differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,


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

1 Answers   IBM,


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  


Give a brief overview on OrderManagement.

1 Answers   Zensar,


Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,


What does appl_top directory contain?

0 Answers  


what is difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,


what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,


what are the types of interfacing?

3 Answers   TCS,


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)