Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,


diff between key and descriptive flexfield.

4 Answers   Convergys,


can we pass bind variablein lexical parameter?

1 Answers   BirlaSoft,


HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  


1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,






Can u define exceptions twice in same block?

3 Answers  


what is organization id

3 Answers  


where u do setup of operating unit?

1 Answers   TCS,


how to move the one file from one instance to another instance?and ur scripts also?

1 Answers   KPMG,


1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,


what is the difference between oracle 8i and 9i?

1 Answers  


Which module is not in multiorg

6 Answers   HCL, Wipro,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • 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)