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.

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

2304

---

In oracle application how do you debug or trace errors?

1178

---

where to define interorganization transaction charges and what are the different options?

2465

---

How can a process be deployed in soa?

1336

---

Is soa a part of oracle fusion middleware?

1155

---

What are file in oracle.

2287

---

please send me forms, xml pulisher questions,answers

2160

---

What is oracle soa suite?

1299

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2265

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1165

---

what are the different transaction clauses in AR?

2168

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3734

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3078

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3111

---

How can we import the data into a database using sql * loader?

1243

---