Answer Posted / altaf a shaikh

first create the 5 layouts.Create each layout in a separate
Main frame.You can create 5 main frames one below the
other.No layout should cross x-axis and Y-axis.After that
create one user parameter. and u will wtite formate trigger
for each Main Frame format trigger.
after that u will run the report.

--In format trigger of first Main frame you will mention
-- for first layout to display
if :p_parameter = 1 then
return true;
end if;

--In format trigger of Second Main frame you will mention
-- for Second layout to display
if :p_parameter = 2 then
return true;
end if;

perform above task for remaining 3 main frames.

when You run report.
If You enter p_parameter value as 1 then first layout will
be displayed as output.
If You enter p_parameter value as 2 then second layout will
be displayed as output.

What do you understand by soa and what are the benefits of using this architecture?

1095

---

Can you define an erp system?

1149

---

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?

14972

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2395

---

What are the benefits of using soa architecture?

1254

---

How many schemas we have? how many you have used?

2069

---

What is oracle soa suite?

1249

---

what are the different transaction clauses in AR?

2122

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2635

---

What are the Standard Reports and Forms in HRMS?

2321

---

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1069

---

Can you differentiate between mediator and osb?

1152

---

What do you understand by a set of books?

1118

---

How can you achieve loose coupling in soa framework?

1233

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3071

---